javaEE课程设计(11)

桂林电子科技大学 计算机与工程学院 信息管理与信息系统 JavaEE 课程设计 报告

private String username;

private String password;

//省略set和get方法

public static void main(String args[]) {

LoginBean lb = new LoginBean();

System.out.println(lb.checklogin());

}

//用于测试的驱动程序

//登录验证函数

public boolean checklogin() {

boolean loginflag = false;

Connection conn = null;

Statement stmt = null;

ResultSet rs = null;

try {

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;" + " DatabaseName=MyTest", "root", "123");

stmt = conn.createStatement();

String sql = "select * from MyTest where UserName='" + username + "'"; rs = stmt.executeQuery(sql);

System.out.println(username);

while (rs.next()) {

if (password.equals(rs.getString("Password").trim())) {

loginflag = true;

}

}

} catch (Exception e) {

e.printStackTrace();

} finally {

if (conn != null) {

try {

conn.close();

} catch (SQLException s) {

s.printStackTrace();

}

}

}

return loginflag;//返回登录标致

}