数据库查询问题

[shyboy1982]

package aircondition;
import java.awt.BorderLayout;
import javax.swing.JPanel;
import java.awt.Color;
import javax.swing.JSplitPane;
import java.awt.*;
import javax.swing.*;
import javax.swing.border.TitledBorder;
import com.borland.dbswing.TableScrollPane;
import com.borland.dbswing.JdbTable;
import com.borland.dx.dataset.*;
import com.borland.dbswing.*;
import com.borland.dx.sql.dataset.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Connection;
public class userqueryPanel extends JPanel {
BorderLayout borderLayout1 = new BorderLayout();
JSplitPane jSplitPane1 = new JSplitPane();
JPanel jPanel1 = new JPanel();
JScrollPane jScrollPane1 = new JScrollPane();
TableScrollPane tableScrollPane1 = new TableScrollPane();
JdbTable jdbTable1 = new JdbTable();
Database database1 = new Database();

public userqueryPanel() {
try {

jbInit();
}
catch(Exception ex) {
ex.printStackTrace();
}
}
void jbInit() throws Exception {

this.setLayout(borderLayout1);
jSplitPane1.setOrientation(JSplitPane.VERTICAL_SPLIT);
jPanel1.setLayout(null);

database1.setConnection( new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:airconnodbc","sa","", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1,"select userid,password,usertype from Tuserlogin where userid ='"+userid1+"' and usertype = '"+usertype1+"'", null, true, Load.ALL));
jdbTable1.setBorder(BorderFactory.createLoweredBevelBorder());
jdbTable1.setDataSet(queryDataSet1);
column1.setCaption("用户号");
column1.setColumnName("userid");
column1.setDataType(com.borland.dx.dataset.Variant.STRING);
column1.setTableName("Tuserlogin");
column1.setServerColumnName("userid");
column1.setSqlType(4);
column2.setCaption("用户密码");
column2.setColumnName("password");
column2.setDataType(com.borland.dx.dataset.Variant.STRING);
column2.setTableName("Tuserlogin");
column2.setServerColumnName("password");
column2.setSqlType(4);
column3.setCaption("用户类型");
column3.setColumnName("usertype");
column3.setDataType(com.borland.dx.dataset.Variant.STRING);
column3.setTableName("userlogin");
column3.setServerColumnName("usertype");
column3.setSqlType(93);
jPanel1.setBackground(new Color(212, 243, 243));
jPanel1.setBorder(BorderFactory.createEtchedBorder());
tableScrollPane1.getViewport().setBackground(new Color(223, 230, 243));
tableScrollPane1.setBorder(BorderFactory.createLoweredBevelBorder());
jLabel1.setText("用户名:");
jLabel1.setBounds(new Rectangle(31, 5, 64, 26));
jLabel2.setText("用户类型:");
jLabel2.setBounds(new Rectangle(32, 36, 73, 22));
jTextField1.setText("");
jTextField1.setBounds(new Rectangle(151, 9, 88, 19));
jComboBox1.setForeground(Color.red);
jComboBox1.setBounds(new Rectangle(149, 33, 93, 20));
jButton1.setBounds(new Rectangle(285, 9, 82, 20));
jButton1.setText("jButton1");
jButton1.addActionListener(new userqueryPanel_jButton1_actionAdapter(this));
jButton2.setBounds(new Rectangle(286, 33, 76, 21));
jButton2.setText("jButton2");
jScrollPane1.setBorder(BorderFactory.createLoweredBevelBorder());
this.add(jSplitPane1, BorderLayout.CENTER);
jSplitPane1.add(jPanel1, JSplitPane.LEFT);
jPanel1.add(jLabel1);
jPanel1.add(jLabel2);
jPanel1.add(jComboBox1);
jPanel1.add(jTextField1);
jPanel1.add(jButton1);
jPanel1.add(jButton2);
jComboBox1.addItem("管理员");
jComboBox1.addItem("普通用户");
jSplitPane1.add(jScrollPane1, JSplitPane.RIGHT);
jScrollPane1.getViewport().add(tableScrollPane1, null);
tableScrollPane1.getViewport().add(jdbTable1, null);
queryDataSet1.setColumns(new Column[] {column1, column2, column3});
jSplitPane1.setDividerLocation(60);
}

private String userid1="001";
private String usertype1="管理员";
QueryDataSet queryDataSet1 = new QueryDataSet();
Column column1 = new Column();
Column column2 = new Column();
Column column3 = new Column();
JLabel jLabel1 = new JLabel();
JLabel jLabel2 = new JLabel();
JTextField jTextField1 = new JTextField();
JComboBox jComboBox1 = new JComboBox();
JButton jButton1 = new JButton();
JButton jButton2 = new JButton();
public void jButton1_actionPerformed(ActionEvent e) {
}
}
class userqueryPanel_jButton1_actionAdapter implements ActionListener {
private userqueryPanel adaptee;
userqueryPanel_jButton1_actionAdapter(userqueryPanel adaptee) {
this.adaptee = adaptee;
}

public void actionPerformed(ActionEvent e) {
adaptee.jButton1_actionPerformed(e);
}
}

[shyboy1982]

显示原因1:

See com.borland.dx.dataset.DataSetException error code: BASE+47 com.borland.dx.dataset.DataSetException: Chain of 2 or more Exceptions occurred at com.borland.dx.dataset.DataSetException.a(Unknown Source) at com.borland.dx.dataset.DataSetException.throwExceptionChain(Unknown Source) at com.borland.dx.sql.dataset.JdbcProvider.c(Unknown Source) at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source) at com.borland.dx.dataset.StorageDataSet.a(Unknown Source) at com.borland.dx.dataset.DataSet.a(Unknown Source) at com.borland.dx.dataset.DataSet.open(Unknown Source) at com.borland.dbswing.JdbTable.bindDataSet(JdbTable.java:2773) at com.borland.dbswing.JdbTable.addNotify(JdbTable.java:2757) at java.awt.Container.addNotify(Container.java:2049) at javax.swing.JComponent.addNotify(JComponent.java:4288) at java.awt.Container.addNotify(Container.java:2049) at javax.swing.JComponent.addNotify(JComponent.java:4288) at java.awt.Container.addNotify(Container.java:2049) at javax.swing.JComponent.addNotify(JComponent.java:4288) at java.awt.Container.addNotify(Container.java:2049) at javax.swing.JComponent.addNotify(JComponent.java:4288) at java.awt.Container.addNotify(Container.java:2049) at javax.swing.JComponent.addNotify(JComponent.java:4288) at java.awt.Container.addNotify(Container.java:2049) at javax.swing.JComponent.addNotify(JComponent.java:4288) at java.awt.Container.addImpl(Container.java:658) at javax.swing.JLayeredPane.addImpl(JLayeredPane.java:204) at java.awt.Container.add(Container.java:518) at javax.swing.JRootPane.setContentPane(JRootPane.java:558) at javax.swing.JFrame.setContentPane(JFrame.java:615) at aircondition.menuFrame.jMenuItem19_actionPerformed(menuFrame.java:286) at aircondition.menuFrame_jMenuItem19_actionAdapter.actionPerformed(menuFrame.java:300) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786) at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) at javax.swing.AbstractButton.doClick(AbstractButton.java:289) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1113) at javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(BasicMenuItemUI.java:943) at java.awt.Component.processMouseEvent(Component.java:5100) at java.awt.Component.processEvent(Component.java:4897) at java.awt.Container.processEvent(Container.java:1569) at java.awt.Component.dispatchEventImpl(Component.java:3615) at java.awt.Container.dispatchEventImpl(Container.java:1627) at java.awt.Component.dispatchEvent(Component.java:3477) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128) at java.awt.Container.dispatchEventImpl(Container.java:1613) at java.awt.Window.dispatchEventImpl(Window.java:1606) at java.awt.Component.dispatchEvent(Component.java:3477) at java.awt.EventQueue.dispatchEvent(EventQueue.java:456) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137) at java.awt.EventDispatchThread.run(EventDispatchThread.java:100) Chained exception: java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]对于造型说明无效的字符值 at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115) at sun.jdbc.odbc.JdbcOdbc.SQLGetDataStringTimestamp(JdbcOdbc.java:4211) at sun.jdbc.odbc.JdbcOdbcResultSet.getDataStringTimestamp(JdbcOdbcResultSet.java:5809) at sun.jdbc.odbc.JdbcOdbcResultSet.getTimestamp(JdbcOdbcResultSet.java:1054) at com.borland.dx.sql.dataset.JdbcProvider.a(Unknown Source) at com.borland.dx.sql.dataset.JdbcProvider.c(Unknown Source) at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source) at com.borland.dx.dataset.StorageDataSet.a(Unknown Source) at com.borland.dx.dataset.DataSet.a(Unknown Source) at com.borland.dx.dataset.DataSet.open(Unknown Source) at com.borland.dbswing.JdbTable.bindDataSet(JdbTable.java:2773) at com.borland.dbswing.JdbTable.addNotify(JdbTable.java:2757) at java.awt.Container.addNotify(Container.java:2049) at javax.swing.JComponent.addNotify(JComponent.java:4288) at java.awt.Container.addNotify(Container.java:2049) at javax.swing.JComponent.addNotify(JComponent.java:4288) at java.awt.Container.addNotify(Container.java:2049) at javax.swing.JComponent.addNotify(JComponent.java:4288) at java.awt.Container.addNotify(Container.java:2049) at javax.swing.JComponent.addNotify(JComponent.java:4288) at java.awt.Container.addNotify(Container.java:2049) at javax.swing.JComponent.addNotify(JComponent.java:4288) at java.awt.Container.addNotify(Container.java:2049) at javax.swing.JComponent.addNotify(JComponent.java:4288) at java.awt.Container.addImpl(Container.java:658) at javax.swing.JLayeredPane.addImpl(JLayeredPane.java:204) at java.awt.Container.add(Container.java:518) at javax.swing.JRootPane.setContentPane(JRootPane.java:558) at javax.swing.JFrame.setContentPane(JFrame.java:615) at aircondition.menuFrame.jMenuItem19_actionPerformed(menuFrame.java:286) at aircondition.menuFrame_jMenuItem19_actionAdapter.actionPerformed(menuFrame.java:300) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786) at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) at javax.swing.AbstractButton.doClick(AbstractButton.java:289) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1113) at javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(BasicMenuItemUI.java:943) at java.awt.Component.processMouseEvent(Component.java:5100) at java.awt.Component.processEvent(Component.java:4897) at java.awt.Container.processEvent(Container.java:1569) at java.awt.Component.dispatchEventImpl(Component.java:3615) at java.awt.Container.dispatchEventImpl(Container.java:1627) at java.awt.Component.dispatchEvent(Component.java:3477) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198) at java.awt.LightweightDispatc

