系统登录
//首页
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<script type="text/javascript" src="jquery.js"></script>
<style type="text/css">
#name-error,#password-error{
color:red;
padding-left:10px;
font-size:14px;
}
</style>
var name = $("input[name='username']").val();
var pwd = $("input[name='password']").val();
</html>
//验证页
<%@page import="cn.edu.hpu.dao.StudentDao"%>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="cn.edu.hpu.entity.Student" %>
<%
String name = request.getParameter("username");
String password = request.getParameter("password");
if(name == null || password == null){
response.sendRedirect("index.jsp?code=1001");
return;
}
StudentDao sd = new StudentDao();
Student s = sd.findStudent(name, password);
if(s != null){
request.setAttribute("mystudent", s);
request.getRequestDispatcher("success.jsp").forward(request, response);
}else{
response.sendRedirect("index.jsp?code=1001");
return;
}
//成功页
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="cn.edu.hpu.entity.*"
%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
welcome,<%=s.getUsername() %>!
</html>
//对象
package cn.edu.hpu.entity;
public class Student {
private int id ;
private String username;
private String password;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
//jdbc
package cn.edu.hpu.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class DHelp<T> {
private static final String DRIVER = "com.mysql.jdbc.Driver";
private static final String URL ="jdbc:mysql://localhost:3306/formdemo";
private static final String USERNAME = "root";
private static final String PASSWORD = "123456";
private Connection getConnection(){
Connection conn = null;
try {
Class.forName(DRIVER);
conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);
return conn;
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}
//查找
public T excuteFind(String sql,RowMapper<T> rm,Object...args){
T obj = null;
Connection conn = null;
PreparedStatement pst = null;
ResultSet rs = null;
try {
conn = getConnection();
pst = conn.prepareStatement(sql);
for (int i = 0; i < args.length; i++) {
pst.setObject(i+1,args[i]);
}
rs = pst.executeQuery();
if (rs.next()) {
obj = rm.mapperRow(rs);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
close(rs, pst, conn);
}
return obj;
}
public void close(PreparedStatement pst,Connection conn){
close(null,pst,conn);
}
public void close(ResultSet rs,PreparedStatement pst,Connection conn){
try {
if (rs != null) {
rs.close();
}
} catch (Exception e) {
// TODO: handle exception
}finally{
try {
if (pst != null) {
pst.close();
}
} catch (Exception e2) {
// TODO: handle exception
}finally{
try {
if (conn != null) {
conn.close();
}
} catch (Exception e3) {
// TODO: handle exception
}
}
}
}
}
、、
package cn.edu.hpu.util;
import java.sql.ResultSet;
public interface RowMapper<T> {
public T mapperRow(ResultSet rs) throws Exception;
}
、、
package cn.edu.hpu.dao;
import java.sql.ResultSet;
import cn.edu.hpu.entity.Student;
import cn.edu.hpu.util.DHelp;
import cn.edu.hpu.util.RowMapper;
public class StudentDao {
DHelp<Student> dh = new DHelp<Student>();
public Student findStudent(String name,String password){
String sql = "select id,username,password from student where username=? and password=?";
return (Student) dh.excuteFind(sql, new RowMapper<Student>() {
public Student mapperRow(ResultSet rs) throws Exception {
// TODO Auto-generated method stub
Student s = new Student();
s.setId(rs.getInt("id"));
s.setPassword(rs.getString("password"));
s.setUsername(rs.getString("username"));
return s;
}
}, name,password);
}
}