有 Java 编程相关的问题?

你可以在下面搜索框中键入要查询的问题!

java结果集rs=st.executeQuery(sql);不起作用

我在jdk1中使用这个程序。7和java 64位以及ms access数据库,但问题是我在执行程序后无法得到任何结果,检查后我看到了(ResultSet rs=st.executeQuery(sql);)当我可以获取(sql)值但无法获取(rs)值时不工作 注意:我完成了所有步骤,用ODBC(64位)连接文件

package package1;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.awt.FlowLayout;
import javax.swing.JPasswordField;
public class Authentication
{
Connection con;
Statement st;
ResultSet rs;
JFrame f = new JFrame("User Login");
JLabel l = new JLabel("Username");
JLabel l1 = new JLabel("Password");
JTextField t = new JTextField(10);
JPasswordField t1 = new JPasswordField(10);
JButton b = new JButton("Login");
public Authentication()
{
connect();
frame();
}
public void connect()
{


final String fileName = "c:/db2.accdb";
Connection con = null;
try
{  
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
Class.forName(driver);
String url = "jdbc:odbc:Driver={Microsoft Access Driver *.mdb,*.accdb)};DBQ="+fileName;
con = DriverManager.getConnection(url,"","");

}
catch(Exception ex)
{
}
}
public void frame()
{ 
f.setSize(400, 100);
f.setLocationRelativeTo(null);
f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
f.setVisible(true);
JPanel p = new JPanel();
p.add(l);
p.add(t);
p.add(l1);
p.add(t1);
p.add(b);
f.add(p);
b.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
try
{
String user = t.getText().trim();
//String pass = t1.getText().trim();
String pass = new String(t1.getPassword());
//String sql = "select user, pass from UserPass where user='"+user+"'and pass = '"+pass+"'";
String sql="SELECT user,pass FROM ADB1 WHERE user = '"+user+"' and pass = '"+pass+"'";
System.out.println(sql);

ResultSet rs = st.executeQuery(sql);

System.out.println("rs"+rs);
int count = 0;
while(rs.next())
{
count = count +1;
}
if(count == 1)
{
JOptionPane.showMessageDialog(null, " You have successfully logged in!");
f.setVisible(false);

}
else if (count > 1)
 {
JOptionPane.showMessageDialog(null, "Duplicate User, Access Denied! Please contact    administrator.");
}
else
{
JOptionPane.showMessageDialog(null, "Username and password is incorrect. Please try to enter your username and password.");
}
}
catch(Exception ex)
{
}
}
}); 
}

}

共 (0) 个答案