我在数据库中建立了一个User表,想向其中添加数据,所有代码如下:
try{
String sql="INSERT INTO User VALUES(?,?)";
PreparedStatement ps=con.prepareStatement(sql);
ps.setString(1,userName);
ps.setString(2,passWard);
ps.executeUpdate();
con.close();
JOptionPane.showMessageDialog(this,"添加成功!");
//clearForm();
}
catch(SQLException e){
System.out.println("E Code"+e.getErrorCode());
System.out.println("E M="+e.getMessage());
}
但出现了以下错误,请指教。
E Code156
E M=[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]在关键字 'User' 附近有语法错误。
try{
String sql="INSERT INTO User VALUES(?,?)";
PreparedStatement ps=con.prepareStatement(sql);
ps.setString(1,userName);
ps.setString(2,passWard);
ps.executeUpdate();
con.close();
JOptionPane.showMessageDialog(this,"添加成功!");
//clearForm();
}
catch(SQLException e){
System.out.println("E Code"+e.getErrorCode());
System.out.println("E M="+e.getMessage());
}
但出现了以下错误,请指教。
E Code156
E M=[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]在关键字 'User' 附近有语法错误。
解决方案 »
- 急!!! 这几天正在做一个项目,其中有一个要求是读取服务器上的一个文本文件,不知道该怎么做,请大家给指点一下
- 谁提供一个完整的J2SE→J2EE→J2ME的流程
- 一个java正则表达式的问题( Pattern p=Pattern.compile( "(\\d(,\\d)*|)" ); )
- 怎样给JLabel添加颜色?我菜啊~~
- 急求怎样由byte[]构造Image对象用于绘图
- 请教,鼠标与菜单不对应,该怎么办?谢谢
- C/S模式应需要了解哪些知识?
- java使用ffmpeg转码有回调方法吗?
- 这个是匿名子类还是初始化呢? 大家看下,我初学的
- 急救!!JSP表单提交后的内容无法插入数据库
- 关于Java
- java调用DLL文件问题,急~~~~~
String sql="INSERT INTO User(username,password) VALUES(?,?)";
表名是否正确?user还是User?
表中字段有多少? INSERT INTO User(name,pass) VALUES(?,?)打印异常,获取更多信息
catch(SQLException e){
System.out.println("E Code"+e.getErrorCode());
System.out.println("E M="+e.getMessage());
e.printStackTrace();
}
要不是的话,应该这么写:
String sql="INSERT INTO User(field1,field2) VALUES(?,?)";
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]对象名 'Users' 无效。
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source)
at UserAdd.addFI(UserAdd.java:83)
at UserAdd.actionPerformed(UserAdd.java:60)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:6216)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
at java.awt.Component.processEvent(Component.java:5981)
at java.awt.Container.processEvent(Container.java:2041)
at java.awt.Component.dispatchEventImpl(Component.java:4583)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Component.dispatchEvent(Component.java:4413)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4556)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4220)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4150)
at java.awt.Container.dispatchEventImpl(Container.java:2085)
at java.awt.Window.dispatchEventImpl(Window.java:2475)
at java.awt.Component.dispatchEvent(Component.java:4413)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
ps.setString(1,userName);
ps.setString(2,passWard);set是重0开始把