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

最新推荐文章于 2022-11-09 08:38:17 发布

dreamwho

最新推荐文章于 2022-11-09 08:38:17 发布

阅读量994

点赞数

文章标签： servlet sql server dao jsp string sqlserver

本文链接：https://blog.csdn.net/dreamwjl/article/details/5180863

版权

刚刚学习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 自动生成构造函数存根 } @Override public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request, response); } @Override public 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>

dreamwho

关注

0
点赞
踩
3

收藏

觉得还不错? 一键收藏
0
评论
JSP+JAVABEAN,servlet SQL SERVER以DAO模式简单分页JSTL版

刚刚学习JSP...代码粗糙.写出来.算作笔记.学习嘛多写写才会进步~首先写一个界面用于提交至servletqueryLogin.jsp My JSP queryLogin.jsp starting page enter query.jsp 显示页面<!-- td,th{ text
复制链接

扫一扫