Question

java中如何用数据库做一个登陆界面(其中有老师和学生、辅导员登陆）

• 你的回答被采纳后将获得：
• 系统奖励15（财富值+成长值）+难题奖励10（财富值+成长值）+提问者悬赏20（财富值+成长值）

Answer 1

使用JDBC连接SQL数据库就可以了
至于如何使用，自行百度吧，
/* 连接数据库，验证用户 */
try {
Class.forName(MainFrame.DB_NAME);
connect = DriverManager.getConnection(MainFrame.DB_URL, "sa",
"server");
list = connect.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
} catch (ClassNotFoundException | SQLException e1) {
JOptionPane.showMessageDialog(null, e1.toString());
}
try {
// ///////////* 验证登录用户*////////////////////////////////
result = list
.executeQuery("select * from UserInfo where UserID='"
+ text_UserName.getText().toString().trim()
+ "' and Password='"
+ new String(text_Password.getPassword()) + "'");
while (result.next()) {
flag = true;
choice = 1;
MainFrame.login_name = text_UserName.getText().toString()
.trim();
break;
}
if (!flag) {
result = list
.executeQuery("select * from ReadersInfo where ReaderID='"
+ text_UserName.getText().toString().trim()
+ "' and Password='"
+ new String(text_Password.getPassword())
+ "'");
while (result.next()) {
flag = true;
choice = 2;
MainFrame.login_name = text_UserName.getText()
.toString().trim();
break;
}
}
参考一下