public void AddShujuku(){
Connection con;
Statement sql;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){
System.out.println(""+e);
}
try{
String strSQL;
strSQL="insert into 用户管理 (用户名,密码) values('";
strSQL=strSQL+text1.getText().trim()+"','";
strSQL=strSQL+text2.getText().trim()+"')";
con=DriverManager.getConnection("jdbc:odbc:图书管理系统","","");
sql=con.createStatement();
sql.executeUpdate(strSQL);
JOptionPane.showMessageDialog(null,"添加成功!");
con.close();
}
catch(SQLException e1){}
}想往数据i库里插入数据,可为啥插不进去呢?
Connection con;
Statement sql;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){
System.out.println(""+e);
}
try{
String strSQL;
strSQL="insert into 用户管理 (用户名,密码) values('";
strSQL=strSQL+text1.getText().trim()+"','";
strSQL=strSQL+text2.getText().trim()+"')";
con=DriverManager.getConnection("jdbc:odbc:图书管理系统","","");
sql=con.createStatement();
sql.executeUpdate(strSQL);
JOptionPane.showMessageDialog(null,"添加成功!");
con.close();
}
catch(SQLException e1){}
}想往数据i库里插入数据,可为啥插不进去呢?
代码最后的catch(SQLException e1)部分最后写上一些代码,这样你可以获得异常的一些信息,对程序的调试也有帮助。你在前面的帖子http://community.csdn.net/Expert/topic/5486/5486683.xml?temp=.5896112不是在问吗?为何又新开一贴?呵呵BTW,你这帖子的名字有点……
你把两个try块外面套上一个static{}试试看
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3111)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(JdbcOdbcStatement.java:288)
at bookmanagersystem.UserAdd.AddShujuku(UserAdd.java:147)
at bookmanagersystem.UserAdd$1.mouseClicked(UserAdd.java:114)
at java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:212)
at java.awt.Component.processMouseEvent(Component.java:5491)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3126)
at java.awt.Component.processEvent(Component.java:5253)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3955)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3901)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1774)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)这些是异常,我一点都看不懂啊~~说了个啥?
System.out.println(strSQL);
这句话加在
con=DriverManager.getConnection("jdbc:odbc:图书管理系统","","");
的前面,看输出是什么?