jsp图书表格管理系统

一：代码部分
1：这里是搭建的项目包

2：bean包

 public class ManagementBean {
	 private  Integer id ;
	    private  String book_name ;
	    private  String book_author ;
	    private  String book_isbn ;
	    private  String book_publish ;
	    private  Integer classify_id ;

	    public ManagementBean(){
	        super();
	    }


	    public Integer getId() {
	        return id;
	    }

	    public void setId(Integer id) {
	        this.id = id;
	    }

	    public String getBook_name() {
	        return book_name;
	    }

	    public void setBook_name(String book_name) {
	        this.book_name = book_name;
	    }

	    public String getBook_author() {
	        return book_author;
	    }

	    public void setBook_author(String book_author) {
	        this.book_author = book_author;
	    }

	    public String getBook_isbn() {
	        return book_isbn;
	    }

	    public void setBook_isbn(String book_isbn) {
	        this.book_isbn = book_isbn;
	    }

	    public String getBook_publish() {
	        return book_publish;
	    }

	    public void setBook_publish(String book_publish) {
	        this.book_publish = book_publish;
	    }

	    public Integer getClassify_id() {
	        return classify_id;
	    }

	    public void setClassify_id(Integer classify_id) {
	        this.classify_id = classify_id;
	    }
}

3：service

public interface ManService {
	
	//查询数据库内容结果放入list集合
	List<ManagementBean> list();
	
	//删除
	boolean	dele(Integer id);
	
	//更新
	boolean update(ManagementBean bean);
	
	//添加
	
	boolean add(ManagementBean bean);
}

4：serviceImpl

public class ManServiceImpl implements ManService {

	public List<ManagementBean> list() {
		// TODO Auto-generated method stub
		List<ManagementBean> list = new ArrayList<ManagementBean>();
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			conn = DBUtil.getConn();
			String sql = "select * from book";
			ps = conn.prepareStatement(sql);
			rs = ps.executeQuery();
			while (rs.next()) {
				ManagementBean be = new ManagementBean();
				be.setId(rs.getInt(1));
				be.setBook_name(rs.getString(2));
				be.setBook_author(rs.getString(3));
				be.setBook_isbn(rs.getString(4));
				be.setBook_publish(rs.getString(5));
				be.setClassify_id(rs.getInt(6));

				list.add(be);

			}
		} catch (Exception e) {

		} finally {
			DBUtil.close(conn, ps, rs);
		}

		return list;
	}

	public boolean dele(Integer id) {
		// TODO Auto-generated method stub

		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		int result = 0;
		try {
			conn = DBUtil.getConn();
			String sql = "delete from book where id = ? ";
			ps = conn.prepareStatement(sql);
			ps.setInt(1, id);
			result = ps.executeUpdate();
			if (result > 0){
				return true;
			}else{
				return false;
			}
		} catch (Exception e) {
			return false;
		} finally {
			DBUtil.close(conn,ps,rs);
		}

	}

	public boolean update(ManagementBean bean) {
		
		    Connection conn  = null ;
		    PreparedStatement ps = null ;
		    ResultSet rs = null ;
		    try{
		        conn = DBUtil.getConn();
		        String sql = "update book set id = ?, book_name=?,book_author=?,book_isbn=?,book_publish=? where id ='"+bean.getId()+"' ";
		        ps = conn.prepareStatement(sql);
		        ps.setInt(1, bean.getId());
		        ps.setString(2,bean.getBook_name());
		        ps.setString(3,bean.getBook_author());
		        ps.setString(4,bean.getBook_isbn());
		        ps.setString(5,bean.getBook_publish());
		        int reurts = ps.executeUpdate();
		        if(reurts>0){
		        	return true;
		        }else{
		        	return false;
		        }

		    }catch (Exception e) {
		    	return false;
		    }finally {
		    	DBUtil.close(conn,ps,rs);
		    }

		
	}

	public boolean add(ManagementBean bean) {
		  Connection conn  = null ;
		    PreparedStatement ps = null ;
		    ResultSet rs = null ;
		    try{
		        conn = DBUtil.getConn();
		        String sql = "insert into  book(id,book_name,book_author,book_isbn,book_publish) values(?,?,?,?,?) ";
		        ps = conn.prepareStatement(sql);
		        ps.setInt(1, bean.getId());
		        ps.setString(2,bean.getBook_name());
		        ps.setString(3,bean.getBook_author());
		        ps.setString(4,bean.getBook_isbn());
		        ps.setString(5,bean.getBook_publish());
		        int reurts = ps.executeUpdate();
		        if(reurts>0){
		        	return true;
		        }else{
		        	return false;
		        }

		    }catch (Exception e) {
		    	return false;
		    }finally {
		    	DBUtil.close(conn,ps,rs);
		    }

		
	}

}

5:servlet

public class ManServlet extends HttpServlet {

	
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

	doPost(request, response);
	}

	
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		// 从数据库中获取数据 并且显示在userList.jsp中
				ManService man =  new ManServiceImpl();

				List<ManagementBean> mans = man.list();
				
				HttpSession session = request.getSession();
				session.setAttribute("manList", mans);
				request.getRequestDispatcher("index.jsp").forward(request, response);
				//response.sendRedirect("index.jsp");
	}

}

6:最后是DBUtil

public class DBUtil {
	private static String url = "jdbc:sqlserver://localhost:1433;databaseName=MyDB";
	private static String user = "sa";
	private static String pwd = "1";

	static {

		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}

	public static Connection getConn() {
		Connection conn = null;
		try {
			conn = DriverManager.getConnection(url, user, pwd);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		return conn;
	}

	public static void close(Connection conn, PreparedStatement ps, ResultSet rs) {

		try {
			if (conn != null) {
				conn.close();
			}
			if (ps != null) {
				ps.close();
			}
			if (rs != null) {
				rs.close();
			}
			
			
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}

}

二：大概流程
1：
2：