jsp 登录代码 我已安装了tomcat,Microsoft SQL Server,Microsoft SQL Server 2000 Driver for JDBC,sp4补丁,myeclipse ,急求一个完整的登录代码,及其相应的详细操作步骤,谢谢 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 楼主刚开始学jsp吧,我建议你照着书自己去试试,那样你会发现其实很简单! 我也是新手刚学JSP的,感觉和.Net 差不多我在网上找到的两个login.html和verifylogin.jsp,楼主你自己参考,其具体的代码分别如下:login.html的代码<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><meta http-equiv="Content-Language" content="zh-cn"><title>登录</title><!-- javaScript函数 validateLogin(),用来验证是否填写了用户名和密码:--><script language="JavaScript"><!--function validateLogin(){ var strUserName = document. frmLogin. txtUserName.value;var strPassword = document. frmLogin. txtPassword.value;if (strUserName ==""){alert("请您输入用户名!");return false;}if (strPassword ==""){alert("请输入密码!");return false;}}--></script></head><body><!--提交时调用JavaScript函数 validateLogin()来验证是否填写了用户名和密码:--><form method="post" name="frmLogin" action="verifylogin.jsp"onSubmit="javaScript: return validateLogin();"><table align="center" bgColor="#cccccc" border="0" cellPadding="0"cellSpacing="0" width="273"><tr><td align="right" height="47" vAlign="bottom" width="94">用户名:</td><td height="47" vAlign="bottom" width="172"><input name="txtUserName"></td></tr><tr><td align="right" width="94">密码:</td><td width="172"><input name="txtPassword" type="password" value></td></tr><tr><td align="right" height="44" width="94"></td><td height="44" width="172"><input name="Submit" type="submit"value="提 交"> <input name="Reset" type="reset"value="重 置"></td></tr></table></form></body></html>verifylogin.jsp的代码<%@ page language="java" contentType="text/html; charset=gb2312"pageEncoding="UTF-8"%><%@ pageimport="com.wxpn.tutorial.db.DB,com.wxpn.tutorial.db.ConnectionPool"%><%@ pageimport="java.sql.Connection,java.sql.Statement,java.sql.ResultSet,java.sql.SQLException"%><html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><meta http-equiv="Content-Language" content="zh-cn"><title>登录</title></head><body><div align=center><font color="red"><strong> <%//获取提交的用户名String strUserName = request.getParameter("txtUserName");//获取提交的密码String strPassword = request.getParameter("txtPassword");if((strUserName ==null)||(strUserName.equals(""))||(strUserName.length()>20)){response.sendRedirect("login.html");}if((strPassword ==null)||(strPassword.equals(""))||(strPassword.length()>20)){response.sendRedirect("login.html");}//创建数据库连接对象ConnectionPool connPool = DB.getConnPool();Connection conn = connPool.getConnection();Statement stmt = null;ResultSet rs = null;try {int nextMessageid = 0;String relative_path = null;//sql语句String sql = "select * from userinfo where username='"+ strUserName + "' and userpwd='" + strPassword + "'";//创建数据记录集对象stmt = conn.createStatement();//执行sql语句,返回一个记录集到rsrs = stmt.executeQuery(sql);//如果记录集为非空,表明有相匹配的用户名和密码,登录成功:if (rs.next()) {//登录成功时,把strUserName设成session变量UserNamesession.setAttribute("UserName",strUserName);out.println("登录成功!");} else {//否则(记录集为空),表明失败out.println("登录失败!");}} catch (SQLException sqlExc) {sqlExc.printStackTrace();} catch (Exception e) {e.printStackTrace();} finally {//关闭连接,释放数据库资源try {if (rs != null) {rs.close();}if (stmt != null) {stmt.close();}connPool.freeConnection(conn);} catch (SQLException sqlExc) {sqlExc.printStackTrace();}}%> </strong> </font></div></body></html> 最好单独写一个DBConnection来连接数据库 需要两个页面,用户登录页面和验证页面:用户页面:做一个表单<form action="验证页面" methor="post"><table><tr><td>用户名:</td><td><input type="text" name=""></td></tr> <tr><td>密 ; ;码:</td><td><input type="password" name=""></td></tr> </table></form>验证页面:需要连接数据库<%String DRIVER="驱动程序";String URL="连接地址";String USER="数据库用户名";String PASSWORD="数据库用户密码";Connection con=null;PreparedStatement pstmt = null;ResultSet rs = null;%><%//接收参数String ""(用户名)=requset.Parameter("");String ""(密码)= request.Parameter("");%><%String sql=“设置你的查询语句”;Class.forName(DBDRIVER);conn = DriverManager.getConnection(DBURL, DBUSER, DBPASSWORD);pstmt = conn.prepareStatement(sql);pstmt.setString(1,用户名);pstmt.setString(2,密码);rs = pstmt.executeQuery();rs.close();pstmt.close();conn.close();%>大概就是这样了,不过做登录,还应该加入登录失败的提示和相应的跳转!!希望能能帮到你! <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><meta http-equiv="Content-Language" content="zh-cn"><title>登录</title><!-- javaScript函数 validateLogin(),用来验证是否填写了用户名和密码:--><script language="JavaScript"><!--function validateLogin(){ var strUserName = document. frmLogin. txtUserName.value;var strPassword = document. frmLogin. txtPassword.value;if (strUserName ==""){alert("请您输入用户名!");return false;}if (strPassword ==""){alert("请输入密码!");return false;}}--></script></head><body><!--提交时调用JavaScript函数 validateLogin()来验证是否填写了用户名和密码:--><form method="post" name="frmLogin" action="verifylogin.jsp"onSubmit="javaScript: return validateLogin();"><table align="center" bgColor="#cccccc" border="0" cellPadding="0"cellSpacing="0" width="273"><tr><td align="right" height="47" vAlign="bottom" width="94">用户名:</td><td height="47" vAlign="bottom" width="172"><input name="txtUserName"></td></tr><tr><td align="right" width="94">密码:</td><td width="172"><input name="txtPassword" type="password" value></td></tr><tr><td align="right" height="44" width="94"></td><td height="44" width="172"><input name="Submit" type="submit"value="提 交"> <input name="Reset" type="reset"value="重 置"></td></tr></table></form></body></html>verifylogin.jsp的代码<%@ page language="java" contentType="text/html; charset=gb2312"pageEncoding="UTF-8"%><%@ pageimport="com.wxpn.tutorial.db.DB,com.wxpn.tutorial.db.ConnectionPool"%><%@ pageimport="java.sql.Connection,java.sql.Statement,java.sql.ResultSet,java.sql.SQLException"%><html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><meta http-equiv="Content-Language" content="zh-cn"><title>登录</title></head><body><div align=center><font color="red"><strong><%//获取提交的用户名String strUserName = request.getParameter("txtUserName");//获取提交的密码String strPassword = request.getParameter("txtPassword");if((strUserName ==null)||(strUserName.equals(""))||(strUserName.length()>20)){response.sendRedirect("login.html");}if((strPassword ==null)||(strPassword.equals(""))||(strPassword.length()>20)){response.sendRedirect("login.html");}//创建数据库连接对象ConnectionPool connPool = DB.getConnPool();Connection conn = connPool.getConnection();Statement stmt = null;ResultSet rs = null;try {int nextMessageid = 0;String relative_path = null;//sql语句String sql = "select * from userinfo where username='"+ strUserName + "' and userpwd='" + strPassword + "'";//创建数据记录集对象stmt = conn.createStatement();//执行sql语句,返回一个记录集到rsrs = stmt.executeQuery(sql);//如果记录集为非空,表明有相匹配的用户名和密码,登录成功:if (rs.next()) {//登录成功时,把strUserName设成session变量UserNamesession.setAttribute("UserName",strUserName);out.println("登录成功!");} else {//否则(记录集为空),表明失败out.println("登录失败!");}} catch (SQLException sqlExc) {sqlExc.printStackTrace();} catch (Exception e) {e.printStackTrace();} finally {//关闭连接,释放数据库资源try {if (rs != null) {rs.close();}if (stmt != null) {stmt.close();}connPool.freeConnection(conn);} catch (SQLException sqlExc) {sqlExc.printStackTrace();}}%> </strong> </font></div></body></html> 怎样突破天涯论坛45秒灌水回帖限制,随意回帖? html中select标签 java桌面程序web版本 用lucene做海量数据检索的高手进来 JSP数据库帐号密码验证 一个很棘手的问题 help? 关于使用SmartUpload实现文件下载的问题 怎样在字符串中取字符串中的内容产生新的字符串? JAVA 后端和前端的结合问题 JSP如何获取JavaScript页面的变量值 急~~~ssh部署到Apache不能访问
我在网上找到的两个login.html和verifylogin.jsp,楼主你自己参考,其具体的代码分别如下:login.html的代码
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta http-equiv="Content-Language" content="zh-cn">
<title>登录</title>
<!-- javaScript函数 validateLogin(),用来验证是否填写了用户名和密码:-->
<script language="JavaScript"><!--
function validateLogin(){
var strUserName = document. frmLogin. txtUserName.value;
var strPassword = document. frmLogin. txtPassword.value;
if (strUserName ==""){
alert("请您输入用户名!");
return false;
}
if (strPassword ==""){
alert("请输入密码!");
return false;
}
}
-->
</script>
</head><body>
<!--提交时调用JavaScript函数 validateLogin()来验证是否填写了用户名和密码:-->
<form method="post" name="frmLogin" action="verifylogin.jsp"
onSubmit="javaScript: return validateLogin();">
<table align="center" bgColor="#cccccc" border="0" cellPadding="0"
cellSpacing="0" width="273">
<tr>
<td align="right" height="47" vAlign="bottom" width="94">用户名:</td>
<td height="47" vAlign="bottom" width="172"><input name="txtUserName">
</td>
</tr>
<tr>
<td align="right" width="94">密码:</td>
<td width="172"><input name="txtPassword" type="password" value></td>
</tr>
<tr>
<td align="right" height="44" width="94"></td>
<td height="44" width="172"><input name="Submit" type="submit"
value="提 交"> <input name="Reset" type="reset"
value="重 置"></td>
</tr>
</table>
</form>
</body>
</html>verifylogin.jsp的代码<%@ page language="java" contentType="text/html; charset=gb2312"
pageEncoding="UTF-8"%>
<%@ page
import="com.wxpn.tutorial.db.DB,com.wxpn.tutorial.db.ConnectionPool"%>
<%@ page
import="java.sql.Connection,java.sql.Statement,java.sql.ResultSet,java.sql.SQLException"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta http-equiv="Content-Language" content="zh-cn">
<title>登录</title>
</head>
<body>
<div align=center><font color="red"><strong>
<%
//获取提交的用户名
String strUserName = request.getParameter("txtUserName");
//获取提交的密码
String strPassword = request.getParameter("txtPassword");
if((strUserName ==null)||(strUserName.equals(""))||(strUserName.length()>20)){
response.sendRedirect("login.html");
}
if((strPassword ==null)||(strPassword.equals(""))||(strPassword.length()>20)){
response.sendRedirect("login.html");
}
//创建数据库连接对象
ConnectionPool connPool = DB.getConnPool();
Connection conn = connPool.getConnection();
Statement stmt = null;
ResultSet rs = null;try {
int nextMessageid = 0;
String relative_path = null;
//sql语句
String sql = "select * from userinfo where username='"
+ strUserName + "' and userpwd='" + strPassword + "'";
//创建数据记录集对象
stmt = conn.createStatement();
//执行sql语句,返回一个记录集到rs
rs = stmt.executeQuery(sql);
//如果记录集为非空,表明有相匹配的用户名和密码,登录成功:
if (rs.next()) {
//登录成功时,把strUserName设成session变量UserName
session.setAttribute("UserName",strUserName);
out.println("登录成功!");
} else {
//否则(记录集为空),表明失败
out.println("登录失败!");
}
} catch (SQLException sqlExc) {
sqlExc.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
} finally {
//关闭连接,释放数据库资源
try {
if (rs != null) {
rs.close();
}
if (stmt != null) {
stmt.close();
}
connPool.freeConnection(conn);
} catch (SQLException sqlExc) {
sqlExc.printStackTrace();
}
}
%> </strong> </font></div>
</body>
</html>
用户页面:做一个表单
<form action="验证页面" methor="post">
<table>
<tr>
<td>
用户名:
</td>
<td>
<input type="text" name="">
</td>
</tr>
<tr>
<td>密 ; ;码:</td>
<td>
<input type="password" name="">
</td>
</tr>
</table>
</form>
验证页面:需要连接数据库
<%
String DRIVER="驱动程序";
String URL="连接地址";
String USER="数据库用户名";
String PASSWORD="数据库用户密码";
Connection con=null;
PreparedStatement pstmt = null;
ResultSet rs = null;%>
<%//接收参数
String ""(用户名)=requset.Parameter("");
String ""(密码)= request.Parameter("");
%>
<%
String sql=“设置你的查询语句”;
Class.forName(DBDRIVER);
conn = DriverManager.getConnection(DBURL, DBUSER, DBPASSWORD);
pstmt = conn.prepareStatement(sql);
pstmt.setString(1,用户名);
pstmt.setString(2,密码);
rs = pstmt.executeQuery();rs.close();
pstmt.close();
conn.close();
%>
大概就是这样了,不过做登录,还应该加入登录失败的提示和相应的跳转!!
希望能能帮到你!
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta http-equiv="Content-Language" content="zh-cn">
<title>登录</title>
<!-- javaScript函数 validateLogin(),用来验证是否填写了用户名和密码:-->
<script language="JavaScript"><!--
function validateLogin(){
var strUserName = document. frmLogin. txtUserName.value;
var strPassword = document. frmLogin. txtPassword.value;
if (strUserName ==""){
alert("请您输入用户名!");
return false;
}
if (strPassword ==""){
alert("请输入密码!");
return false;
}
}
-->
</script>
</head><body>
<!--提交时调用JavaScript函数 validateLogin()来验证是否填写了用户名和密码:-->
<form method="post" name="frmLogin" action="verifylogin.jsp"
onSubmit="javaScript: return validateLogin();">
<table align="center" bgColor="#cccccc" border="0" cellPadding="0"
cellSpacing="0" width="273">
<tr>
<td align="right" height="47" vAlign="bottom" width="94">用户名:</td>
<td height="47" vAlign="bottom" width="172"><input name="txtUserName">
</td>
</tr>
<tr>
<td align="right" width="94">密码:</td>
<td width="172"><input name="txtPassword" type="password" value></td>
</tr>
<tr>
<td align="right" height="44" width="94"></td>
<td height="44" width="172"><input name="Submit" type="submit"
value="提 交"> <input name="Reset" type="reset"
value="重 置"></td>
</tr>
</table>
</form>
</body>
</html>verifylogin.jsp的代码<%@ page language="java" contentType="text/html; charset=gb2312"
pageEncoding="UTF-8"%>
<%@ page
import="com.wxpn.tutorial.db.DB,com.wxpn.tutorial.db.ConnectionPool"%>
<%@ page
import="java.sql.Connection,java.sql.Statement,java.sql.ResultSet,java.sql.SQLException"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta http-equiv="Content-Language" content="zh-cn">
<title>登录</title>
</head>
<body>
<div align=center><font color="red"><strong>
<%
//获取提交的用户名
String strUserName = request.getParameter("txtUserName");
//获取提交的密码
String strPassword = request.getParameter("txtPassword");
if((strUserName ==null)||(strUserName.equals(""))||(strUserName.length()>20)){
response.sendRedirect("login.html");
}
if((strPassword ==null)||(strPassword.equals(""))||(strPassword.length()>20)){
response.sendRedirect("login.html");
}
//创建数据库连接对象
ConnectionPool connPool = DB.getConnPool();
Connection conn = connPool.getConnection();
Statement stmt = null;
ResultSet rs = null;try {
int nextMessageid = 0;
String relative_path = null;
//sql语句
String sql = "select * from userinfo where username='"
+ strUserName + "' and userpwd='" + strPassword + "'";
//创建数据记录集对象
stmt = conn.createStatement();
//执行sql语句,返回一个记录集到rs
rs = stmt.executeQuery(sql);
//如果记录集为非空,表明有相匹配的用户名和密码,登录成功:
if (rs.next()) {
//登录成功时,把strUserName设成session变量UserName
session.setAttribute("UserName",strUserName);
out.println("登录成功!");
} else {
//否则(记录集为空),表明失败
out.println("登录失败!");
}
} catch (SQLException sqlExc) {
sqlExc.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
} finally {
//关闭连接,释放数据库资源
try {
if (rs != null) {
rs.close();
}
if (stmt != null) {
stmt.close();
}
connPool.freeConnection(conn);
} catch (SQLException sqlExc) {
sqlExc.printStackTrace();
}
}
%> </strong> </font></div>
</body>
</html>