帮忙看看这个问题?

sourceid 2004-08-29 08:14:58
数据库是Mysql,已经启动。操作系统是Winxp.驱动程序
mysql-connector-java-3.1.3-beta-bin。jar已放进
jre\lib\ext,另外classpath也写有。

ExecSQL.java编译通过,但执行时出现
>java ExecSQL Systemsafe.sql
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:198)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:186)
at java.lang.ClassLoader.loadClass(ClassLoader.java:299)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:265)
at java.lang.ClassLoader.loadClass(ClassLoader.java:255)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:140)
at ExecSQL.main(ExecSQL.java:27)

ExecSql.java

import java.io.*;
import java.util.*;
import java.sql.*;
import javax.sql.*;

/**
Executes all SQL statements in a file.
Call this program as
java -classpath driverPath:. ExecSQL commandFile
*/
class ExecSQL
{
public static void main (String args[])
{

try
{

Reader reader;
if (args.length == 0)
reader = new InputStreamReader(System.in);
else
reader = new FileReader(args[0]);

String url="jdbc:mysql://localhost:3306/test?user=root&useUnicode=true&characterEncoding=gb2312";

Class.forName("com.mysql.jdbc.Driver").newInstance();

Connection conn = DriverManager.getConnection(url,"root","");
Statement stat = conn.createStatement();

BufferedReader in = new BufferedReader(reader);

boolean done = false;

while (!done)
{
if (args.length == 0)
System.out.println(
"Enter command or a blank line to exit:");

String line = in.readLine();

if (line == null || line.length() == 0)
done = true;
else
{
try
{
boolean hasResultSet = stat.execute(line);
if (hasResultSet)
showResultSet(stat);
}
catch (SQLException ex)
{
while (ex != null)
{
ex.printStackTrace();
ex = ex.getNextException();
}
}
}
}

in.close();
stat.close();
conn.close();
}
catch (Exception ex)
{
ex.printStackTrace();
}
}


/**
Prints a result set.
@param stat the statement whose result set should be
printed
*/
public static void showResultSet(Statement stat)
throws SQLException
{
ResultSet result = stat.getResultSet();
ResultSetMetaData metaData = result.getMetaData();
int columnCount = metaData.getColumnCount();

for (int i = 1; i <= columnCount; i++)
{
if (i > 1) System.out.print(", ");
System.out.print(metaData.getColumnLabel(i));
}
System.out.println();

while (result.next())
{
for (int i = 1; i <= columnCount; i++)
{
if (i > 1) System.out.print(", ");
System.out.print(result.getString(i));
}
System.out.println();
}
result.close();
}
}
...全文
57 3 打赏 收藏 转发到动态 举报
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
sourceid 2004-08-30
  • 打赏
  • 举报
回复
已经搞掂,谢谢关注.
playboylee 2004-08-30
  • 打赏
  • 举报
回复
是什么问题呢?我看不出
playboylee 2004-08-30
  • 打赏
  • 举报
回复
MYSQL的包你都放好了吗?

帮你顶

62,615

社区成员

发帖
与我相关
我的任务
社区描述
Java 2 Standard Edition
社区管理员
  • Java SE
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