开发实战练习1 jsp+jdbc 登陆程序

来源：互联网发布：手机上做班服的软件编辑：程序博客网时间：2024/04/19 08:12

使用jsp+jdbc完成一个用户登陆程序，登录成功后可以使用session进行用户的登录验证，用户根据需要也可以直接进行系统的退出操作。本程序在mysql数据库里建立了一个member表。

mid varchar pk,

password varchar,

name varchar.

<%@pagecontentType="text/html; charset=utf-8"%>

<html>

<body>

<%=request.getAttribute("info")!=null?request.getAttribute("info"):""%>

<formaction="check.jsp"method="post">

用户名:<inputtype="text"name="mid"><br>

密    码:<inputtype="password"name="password"><br>

</form>

</center>

</body>

</html>

check.jsp:

<%@pagecontentType="text/html; charset=utf-8"%>

<%@pageimport="java.sql.*"%>

<html>

<body>

<%!

publicstatic final String DBDRIVER ="org.gjt.mm.mysql.Driver";

publicstatic final String DBURL ="jdbc:mysql://localhost:3306/mysql";

public static final String DBUSER = "root";

public static final String DBPASS = "123456";

Connection conn = null;

PreparedStatement pstmt = null;

ResultSet rs = null;

boolean flag =false;

String name = null;

Class.forName(DBDRIVER);

conn = DriverManager.getConnection(DBURL,DBUSER,DBPASS);

String mid = request.getParameter("mid");

String password = request.getParameter("password");

String sql = "select name from member where mid=? and password=?";

pstmt = conn.prepareStatement(sql);

pstmt.setString(1, request.getParameter("mid"));

pstmt.setString(2, request.getParameter("password"));

rs = pstmt.executeQuery();

if(rs.next()){

session.setAttribute("id", mid);

flag = true;

}

rs.close();

pstmt.close();

conn.close();

if(flag){

<jsp:forwardpage="welcome.jsp"/>

}else{

request.setAttribute("info","错误的用户名或密码");

<jsp:forwardpage="login_failure.jsp"/>

}

</body>

</html>

welcome.jp:

<%@pagecontentType="text/html; charset=utf-8"%>

<html>

<head><title>welcome</title></head>

<body>

if(session.getAttribute("id")!=null){

}else{

request.setAttribute("info","请先登陆!");

<jsp:forwardpage="login.jsp"/>

}

</center>

</body>

</html>

logout.jsp:

<%@pagecontentType="text/html; charset=utf-8"%>

<html>

<head><tile>logout</head>

<body>

response.setHeader("refresh","2;URL=login.jsp");

session.invalidate();//让session失效

<h3>您已经成功退出本系统，两秒后跳转回首页!</h3>

<h3>如果没有跳转，请按<ahref="login.jsp">这里</a></h3>

</body>

</html>

0 0