JSP+JAVABEAN,servlet SQL SERVER以DAO模式简单分页JSTL版

来源：互联网发布：超牛数据恢复官网编辑：程序博客网时间：2024/05/16 11:59

刚刚学习JSP...代码粗糙.写出来.算作笔记.学习嘛多写写才会进步~

首先写一个界面用于提交至servlet

queryLogin.jsp

<%@ page language="java" import="java.util.*" pageEncoding="GBK"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html> <head> <title>My JSP 'queryLogin.jsp' starting page</title> </head> <body> <a href="fenye.do" mce_href="fenye.do">enter</a> </body></html>

query.jsp 显示页面

<%@ page language="java" import="java.util.*" pageEncoding="GBK"%><%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %><mce:style></mce:style><style mce_bogus="1">td,th{text-align: center;width=80px;}</style><table border="1" width="400px" align="center"> <tr> <th>编号</th><th>姓名</th><th>性别</th><th>地址</th> </tr> <c:forEach items="${all}" var="person"> <tr> <td>${person.per_id }</td> <td>${person.per_name }</td><td>${person.per_sex }</td><td>${person.per_addr }</td></tr></c:forEach></table><table border="1" width="400px" align="center"><tr><td><a href="fenye.do?pages=1" mce_href="fenye.do?pages=1">第一页</a></td><td><a href="fenye.do?pages=${prior }" mce_href="fenye.do?pages=${prior }">前一页</a></td><td><a href="fenye.do?pages=${next }" mce_href="fenye.do?pages=${next }">下一页</a></td><td><a href="fenye.do?pages=${last }" mce_href="fenye.do?pages=${last }">最后一页</a></td></tr></table>

SQL连接,单子模式

SQLConn.java

