|
#2
紫月一殇雪2015-12-22 19:31
你这个顺序就有问题，
难道不是应该先获得驱动 Class.forName(driverClass); 然后得到DriverManager, 使用DriverManager的getConnection()方法得到连接源con; 然后才是你下面的代码  程序代码：con.open(); //打开连接 Statement sql = (Statement) con.createStatement();//实例化对象 // String s = "NSERT INTO x2(id,PASSWORD) VALUES('liuyuyu',5)"; // Class.forName(driverClass);//加载驱动的; 这段代码上移 System.out.println(con); sql.executeUpdate(s); con.close(); } 不过你的这些代码与数据库交互，记得加try-catch块去捕获异常。 [此贴子已经被作者于2015-12-22 19:32编辑过] |
程序代码：import java.sql.DriverManager;
import java.sql.SQLException;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
public class 数据库{
private static String user = "root";
private static String password = "1230";
private static String driverClass = "com.mysql.jdbc.Driver";
private static String url = "jdbc:mysql:///x";
public static void main(String[] args) throws SQLException, Exception {
wo();
}
private static void wo() throws SQLException, Exception {
// TODO 自动生成的方法存根
Connection con = (Connection) DriverManager.getConnection(url,user,password);
Statement sql = (Statement) con.createStatement();//实例化对象
//
String s = "NSERT INTO x2(id,PASSWORD) VALUES('liuyuyu',5)";
Class.forName(driverClass);//加载驱动的;
System.out.println(con);
sql.executeUpdate(s);
con.close();
}
}
报错
com.mysql.jdbc.JDBC4Connection@6193b845
Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NSERT INTO x2(id,PASSWORD) VALUES('liuyuyu',5)' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1605)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1524)
at 数据库.数据库.wo(数据库.java:31)
at 数据库.数据库.main(数据库.java:18)