1、创建一个web应用程序,
2、把上篇中的所有jsp文件以及图像全部复制到该项目中去 除了logincheck.jsp(这个另外再写)
3、建立一个JavaBean,(其实就是一个类,在源包里建立一个文件夹为login,建一个JavaBean在这个文件夹下,命名为:LoginBean,代码如下:
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
/**
*
* @author Administrator
*/
package login;
import java.sql.*;
public class LoginBean {
private String username;
private String password;
public void setUsername(String _Username){
this.username = _Username;
}
public String getUsername(){
return this.username;
}
public void setPassword(String _password){
this.password = _password;
}
public String getPassword(){
return this.password;
}
public boolean checklogin() {
boolean loginflag = false;
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try {
Class.forName("org.apache.derby.jdbc.ClientDriver");
con = DriverManager.getConnection("jdbc:derby://localhost:1527/MyTest", "admin", "admin");
stmt = con.createStatement();
String sql = "select ( from USERS where /"UserName/" = '" + username + "'";
rs = stmt.executeQuery(sql);
while (rs.next()) {
if (password.equals(rs.getString("password"))) {
loginflag = true;
}
}
} catch (Exception sqlex1) {
sqlex1.printStackTrace();
} finally {
if (con != null) {
try {
con.close();
} catch (SQLException sqlex2) {
sqlex2.printStackTrace();
}
}
}
return loginflag;
}
}
4、再建一个logincheck.jsp页面,代码如下:
<%--
Document : check
Created on : 2010-9-9, 19:50:27
Author : Administrator
--%>
<%@page contentType="text/html" pageEncoding="UTF-8" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<%@page import = "login.LoginBean"%>
<jsp:useBean id = "user" class = "login.LoginBean" scope="page"> //这句话是声明JavaBean,当然也可以在组件面板中
<jsp:setProperty name="user" property="*"/> //设置Bean属性
</jsp:useBean>
<%
if(user.checklogin()){
String username = request.getParameter("username");
session.setAttribute("username", username);
%>
<jsp:forward page = "welcome.jsp"></jsp:forward>
<% } else { %>
<jsp:forward page="error.jsp"></jsp:forward>
<% }%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<h1>Hello World!</h1>
</body>
</html>
这样就可以了,其实,是将在页面内的代码封装到一个JavaBean里去
附:
<jsp:useBean id = "user" class = "login.LoginBean" scope="page"> //这句话是声明JavaBean,当然也可以在组件面板中
插入的,如下
<jsp:getProperty name="user" property="*"/> //获取Bean属性
<jsp:setProperty name="user" property="*"/> //设置Bean属性