问题描述:
简单的web登录程序
实现代码
jiemian.html
Insert title hereUser Log
UserName
PassWord
shujuku.jsp
pageEncoding="UTF-8"
%>
Insert title heretry{
System.out.print("跳入");
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/test";
String username = "******";
String password = "******";
String user_name=request.getParameter("name");
String user_pass=request.getParameter("passWord");
System.out.println(user_name+" "+user_pass);
if(user_name==""||user_pass==""){
out.print("name or pass can't be null");
}else{
Connection conn=DriverManager.getConnection(url, username, password);
if(conn!=null){
out.print("database success");
Statement sm=conn.createStatement();
ResultSet rs=sm.executeQuery("select * from class where userName='"+user_name+"' and userPass='"+user_pass+"'");
if(rs.next()){
response.sendRedirect("chenggong.html");
}
else{
response.sendRedirect("shibai.html");
}
conn.close();
}
else{
out.print("数据库连接失败");
}
}
}
catch(Exception e){
e.printStackTrace();
}
%>
chenggong.html
Insert title here成功
shibai.html
Insert title here