图书管理系统

JSP图书管理系统

mvc结构

简单的一些功能代码

Bean包

package com.hnpi.bean;

public class User {

	private Integer id;
	private String name;
	private String sex;
	private Integer age;
	private String phone;
	private String address;

	public Integer getId() {
		return id;
	}

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

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getSex() {
		return sex;
	}

	public void setSex(String sex) {
		this.sex = sex;
	}

	public Integer getAge() {
		return age;
	}

	public void setAge(Integer age) {
		this.age = age;
	}

	public String getPhone() {
		return phone;
	}

	public void setPhone(String phone) {
		this.phone = phone;
	}

	public String getAddress() {
		return address;
	}

	public void setAddress(String address) {
		this.address = address;
	}

	public User() {
		super();
		// TODO Auto-generated constructor stub
	}

}

service包

package com.hnpi.service;

import java.util.List;

import com.hnpi.bean.User;

public interface UserSevice {
	List<User> list();
	
	boolean	delUser(Integer id);
	
	boolean	delUser(User user);
	
}

serviceImpl包

package com.hnpi.service.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import com.hnpi.bean.User;
import com.hnpi.service.UserSevice;
import com.hnpi.util.DBUtil;

public class UserServiceImpl implements UserSevice {

	public List<User> list() {
		List<User> users = new ArrayList<User>();

		// TODO 从数据库中获取数据,然后组装成List<User> 然后返回

		Connection conn = DBUtil.getConn();
		String sql = "select * from users";
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			ps = conn.prepareStatement(sql);
			rs = ps.executeQuery();
			while (rs.next()) {
				User user = new User();
				user.setId(rs.getInt(1));
				user.setName(rs.getString(2));
				user.setSex(rs.getString(3));
				user.setAge(rs.getInt(4));
				user.setPhone(rs.getString(5));
				user.setAddress(rs.getString(6));
				users.add(user);
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			DBUtil.closeConn(conn, ps, null);
		}

		return users;
	}

	public boolean delUser(Integer id) {
		Connection conn = DBUtil.getConn();
		String sql = "delete from users where id = ?";
		PreparedStatement ps = null;
		int count = 0;
		try {
			ps = conn.prepareStatement(sql);

			ps.setInt(1, id);
			count = ps.executeUpdate();

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			DBUtil.closeConn(conn, ps, null);
		}

		if (count > 0)
			return true;
		else
			return false;
	}

	public boolean delUser(User user) {
		Connection conn = DBUtil.getConn();
		String sql = "delete from users where id = ?";
		PreparedStatement ps = null;
		int count = 0;
		try {
			ps = conn.prepareStatement(sql);

			ps.setInt(1, user.getId());
			count = ps.executeUpdate();

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			DBUtil.closeConn(conn, ps, null);
		}

		if (count > 0)
			return true;
		else
			return false;
	}

}

servlet包

package com.hnpi.service.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import com.hnpi.bean.User;
import com.hnpi.service.UserSevice;
import com.hnpi.util.DBUtil;

public class UserServiceImpl implements UserSevice {

	public List<User> list() {
		List<User> users = new ArrayList<User>();

		// TODO 从数据库中获取数据,然后组装成List<User> 然后返回

		Connection conn = DBUtil.getConn();
		String sql = "select * from users";
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			ps = conn.prepareStatement(sql);
			rs = ps.executeQuery();
			while (rs.next()) {
				User user = new User();
				user.setId(rs.getInt(1));
				user.setName(rs.getString(2));
				user.setSex(rs.getString(3));
				user.setAge(rs.getInt(4));
				user.setPhone(rs.getString(5));
				user.setAddress(rs.getString(6));
				users.add(user);
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			DBUtil.closeConn(conn, ps, null);
		}

		return users;
	}

	public boolean delUser(Integer id) {
		Connection conn = DBUtil.getConn();
		String sql = "delete from users where id = ?";
		PreparedStatement ps = null;
		int count = 0;
		try {
			ps = conn.prepareStatement(sql);

			ps.setInt(1, id);
			count = ps.executeUpdate();

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			DBUtil.closeConn(conn, ps, null);
		}

		if (count > 0)
			return true;
		else
			return false;
	}

	public boolean delUser(User user) {
		Connection conn = DBUtil.getConn();
		String sql = "delete from users where id = ?";
		PreparedStatement ps = null;
		int count = 0;
		try {
			ps = conn.prepareStatement(sql);

			ps.setInt(1, user.getId());
			count = ps.executeUpdate();

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			DBUtil.closeConn(conn, ps, null);
		}

		if (count > 0)
			return true;
		else
			return false;
	}

}

package com.hnpi.service.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import com.hnpi.bean.User;
import com.hnpi.service.UserSevice;
import com.hnpi.util.DBUtil;

public class UserServiceImpl implements UserSevice {

	public List<User> list() {
		List<User> users = new ArrayList<User>();

		// TODO 从数据库中获取数据,然后组装成List<User> 然后返回

		Connection conn = DBUtil.getConn();
		String sql = "select * from users";
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			ps = conn.prepareStatement(sql);
			rs = ps.executeQuery();
			while (rs.next()) {
				User user = new User();
				user.setId(rs.getInt(1));
				user.setName(rs.getString(2));
				user.setSex(rs.getString(3));
				user.setAge(rs.getInt(4));
				user.setPhone(rs.getString(5));
				user.setAddress(rs.getString(6));
				users.add(user);
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			DBUtil.closeConn(conn, ps, null);
		}

		return users;
	}

	public boolean delUser(Integer id) {
		Connection conn = DBUtil.getConn();
		String sql = "delete from users where id = ?";
		PreparedStatement ps = null;
		int count = 0;
		try {
			ps = conn.prepareStatement(sql);

			ps.setInt(1, id);
			count = ps.executeUpdate();

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			DBUtil.closeConn(conn, ps, null);
		}

		if (count > 0)
			return true;
		else
			return false;
	}

	public boolean delUser(User user) {
		Connection conn = DBUtil.getConn();
		String sql = "delete from users where id = ?";
		PreparedStatement ps = null;
		int count = 0;
		try {
			ps = conn.prepareStatement(sql);

			ps.setInt(1, user.getId());
			count = ps.executeUpdate();

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			DBUtil.closeConn(conn, ps, null);
		}

		if (count > 0)
			return true;
		else
			return false;
	}

}

util包

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=MyDB";
		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();
		}

	}

}