jsp tomcat mysql smartupload简单网页

package control; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.Collection; import db.DBConnect; import model.Person; import util.Pagination; public class PersonControl { // 静态分页类成员变量 public static Pagination pageInstance = null; /** * 添加人员 * @param person * @return */ public boolean insertOnePerson(Person person){ DBConnect dbc = new DBConnect(); String sql = "INSERT INTO person (m_name,m_sex,nativeid,unitid,m_position,levelid,m_phone,m_mobile,m_arrtrans,m_arrtour,m_arrtime,m_room,a_id,m_notes,m_bool,m_depart,m_leftrans,m_leftime,m_leftour,m_pic,n_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; dbc.prepareStatement(sql); try { dbc.setString(1, person.getM_name()); dbc.setString(2,person.getM_sex()); dbc.setInt(3, person.getNativeid()); dbc.setInt(4, person.getUnitid()); dbc.setString(5, person.getM_position()); dbc.setInt(6,person.getLevelid()); dbc.setString(7,person.getM_phone()); dbc.setString(8,person.getM_mobile()); dbc.setString(9,person.getM_arrtrans()); dbc.setString(10,person.getM_arrtour()); dbc.setString(11,person.getM_arrtime()); dbc.setString(12,person.getM_room()); dbc.setInt(13,person.getA_id()); dbc.setString(14,person.getM_notes()); dbc.setString(15,person.getM_bool()); dbc.setString(16,person.getM_depart()); dbc.setString(17,person.getM_leftrans()); dbc.setString(18,person.getM_leftime()); dbc.setString(19,person.getM_leftour()); dbc.setString(20,person.getM_pic()); dbc.setInt(21,person.getN_id()); dbc.executeUpdate(); return true; } catch (SQLException e) { e.printStackTrace(); return false; } finally { dbc.close(); } } /** * 添加人员返程信息 * @param person * @return */ public boolean insertOnePersonBack(Person person){ DBConnect dbc = new DBConnect(); String sql = "INSERT INTO person (n_id,unitid,m_name,m_position,m_leftime,m_leftrans,m_leftour,m_notes) VALUES (?,?,?,?,?,?,?,?)"; dbc.prepareStatement(sql); try { dbc.setInt(1, person.getN_id()); dbc.setInt(2,person.getUnitid()); dbc.setString(3, person.getM_name()); dbc.setString(4,person.getM_position()); dbc.setString(5,person.getM_leftime()); dbc.setString(6,person.getM_leftrans()); dbc.setString(7,person.getM_leftour()); dbc.setString(8,person.getM_notes()); dbc.executeUpdate(); return true; } catch (SQLException e) { e.printStackTrace(); return false; } finally { dbc.close(); } } /** * 根据ID修改人员信息 * @param person * @param id * @return */ public boolean updateOnePerson(Person person,int id){ DBConnect dbc = new DBConnect(); String sql = "UPDATE person SET m_sex=?,nativeid=?,unitid=?,m_position=?,levelid=?,m_phone=?,m_mobile=?,m_arrtrans=?,m_arrtour=?,m_arrtime=?,m_room=?,a_id=?,m_notes=?,m_depart=?, m_leftrans=?, m_leftime=?, m_leftour=?, n_id=? WHERE id = ?"; dbc.prepareStatement(sql); try { dbc.setString(1,person.getM_sex()); dbc.setInt(2, person.getNativeid()); dbc.setInt(3, person.getUnitid()); dbc.setString(4, person.getM_position()); dbc.setInt(5,person.getLevelid()); dbc.setString(6,person.getM_phone()); dbc.setString(7,person.getM_mobile()); dbc.setString(8,person.getM_arrtrans()); dbc.setString(9,person.getM_arrtour()); dbc.setString(10,person.getM_arrtime()); dbc.setString(11,person.getM_room()); dbc.setInt(12,person.getA_id()); dbc.setString(13,person.getM_notes()); dbc.setString(14,person.getM_depart()); dbc.setString(15,person.getM_leftrans()); dbc.setString(16,person.getM_leftime()); dbc.setString(17,person.getM_leftour()); dbc.setInt(18,person.getN_id()); dbc.setInt(19, id); dbc.executeUpdate(); return true; } catch (SQLException e) { e.printStackTrace(); return false; } finally { dbc.close(); } } /** * 更新人员信息 * @param person * @param m_name * @param unitid * @param n_id * @return */ public boolean updatePersonBool(Person person,int m_id){ DBConnect dbc = new DBConnect(); String sql = "UPDATE person SET m_bool=?,m_name=?,m_sex=?nativeid=?,m_unit=?,m_position=?,levelid=?,m_mobile=?,m_room=?,m_notes=?,m_depart=? WHERE id=?"; dbc.prepareStatement(sql); try { dbc.setString(1,person.getM_bool()); dbc.setString(2,person.getM_name()); dbc.setString(3,person.getM_sex()); dbc.setInt(4,person.getNativeid()); dbc.setInt(5,person.getUnitid()); dbc.setString(6,person.getM_position()); dbc.setInt(7,person.getLevelid()); dbc.setString(8,person.getM_mobile()); dbc.setString(9,person.getM_room()); dbc.setString(10,person.getM_notes()); dbc.setString(11,person.getM_depart()); dbc.setInt(12, m_id); dbc.executeUpdate(); return true; } catch (SQLException e) { e.printStackTrace(); return false; } finally { dbc.close(); } } /** * 更新人员服务信息 * @param person * @param m_name * @param unitid * @param n_id * @return */ public boolean updatePerson(Person person,int m_id){ DBConnect dbc = new DBConnect(); String sql = "UPDATE person SET m_notes=? WHERE id=?"; dbc.prepareStatement(sql); try { dbc.setString(1,person.getM_notes()); dbc.setInt(2, m_id); dbc.executeUpdate(); return true; } catch (SQLException e) { e.printStackTrace(); return false; } finally { dbc.close(); } } /** * 更新人员活动信息 * @param id * @param a_id * @return */ public boolean updatePersonActivity(int a_id,int id){ DBConnect dbc = new DBConnect(); String sql = "UPDATE person SET a_id=? WHERE id=?"; dbc.prepareStatement(sql); try { dbc.setInt(1,a_id); dbc.setInt(2, id); dbc.executeUpdate(); return true; } catch (SQLException e) { e.printStackTrace(); return false; } finally { dbc.close(); } } /** * 根据活动ID更新人员信息 * @param a_id * @return */ public boolean updatePersonActivity2(int id,int a_id){ DBConnect dbc = new DBConnect(); String sql = "UPDATE person SET a_id=? WHERE a_id=?"; dbc.prepareStatement(sql); try { dbc.setInt(1,id); dbc.setInt(2, a_id); dbc.executeUpdate(); return true; } catch (SQLException e) { e.printStackTrace(); return false; } finally { dbc.close(); } } /** * 更新人员活动信息 * @param a_id * @param m_name * @param n_id * @param u_id * @return */ public boolean updatePersonactive(int a_id,String m_notes,String m_name,int n_id,int u_id){ DBConnect dbc = new DBConnect(); String sql = "UPDATE person SET a_id=?,m_notes=? WHERE m_name=? and n_id=? and unitid=?"; dbc.prepareStatement(sql); try { dbc.setInt(1,a_id); dbc.setString(2, m_notes); dbc.setString(3, m_name); dbc.setInt(4, n_id); dbc.setInt(5, u_id); dbc.executeUpdate(); return true; } catch (SQLException e) { e.printStackTrace(); return false; } finally { dbc.close(); } } /** * 删除人员信息 * @param id * @return */ public boolean deleteOnePerson(int id){ DBConnect dbc = new DBConnect(); String sql = "DELETE FROM person WHERE id = ?"; dbc.prepareStatement(sql); try { dbc.setInt(1, id); dbc.executeUpdate(); return true; } catch (SQLException e) { e.printStackTrace(); return false; } finally { dbc.close(); } } /** * 根据会议ID删除人员信息 * @param id * @return */ public boolean deleteOnePerson2(int id){ DBConnect dbc = new DBConnect(); String sql = "DELETE FROM person WHERE n_id = ?"; dbc.prepareStatement(sql); try { dbc.setInt(1, id); dbc.executeUpdate(); return true; } catch (SQLException e) { e.printStackTrace(); return fals