58,454
社区成员
发帖
与我相关
我的任务
分享
Connection con;
Statement sql;
ResultSet rs;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ex){
System.out.println(""+ex);
}
try{
con=DriverManager.getConnection("jdbc:odbc:user", "PC2009111417EII", "");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM user");
if(rs.next())
{
JOptionPane.showMessageDialog(this, "成功登陆!");
con.close();
}
else
{
JOptionPane.showMessageDialog(this, "用户名或密码错误");
}
}
catch(SQLException ex)
{
System.out.println(ex);
}
}
rs=sql.executeQuery(" SELECT * FROM yonghu where Sno="+"'"+txt_user.toString()+"'AND Pwd="+"'"+txt_password.toString()+"'");
rs=sql.executeQuery(" SELECT * FROM yonghu where Sno="+"'"+txt_user.toString()+"',Pwd="+"'"+txt_password.toString()+"'");