1、连接本地MySQL数据库
test.java
public static Connection getConn() {
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/xxx";
String username = "root";
String password = "xxx";
Connection conn = null;
try {
Class.forName(driver);
conn = (Connection) DriverManager.getConnection(url, username, password);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
2、判断登录是否成功
test.java
public boolean select(String login,String pass){
Connection conn=test1.getConn();
String sql = "select * from manage where username = '"+login+"'";
PreparedStatement pstmt;
try {
pstmt = (PreparedStatement)conn.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
rs.next(); if(rs.getString("username").equals(login)&&rs.getString("password").equals(pass)){
return true;
}
} catch (SQLException e) {
e.printStackTrace();
}
return false;
}
第三行String sql = “select * from manage where username = ‘”+login+”’”; 若改成:
String sql = "select * from manage where username = "+login+"";
查询时则报错:
Unknown column ‘xxx’ in ‘where clause’
如果查询的login是整型的话就不会出现错误,而如果查询的login为String类型,则必须要包含在引号内。
3、为button设置监听器
Login1.java
test t1=new test1();
JButton btnNewButton = new JButton("登录");
btnNewButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
if(t1.select(login.getText(), new String(pass.getPassword()))){
Login1.this.dispose();
Te frame=new Te();
JOptionPane.showMessageDialog(null, "登录成功", "succeed",JOptionPane.PLAIN_MESSAGE);
frame.setVisible(true);//成功则跳转到Te.java
}
else {
JOptionPane.showMessageDialog(null,"用户名或密码输入错误","erro",JOptionPane.ERROR_MESSAGE);
pass.setText("");
}
}
});
第四行 new String ( pass.getPassword () ) 改成 pass.getPassword( ).toString 则报错
getPassword()的返回值是char[ ],使用了String类的String(char[] chars)构造方法得到字符串
第五行Login1.this.dispose();
不能用this.dispose(),因为this表示的是当前对象,指的是实现ActionListener的匿名内部类的对象,为了得到外部类Login1的对象,就必须用Login1.this。