这是小弟我的登录页面代码，怎样用jsp，java写一个登录判断页面？要连接数据库的
日期：2014-05-17 浏览次数：21134 次
这是我的登录页面代码，怎样用jsp，java写一个登录判断页面？要连接数据库的。
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>请登录</title>
</head>
<body>
<form id="form1" name="form1" method="post" action="login.jsp">
<p align="center">用户登录</p>
<p align="center">用户名
<label>
<input type="text" name="userName" />
</label>
</p>
<p align="center">密码
<label>
<input type="password" name="Password" />
</label>
</p>
<p align="center">
<label>
<input type="submit" name="Submit" value="提交" />
</label>
</p>
------解决方案--------------------
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>请登录</title>
</head>
<body>
<form id="form1" name="form1" method="post" action="login.jsp">
<p align="center">用户登录</p>
<p align="center">用户名
<label>
<input type="text" name="userName" />
</label>
</p>
<p align="center">密码
<label>
<input type="password" name="Password" />
</label>
</p>
<p align="center">
<label>
<input type="submit" name="Submit" value="提交" />
</label>
</p>
------解决方案--------------------
- Java code
index.jsp
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>登录</title>
</head>
<body>
<form id="form1" name="form1" method="post" action="login.jsp">
<p align="center">用户登录</p>
<p align="center">用户名
<label>
<input type="text" name="userName" />
</label>
</p>
<p align="center">密码:
<input type="password" name="Password" />
</p>
<p align="center">
<input type="submit" name="Submit" value="提交" />
</p>
login.jsp
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@ page import="com.mysql.jdbc.*,java.sql.Connection, java.sql.DriverManager,java.sql.PreparedStatement,java.sql.ResultSet " %>
<html>
<body>
<%
String username = request.getAttribute("userName") ;
String pass = request.getAttribute("password") ;
Class.forName("com.mysql.jdbc.Driver"); //加载驱动
Connection conn = DriverManager.getConnection("jdbc:mysql://192.168.0.44:3306/javassdb",
"root","root");//创建连接
String sql ="select id , username, email , password from tbl_User where username = " + username + " and password=" + pass;
PreparedStatement pstmt = null ;
ResultSet rs = null ;
boolean flag = false ;
try{
pstmt = conn.prepareStatement(sql) ; //
rs = pstmt.executeQuery() ;//查询
while(rs.next()){ //遍历查询结构，现实在页面中
flag = true ;
break ;
}
}catch(Exception e){
e.printStackTrace();
}finally{
try{
if (rs != null) rs.close() ;
if (pstmt != null) pstmt.close() ;
if (conn != null) conn.close() ;
}catch(Exception e){
e.printStackTrace() ;
}
}
if (flag){
request.getRequestDispatcher("welcome.jsp").forward(request, response) ;
}else{
request.getRequestDispatcher(&q
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
