62,616
社区成员
发帖
与我相关
我的任务
分享
<%@page contentType="text/html;charset=gbk"%>
<%@page import="java.sql.*"%>
<%
String DBDriver = "com.mysql.jdbc.Driver";
String URL = "jdbc:mysql://localhost/mldn";
String DBUser = "root";
String DBPassword = "root";
Connection conn = null;
Statement stmt = null;
String sql = null;
ResultSet rs = null;
boolean bl = false;
String name = request.getParameter("uanme");
String password = request.getParameter("upass");
%>
<%
try {
Class.forName(DBDriver);
} catch(Exception e) {
out.println("数据库驱动程序加载失败");
}
try {
conn = DriverManager.getConnection(URL,DBUser,DBPassword);
} catch(Exception e) {
out.println("数据库连接失败");
}
try {
stmt = conn.createStatement();
} catch(Exception e) {
out.println("Statement创建失败");
}
sql = "select name from person where name ='"+name+"' and password='"+password+"'";
rs = stmt.executeQuery(sql);
if(rs.next()) {
bl = true;
}
System.out.println(bl);
try {
rs.close();
stmt.close();
conn.close();
} catch(Exception e) {
out.println("数据库关闭失败");
}
if(bl) {
%>
<jsp:forward page="login_success.jsp"/>
<%
} else{
%>
<jsp:forward page="login_failure.jsp"/>
<%
}
%>
%>