JSP上搜集的分页及example搜索相关代码.docxVIP

JSP上搜集的分页及example搜索相关代码 1. 连接数据库的基类： package mons; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class GetConnection { protected Connection conn = null;//连接字符串 protected PreparedStatement ps = null;//预编译并存储 SQL 指令 protected ResultSet rs = null;//查询结果集 private static final String DRIVER = “com.microsoft.sqlserver.jdbc.SQLServerDriver“;//加载数据库驱动的字符串 private static final String URL = jdbc:sqlserver://localhost:1433;databaseName=BOOKDB;//连接数据库的字符串 private static final String *****E = sa;//数据库用户名 private static final String *****D = accp;//数据库用户密码 /** * 获得数据库连接 * @return */ public Connection getConn() { Connection conn = null; try { Class.forName(DRIVER);//加载数据库驱动 conn = DriverManager.getConnection(URL,*****E,*****D);//连接数据库 } catch (ClassNotFoundException e) { } } return conn; // TODO Auto-generated catch block e.printStackTrace(); // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { } /* * 释放资源 */ public void closeAll(){ } try { } if(rs != null){ } if(ps != null){ } if(conn != null){ } e.printStackTrace(); conn = null; ps = null; rs = null; conn.close(); ps.close(); rs.close(); } catch (SQLException e) { }finally{ 2. 实体类代码： package com.book.entity; public class Book { private String book_publishTime; private String book_synopsis; private double book_price; private String book_author; private String book_num; private String book_name; private int book_id; public String getBook_publishTime() { } return book_publishTime; public void setBook_price(double book_price) { } this.book_price = book_price; public double getBook_price() { } return book_price; public void setBook_num(String book_num) { } this.book_num = book_num; public String getBook_num() { } return book_