Bảng dữ liệu đơn giản Users(username,password,gender)
Giao diện thêm dữ liệu
Giao diện so sánh dữ liệu
Code mã hóa chuỗi theo giải thuật md5
[sourcecode language="java"]
public static String md5(String msg) {
try {
MessageDigest md = MessageDigest.getInstance("MD5");
md.update(msg.getBytes());
byte byteData[] = md.digest();
//convert the byte to hex format method 1
StringBuffer sb = new StringBuffer();
for (int i = 0; i < byteData.length; i++) {
sb.append(Integer.toString((byteData[i] & 0xff) + 0x100, 16).substring(1));
}
return sb.toString();
} catch (Exception ex) {
return "";
}
}
[/sourcecode]
Khi nhấn vào nút add
[sourcecode language="java"]
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn;
conn = DriverManager.getConnection("jdbc:sqlserver://ntdan-lt;user=sa;password=Admin@123;database=Northwind;");
PreparedStatement command = conn.prepareStatement("Insert into Users(username, password,gender) values(?,?,?)");
command.setString(1, txtUser.getText());
command.setString(2, MDI_Java_md5.md5(txtPass.getText()));
command.setInt(3, rdMale.isSelected() == true ? 1 : 0);
command.executeUpdate();
JOptionPane.showMessageDialog(this, "Register OK !");
this.setVisible(false);
} catch (Exception ex) {
Logger.getLogger(FrmAdd.class.getName()).log(Level.SEVERE, null, ex);
}
}
[/sourcecode]
Khi nhấn vào nút login
[sourcecode language="java"]
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn;
conn = DriverManager.getConnection("jdbc:sqlserver://ntdan-lt;user=sa;password=Admin@123;database=Northwind;");
PreparedStatement command = conn.prepareStatement("Select * from Users where username=? and password = ?");
command.setString(1, txtUser.getText());
command.setString(2, MDI_Java_md5.md5(txtPass.getText()));
ResultSet rs = command.executeQuery();
if (rs.next()) {
JOptionPane.showMessageDialog(this, "Login OK !");
this.setVisible(false);
} else {
JOptionPane.showMessageDialog(this, "Login fail !");
}
} catch (Exception ex) {
Logger.getLogger(FrmAdd.class.getName()).log(Level.SEVERE, null, ex);
}
}
[/sourcecode]
chúc các bạn thành công.