[shyboy1982]

显示原因2：
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]对于造型说明无效的字符值 at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115) at sun.jdbc.odbc.JdbcOdbc.SQLGetDataStringTimestamp(JdbcOdbc.java:4211) at sun.jdbc.odbc.JdbcOdbcResultSet.getDataStringTimestamp(JdbcOdbcResultSet.java:5809) at sun.jdbc.odbc.JdbcOdbcResultSet.getTimestamp(JdbcOdbcResultSet.java:1054) at com.borland.dx.sql.dataset.JdbcProvider.a(Unknown Source) at com.borland.dx.sql.dataset.JdbcProvider.c(Unknown Source) at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source) at com.borland.dx.dataset.StorageDataSet.a(Unknown Source) at com.borland.dx.dataset.DataSet.a(Unknown Source) at com.borland.dx.dataset.DataSet.open(Unknown Source) at com.borland.dbswing.JdbTable.bindDataSet(JdbTable.java:2773) at com.borland.dbswing.JdbTable.addNotify(JdbTable.java:2757) at java.awt.Container.addNotify(Container.java:2049) at javax.swing.JComponent.addNotify(JComponent.java:4288) at java.awt.Container.addNotify(Container.java:2049) at javax.swing.JComponent.addNotify(JComponent.java:4288) at java.awt.Container.addNotify(Container.java:2049) at javax.swing.JComponent.addNotify(JComponent.java:4288) at java.awt.Container.addNotify(Container.java:2049) at javax.swing.JComponent.addNotify(JComponent.java:4288) at java.awt.Container.addNotify(Container.java:2049) at javax.swing.JComponent.addNotify(JComponent.java:4288) at java.awt.Container.addNotify(Container.java:2049) at javax.swing.JComponent.addNotify(JComponent.java:4288) at java.awt.Container.addImpl(Container.java:658) at javax.swing.JLayeredPane.addImpl(JLayeredPane.java:204) at java.awt.Container.add(Container.java:518) at javax.swing.JRootPane.setContentPane(JRootPane.java:558) at javax.swing.JFrame.setContentPane(JFrame.java:615) at aircondition.menuFrame.jMenuItem19_actionPerformed(menuFrame.java:286) at aircondition.menuFrame_jMenuItem19_actionAdapter.actionPerformed(menuFrame.java:300) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786) at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) at javax.swing.AbstractButton.doClick(AbstractButton.java:289) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1113) at javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(BasicMenuItemUI.java:943) at java.awt.Component.processMouseEvent(Component.java:5100) at java.awt.Component.processEvent(Component.java:4897) at java.awt.Container.processEvent(Container.java:1569) at java.awt.Component.dispatchEventImpl(Component.java:3615) at java.awt.Container.dispatchEventImpl(Container.java:1627) at java.awt.Component.dispatchEvent(Component.java:3477) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128) at java.awt.Container.dispatchEventImpl(Container.java:1613) at java.awt.Window.dispatchEventImpl(Window.java:1606) at java.awt.Component.dispatchEvent(Component.java:3477) at java.awt.EventQueue.dispatchEvent(EventQueue.java:456) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137) at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)