用html和jsp实现网站的登陆功能

来源：互联网发布：郭敬明梦里花落知多少编辑：程序博客网时间：2024/05/19 02:43

显示界面 login.html

登陆提交到的jsp页面login.jsp

<%@ page contentType="text/html" language="java" import="java.sql.*" errorPage="" pageEncoding="GB2312"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GB2312" />
<meta http-equiv="Expires" content="0">
<meta http-equiv="kiben" content="no-cache">
<title>登录验证</title>
<%
request.setCharacterEncoding("GB2312");//设置请求的编码格式为GB2312
//开始连接数据库
String Suser = request.getParameter("muser");
String Spasswd = request.getParameter("passwd");
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaceName=ProjManagerPlatform", "sa", "100862");

Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
try{
ResultSet rs;
rs = stmt.executeQuery("select userName from ProjManagerPlatform.dbo.UsersInfo where userName='"+Suser+"'");//查询语句
if(rs.next()){
Suser = rs.getString("userName"); //得到userName在数据库中的值
}else{
rs.close();
stmt.close();
conn.close();
%>

<body>

</body>
</html>