这是程序:importjava.sql.*;publicclassJDBCTest{publicstaticvoidmain(String[]args){//TODOAuto-generatedmethodstubStringdriver="com.MySQL.jdbc.Driver";Strin...
这是程序:
import java.sql.*;
public class JDBCTest
{
public static void main(String[] args)
{
// TODO Auto-generated method stub
String driver = "com.MySQL.jdbc.Driver";
String url = "jdbc:mysql://127.0.0.1:3306/scutcs";
String user = "root";
String password = "123456";
try
{
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, user, password);
if(!conn.isClosed())
{
System.out.println("Succeeded connecting to database");
}
Statement statement = conn.createStatement();
String sql = "Slect * from student";
ResultSet rs = statement.executeQuery(sql);
System.out.println("---------");
System.out.println("执行结果如下:");
System.out.println("---------");
System.out.println("学号" + "\t" + "姓名");
System.out.println("---------");
String name = null;
while(rs.next())
{
name = rs.getString("sname");
name = new String(name.getBytes("ISO-8859-1"), "GB2312");
System.out.println(rs.getString("sno") + "\t" + name);
}
rs.close();
conn.close();
}
catch(ClassNotFoundException e)
{
System.out.println("Sorry, can't find the driver");
e.printStackTrace();
}
catch(SQLException e)
{
e.printStackTrace();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
这是运行结果:
Sorry, can't find the driver
java.lang.ClassNotFoundException: com.MySQL.jdbc.Driver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at JDBCTest.main(JDBCTest.java:18)
展开