login.jsp

ssd7考试exam3,绝对有用~欢迎下载

<%@ page session="true" %>
<jsp:useBean id="login" scope="page" />
<%
String mesg = "";

if( request.getParameter("name")!=null && !request.getParameter("pass").equals("")){
	String username =request.getParameter("name");
	String passwd = request.getParameter("pass");
	username = new String(username.getBytes("ISO8859-1"));
	passwd = new String(passwd.getBytes("ISO8859-1"));
	login.setUsername(username);
	login.setPasswd(passwd);
	out.print(username+passwd);
	if (login.excute()){
		session.setAttribute("username",username);
		String userid = Long.toString(login.getUserid());
		session.setAttribute("userid",userid);
		response.sendRedirect("booklist.jsp");
		%>
<%	
	}else {
	mesg = "登录出错！"	;
	}
}
%>
<%
        public String getSql() {
                if (isadmin) {
                        sqlStr = "select * from BookAdmin where adminuser = '" +
                            dataFormat.toSql(username) + "' and adminpass = '" +
                            dataFormat.toSql(passwd) + "'";
                }else {
                        sqlStr = "select * from shop_user where username = '" +
                            username + "' and password = '" + passwd + "'";
                }
                return sqlStr;
        }
        
        public boolean excute() throws Exception {
                boolean flag = false;
                DataBase db = new DataBase();
                db.connect();
                stmt = db.conn.createStatement ();
                rs = stmt.executeQuery(getSql());
                if (rs.next()){
                        if (!isadmin)
                        {
                                userid = rs.getLong("id");
                        }
                        flag = true;
                }
                rs.close();
                return flag;
        }





%>
<p>LOGIN:<br>
Please Input your Name and Password:</p>
<table border="1" width="501" height="66">
	<tr>
		<td height="25" width="248">Name:</td>
		<td height="25" width="237"><input type="text" name="name" size="20"></td>
	</tr>
	<tr>
		<td height="31" width="248">Password:</td>
		<td height="31" width="237"><input type="text" name="pass" size="20"></td>
	</tr>
</table>