uboger / librarymanager Goto Github PK

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");
   	}
   }