package net.dreamwho.org.dao;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;public class SQLConn {private static final String DBDRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";private static final String SQLSERVER = "jdbc:sqlserver://localhost:1433;DatabaseName=javadb"; private static final String SQLUSER = "sa";private static final String SQLUPWD = "你的密码";Connection conn = null;private static SQLConn dbconn = null;private SQLConn(){try {Class.forName(DBDRIVER);} catch (ClassNotFoundException e) {e.printStackTrace();}}public static SQLConn getSQLConn(){if(dbconn == null){dbconn = new SQLConn();}return dbconn;}public Connection getConnection(){try {conn = DriverManager.getConnection(this.SQLSERVER,this.SQLUSER,this.SQLUPWD);} catch (SQLException e) {e.printStackTrace();}return conn;}}

DAO Vo类

person.java

package net.dreamwho.org.vo;public class Person {private String per_id,per_name,per_sex,per_addr;public String getPer_addr() {return per_addr;}public void setPer_addr(String per_addr) {this.per_addr = per_addr;}public String getPer_id() {return per_id;}public void setPer_id(String per_id) {this.per_id = per_id;}public String getPer_name() {return per_name;}public void setPer_name(String per_name) {this.per_name = per_name;}public String getPer_sex() {return per_sex;}public void setPer_sex(String per_sex) {this.per_sex = per_sex;}}

personDao.java

package net.dreamwho.org.dao;import java.util.List;import net.dreamwho.org.vo.Person;public interface PersonDao {List queryAll(int pages);Person queryById(Person person);Person queryByName(String per_name);boolean addPerson(Person person);boolean modifyPerson(Person person);boolean deletePerson(String id);int recAllCount();}

personIMP.java 实现类

package net.dreamwho.org.dao;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import java.util.List;import net.dreamwho.org.exception.MyRuntimeException;import net.dreamwho.org.factory.DAOFactory;import net.dreamwho.org.vo.Fenye;import net.dreamwho.org.vo.Person;public class PersonIMP implements PersonDao {private String QUERY = "select * from t_person where 1=1";private String ADD = "insert into t_person(per_id,per_name,per_sex,per_addr) values(?,?,?,?)";private String MAX = "select isnull(max(per_id),0)+1 from t_person";private String TOTALCOUNT = "select count(*) from t_person";public boolean addPerson(Person person) {Connection conn = null;PreparedStatement ps = null;PreparedStatement ps2 = null;ResultSet rs = null;int per_id =0;boolean flag = false;try {conn = DAOFactory.getSQLConn().getConnection();ps = conn.prepareStatement(this.MAX);rs = ps.executeQuery();if(rs.next()){per_id =rs.getInt(1);//System.out.print(per_id);}ps2 = conn.prepareStatement(this.ADD);ps2.setInt(1,per_id);ps2.setString(2, person.getPer_name());ps2.setString(3, person.getPer_sex());ps2.setString(4, person.getPer_addr());int i = ps2.executeUpdate();if(i>0){flag = true;}} catch (SQLException e) {throw new MyRuntimeException("添加失败",e);}finally{close(conn, ps, rs);}return flag;}public boolean deletePerson(String id) {return false;}public boolean modifyPerson(Person person) {return false;}public List queryAll(int pages) {List<Person> all = new ArrayList<Person>();Connection conn = null;PreparedStatement ps = null;ResultSet rs = null;int pageRec = 5;/*f.setPrior(prior);f.setNext(next);f.setLast(last);*///System.out.println("前一页:"+f.getPrior()+"下一页:"+f.getNext()+"下一页"+f.getLast());try {String PAGESQL = "select Top "+pageRec+" * from t_person where per_id not in (select top "+(pages-1)*pageRec+" per_id from t_person order by per_id asc)order by per_id asc";conn = DAOFactory.getSQLConn().getConnection();ps = conn.prepareStatement(PAGESQL);rs = ps.executeQuery();while(rs.next()){Person person = new Person();person.setPer_id(rs.getString("per_id"));person.setPer_name(rs.getString("per_name"));person.setPer_sex(rs.getString("per_sex"));person.setPer_addr(rs.getString("per_addr"));all.add(person);}} catch (SQLException e) {throw new MyRuntimeException("失败",e);}finally{close(conn, ps, rs);}return all;}public Person queryById(Person person) {StringBuffer buffer = new StringBuffer();buffer.append(" and per_id=?");QUERY=QUERY+buffer;Connection conn = null;PreparedStatement ps = null;ResultSet rs = null;try {conn = DAOFactory.getSQLConn().getConnection();ps = conn.prepareStatement(this.QUERY);ps.setString(1, person.getPer_id());rs = ps.executeQuery();while(rs.next()){person.setPer_id(rs.getString("per_id"));person.setPer_name(rs.getString("per_name"));person.setPer_sex(rs.getString("per_sex"));person.setPer_addr(rs.getString("per_addr"));}} catch (SQLException e) {throw new MyRuntimeException("失败",e);}finally{close(conn, ps, rs);}return person;}public Person queryByName(String per_name) {Person person = new Person();StringBuffer buffer = new StringBuffer();buffer.append(" and per_name=?");QUERY=QUERY+buffer;Connection conn = null;PreparedStatement ps = null;ResultSet rs = null;try {conn = DAOFactory.getSQLConn().getConnection();ps = conn.prepareStatement(this.QUERY);ps.setString(1, per_name);rs = ps.executeQuery();while(rs.next()){person.setPer_id(rs.getString("per_id"));person.setPer_name(rs.getString("per_name"));person.setPer_sex(rs.getString("per_sex"));person.setPer_addr(rs.getString("per_addr"));}} catch (SQLException e) {// TODO 自动生成 catch 块e.printStackTrace();}finally{close(conn, ps, rs);}return person;}private void close(Connection conn, PreparedStatement ps, ResultSet rs) {try{if(conn!=null){conn.close();}}catch(Exception e){e.printStackTrace();}try{if(ps!=null){ps.close();}}catch(Exception e){e.printStackTrace();}try{if(rs!=null){rs.close();}}catch(Exception e){e.printStackTrace();}}public int recAllCount() {Connection conn = null;PreparedStatement ps = null;ResultSet rs = null;int recAllCount = 0; //初始总记录数//int pageAllCount = 1; //总页数//int pageRec = 5; //每页显示记录数//int pageCode = 1;//int first = 1; //首页//Fenye f = new Fenye();try {conn = DAOFactory.getSQLConn().getConnection();ps = conn.prepareStatement(this.TOTALCOUNT);rs = ps.executeQuery();if(rs.next()){recAllCount = rs.getInt(1);}} catch (SQLException e) {throw new MyRuntimeException("失败",e);}finally{close(conn, ps, rs);}return recAllCount;/*if(recAllCount<1){pageAllCount = 1;}else{pageAllCount = recAllCount%pageRec==0?recAllCount/pageRec:recAllCount/pageRec+1;}int prior = 1; //上一页int next = 1; //下一页int last = 1 ; //最后prior = (pageCode-1)<1?1:(pageCode-1);next = (pageCode+1)>pageAllCount?pageAllCount:(pageCode+1);last = pageAllCount;*/}/*public static void main(String[] args){for(int i =11;i<=80;i++){Person person = new Person();;person.setPer_name("周"+i+"伦");person.setPer_sex("男");person.setPer_addr("台湾");System.out.print(DAOFactory.getPersonIMP().addPerson(person));}List all = DAOFactory.getPersonIMP().queryAll();Iterator it = all.iterator();while(it.hasNext()){Person p=(Person)it.next();System.out.println(p.getPer_id()+p.getPer_name()+p.getPer_sex()+p.getPer_addr()+"<br>");}}*/}

异常处理

MyRuntimeException.java

package net.dreamwho.org.exception;public class MyRuntimeException extends RuntimeException {public MyRuntimeException() {// TODO 自动生成构造函数存根}public MyRuntimeException(final String arg0) {super(arg0);// TODO 自动生成构造函数存根}public MyRuntimeException(final Throwable arg0) {super(arg0);// TODO 自动生成构造函数存根}public MyRuntimeException( String arg0, Throwable arg1) {super(arg0, arg1);// TODO 自动生成构造函数存根}}

工厂模式

DAOFactory.java

package net.dreamwho.org.factory;import net.dreamwho.org.dao.PersonIMP;import net.dreamwho.org.dao.SQLConn;import net.dreamwho.org.dao.UserIMP;public class DAOFactory {public static SQLConn getSQLConn(){return SQLConn.getSQLConn();}public static PersonIMP getPersonIMP(){return new PersonIMP();}}

servlet

fenye.java

package net.dreamwho.org.servlet;import java.io.IOException;import javax.servlet.Servlet;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import java.util.*;import net.dreamwho.org.factory.*;public class fenye extends HttpServlet implements Servlet {public fenye() {// TODO 自动生成构造函数存根}@Overridepublic void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doPost(request, response);}@Overridepublic void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {int pageCode = 1;int pageAllCount = 1;int pageRec = 5; //每页显示记录数int prior = 1; //上一页int next = 1; //下一页int last = 1 ; //最后int recAllCount = DAOFactory.getPersonIMP().recAllCount();String pages = request.getParameter("pages");if(pages!=null){pageCode = Integer.parseInt(pages);}if(recAllCount<1){pageAllCount = 1;}else{pageAllCount = recAllCount%pageRec==0?recAllCount/pageRec:recAllCount/pageRec+1;}if(pageCode>pageAllCount){pageCode = pageAllCount;}prior = (pageCode-1)<1?1:(pageCode-1);next = (pageCode+1)>pageAllCount?pageAllCount:(pageCode+1);if(next>pageAllCount){next = 1;}last = pageAllCount;List all = DAOFactory.getPersonIMP().queryAll(pageCode);request.setAttribute("all", all);request.setAttribute("prior", prior);request.setAttribute("next", next);request.setAttribute("last", last);request.getRequestDispatcher("query.jsp").forward(request, response);}}

web.xml

<?xml version="1.0" encoding="UTF-8"?><web-app version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"> <welcome-file-list> <welcome-file>index.jsp</welcome-file> </welcome-file-list> <filter> <filter-name>Set Character Encoding</filter-name> <filter-class>filters.SetCharacterEncodingFilter</filter-class> <init-param> <param-name>encoding</param-name> <param-value>GB2312</param-value> </init-param> </filter> <filter-mapping> <filter-name>Set Character Encoding</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <servlet> <servlet-name>check</servlet-name> <servlet-class>net.dreamwho.org.servlet.check</servlet-class> </servlet> <servlet> <servlet-name>register</servlet-name> <servlet-class>net.dreamwho.org.servlet.regedit</servlet-class> </servlet> <servlet> <description>查询信息</description> <servlet-name>query</servlet-name> <servlet-class>net.dreamwho.org.servlet.query</servlet-class> </servlet><servlet><servlet-name>fenye</servlet-name><servlet-class>net.dreamwho.org.servlet.fenye</servlet-class></servlet> <servlet-mapping> <servlet-name>check</servlet-name> <url-pattern>/check</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>register</servlet-name> <url-pattern>/reg</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>query</servlet-name> <url-pattern>/query</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>fenye</servlet-name> <url-pattern>/fenye.do</url-pattern> </servlet-mapping></web-app>