帮忙看看这个问题?
数据库是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();
}
}