public class DbOp{
private static String driver="sun.jdbc.odbc.JdbcOdbcDriver";
/**
*jdbc:odbc:bookdb";
*数据库名称是 bookdb
*
**/
private static String url="jdbc:odbc:bookdb";
private static Connection con=null;
private DbOp(){
try{
if(con==null){
Class.forName(driver);
con=DriverManager.getConnection(url);
}
}catch(Exception e){
JOptionPane.showMessageDialog(null,"数据库未能打开!");
System.out.println(e.getMessage());
}
} public void sureActionListener(ActionEvent le){
String user=text_user.getText();//从文本框得到输入的用户名和密码
String pass=text_pass.getText();
String is_admin="";
if(user.equals("")||pass.equals("")){
JOptionPane.showMessageDialog(null,"密码不能为空,请输入密码");
return;
}
try{
/**
*数据库核对密码是否正确,正确就登陆成功
*
*/
String sql="select * from user where username="+"'"+user+"'"+"and password="+"'"+pass+"'";
ResultSet rs=DbOp.executeQuery(sql);
if(rs.next()){
is_admin=rs.getString("is_admin");
}else{
JOptionPane.showMessageDialog(null,"Wrong that is UserNmae or Password ");
return;
}
GlobalVar.login_user=user;
ShowMain show=new ShowMain();
show.setRights(is_admin);
System.out.println("Successed");
dispose();
}catch(SQLException e){
JOptionPane.showMessageDialog(null,"the wrong from information");
}
}
