主题:各位高手,帮小弟看看这个SQLServer问题吧.....
各位高手们,帮小弟看看这个问题怎么解决吧,就是在用java对SQLServer数据库中插入数据出现了这个问题
下面是代码:
public void startConnect(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){
System.out.println("ERROR to connect SQLServer");
}
try{
mf=new MainFrame();
String text=mf.userField.getText();
String text1=mf.passwordField.getText();
String myString="insert into text(UName,UPassword)values('"+text+"','"+text1+"')";
String url="jdbc:odbc:test";
Connection con=DriverManager.getConnection(url);
Statement s=con.createStatement();
ResultSet rs=s.executeQuery(myString);
rs.close();
s.close();
con.close();
}catch(SQLException ex){
ex.printStackTrace();
}
}
其中的MainFrame是一个图形界面的输入类,表单只有两行,一行是用户名,一行是密码,
我把text和text1换成一个确定的字符串就能够实现正常的插入了,可是要接受界面中输入的动态数据就不行了啊,我都不知道怎么回事了啊,数据源注册没什么问题,表格也没问题,就是不知道错在那里了,而且老是报同一个错误:
java.sql.SQLException: No ResultSet was produced
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:259)
at jdbctest.Connect.startConnect(Connect.java:42)
at jdbctest.Connect.<init>(Connect.java:26)
at jdbctest.MainFrame.actionPerformed(MainFrame.java:83)
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:6038)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3260)
at java.awt.Component.processEvent(Component.java:5803)
at java.awt.Container.processEvent(Container.java:2058)
at java.awt.Component.dispatchEventImpl(Component.java:4410)
at java.awt.Container.dispatchEventImpl(Container.java:2116)
at java.awt.Component.dispatchEvent(Component.java:4240)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
at java.awt.Container.dispatchEventImpl(Container.java:2102)
at java.awt.Window.dispatchEventImpl(Window.java:2429)
at java.awt.Component.dispatchEvent(Component.java:4240)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
高手们,帮帮小弟吧,感激涕淋!
下面是代码:
public void startConnect(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){
System.out.println("ERROR to connect SQLServer");
}
try{
mf=new MainFrame();
String text=mf.userField.getText();
String text1=mf.passwordField.getText();
String myString="insert into text(UName,UPassword)values('"+text+"','"+text1+"')";
String url="jdbc:odbc:test";
Connection con=DriverManager.getConnection(url);
Statement s=con.createStatement();
ResultSet rs=s.executeQuery(myString);
rs.close();
s.close();
con.close();
}catch(SQLException ex){
ex.printStackTrace();
}
}
其中的MainFrame是一个图形界面的输入类,表单只有两行,一行是用户名,一行是密码,
我把text和text1换成一个确定的字符串就能够实现正常的插入了,可是要接受界面中输入的动态数据就不行了啊,我都不知道怎么回事了啊,数据源注册没什么问题,表格也没问题,就是不知道错在那里了,而且老是报同一个错误:
java.sql.SQLException: No ResultSet was produced
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:259)
at jdbctest.Connect.startConnect(Connect.java:42)
at jdbctest.Connect.<init>(Connect.java:26)
at jdbctest.MainFrame.actionPerformed(MainFrame.java:83)
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:6038)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3260)
at java.awt.Component.processEvent(Component.java:5803)
at java.awt.Container.processEvent(Container.java:2058)
at java.awt.Component.dispatchEventImpl(Component.java:4410)
at java.awt.Container.dispatchEventImpl(Container.java:2116)
at java.awt.Component.dispatchEvent(Component.java:4240)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
at java.awt.Container.dispatchEventImpl(Container.java:2102)
at java.awt.Window.dispatchEventImpl(Window.java:2429)
at java.awt.Component.dispatchEvent(Component.java:4240)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
高手们,帮帮小弟吧,感激涕淋!