菜鸟连接数据库遇到的问题
小弟是新手,处于入门阶段的,所有知识来自自学。现在遇到了一点问题,求各位前辈指点一下,感激不尽!
我的源码是:
public void actionPerformed(ActionEvent e){
if(e.getSource()==sure){
/*连接数据库的语句*/
String user=text.getText().trim();
String mima=密码框.getText().trim();
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载JDBC-ODBC桥驱动程序
con = DriverManager.getConnection(
"jdbc:odbc:图书管理系统"
);//连接数据库
ps=con.createStatement();//Statement 对象用 Connection 的方法 createStatement 创建
rs=ps.executeQuery("select * from 用户");//从数据库中的users表中查询结果*/
if(("".equals(user))||("".equals(mima))){
JOptionPane.showMessageDialog(null, "用户名或密码为空,请重新输入");
}
/*else if(!(("".equals(user))&&("".equals(mima)))){
this.dispose();
new 借阅信息();
}*/
while(rs.next()){//在数据库的表中逐一查询核对信息
if((rs.getString("用户名").trim().equals(user))&&(rs.getString("密码").trim().equals(mima))){
this.dispose();
JOptionPane.showMessageDialog(null,"登陆成功");
new 借阅信息();
}
else if(!((rs.getString("用户名").trim().equals(user))&&(rs.getString("密码").trim().equals(mima)))){
JOptionPane.showMessageDialog(null, "用户名或密码错误,请重新输入");
}
}
}catch (Exception sqle) {
String error = sqle.getMessage();
JOptionPane.showMessageDialog(null, error);
sqle.printStackTrace();
}
}
else if(e.getSource()==cancel){
this.dispose();
}
}
}
小弟在SQL2008中建立了一个名叫“图书管理系统”的数据库,在其中建立了2个表,其中一个叫“用户”,但是此代码在eclipse中没显示错误,但是连接时显示了一些错误,如下:
No data found
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(Unknown Source)
at 图书管理系统.个人借阅查询.actionPerformed(个人借阅查询.java:98)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$400(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
请问怎么解决这个问题,求指点
[解决办法]
http://blog.csdn.net/cannel_2020/article/details/7397273
还不行的话,lz可以看看这个。