用JSP和Servlet实现图书管理系统的增删改查

首先附上效果图

增加

删除

更新

效果图展示完毕，下面我们来看代码

第一步建立MVC

DBUtil.java

package com.hnpi.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class DBUtil {

	public static Connection getConn() {

		String url = "jdbc:sqlserver://localhost:1433;databaseName=DB";
		String user = "sa";
		String pwd = "1";
		Connection conn = null;

		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			conn = DriverManager.getConnection(url, user, pwd);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return conn;
	}
   
	public static void closeConn(Connection conn, PreparedStatement ps,
			ResultSet rs) {

		try {
			if (conn != null) {
				conn.close();
			}
		} catch (SQLException e) {

			e.printStackTrace();
		}

		try {
			if (ps != null) {
				ps.close();
			}
		} catch (SQLException e) {

			e.printStackTrace();
		}

		try {
			if (rs != null) {
				rs.close();
			}
		} catch (SQLException e) {

			e.printStackTrace();
		}

	}

}

Library.java

package com.hnpi.bean;

public class Library {

	
	/**
	 * ID
	 */
	private Integer id;
	/**
	 * 书名
	 */
	private String bookname;
	/**
	 * 作者
	 */
	private String writer;
	/**
	 * 编号
	 */
	private String number;
	/**
	 * 出版社
	 */
	private String press;
	
	
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getBookname() {
		return bookname;
	}
	public void setBookname(String bookname) {
		this.bookname = bookname;
	}
	public String getWriter() {
		return writer;
	}
	public void setWriter(String writer) {
		this.writer = writer;
	}
	public String getNumber() {
		return number;
	}
	public void setNumber(String number) {
		this.number = number;
	}
	public String getPress() {
		return press;
	}
	public void setPress(String press) {
		this.press = press;
	}
	public Library() {
		super();
		// TODO Auto-generated constructor stub
	}

	
	
}

LibraryService.java

package com.hnpi.service;

import java.util.List;

import com.hnpi.bean.Library;



	
	 public interface LibraryService {
		 List<Library> list();
		 
		 boolean delLibrary(Integer id);
		 
		 boolean delLibrary(Library library);
		 boolean addLibrary(Library library);
		 boolean updateLibrary(Library library);
}

LibraryServiceImpl.java

package c