个人简历管理系统（resume）

package com.unissoft.teach.f.work.model; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import com.unissoft.teach.f.work.vo.Language; import com.unissoft.teach.f.work.vo.Study; import com.unissoft.teach.f.work.vo.User; import com.unissoft.teach.f.work.vo.Work; public class DAO { //构造方法 public DAO(){} /* * 创建数据库连接的连接方法，以便其它类调用 */ public Connection getConn() { Connection conn=null; try { Class.forName("com.mysql.jdbc.Driver"); conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/resume","root","mysql"); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return conn; } /* * 添加用户简历基本信息，通过BasicServlet传递参数来调用此方法，然后将数据插入数据库 */ public int regUser(String user_name,int user_sex, String sb_from,String user_degree, String sb_birthday, String user_school,String user_nation, String sb_hobby,String user_self) { Connection conn=getConn(); String sqlInsert="INSERT INTO tb_student(user_name,user_sex,user_from,user_degree,user_birthday,user_school,user_nation,user_hobby,user_self)VALUES(?,?,?,?,?,?,?,?,?)"; PreparedStatement stmt=null; try { stmt=conn.prepareStatement(sqlInsert); stmt.setString(1,user_name ); stmt.setInt(2, user_sex); stmt.setString(3, sb_from); stmt.setString(4, user_degree); stmt.setString(5,sb_birthday); stmt.setString(6, user_school); stmt.setString(7, user_nation); stmt.setString(8, sb_hobby); stmt.setString(9,user_self); //User user=new User(); //user.setUser_name(user_name); //System.out.println(user.getUser_name()); } catch (SQLException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } int tempFlag=0; try { tempFlag=stmt.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } /* * 关闭数据库的相关链接 */ finally { if(stmt!=null) { try { stmt.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } stmt=null; if(conn!=null) { try { conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } conn=null; } return tempFlag; } /* * 添加学习经历的方法，StudyServlet通过传递参数，将数据插入到数据库 */ public int insertStudy(String sb_time_start,String sb_time_end,String user_school,String prove_person,int user_id) { //创建数据连接 Connection conn=getConn(); String sqlInsert="INSERT INTO tb_study(time_start,time_end,user_school,prove_person,user_id)VALUES(?,?,?,?,?)"; PreparedStatement stmt=null; try { //User user=new User(); //System.out.println(user.getUser_name()); stmt=conn.prepareStatement(sqlInsert); stmt.setString(1,sb_time_start ); stmt.setString(2, sb_time_end); stmt.setString(3, user_school); stmt.setString(4, prove_person); stmt.setInt(5,user_id); //stmt.setInt(8,getIdByName(user.getUser_name()) ); } catch (SQLException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } int tempFlag=0; try { tempFlag=stmt.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } /* * 关闭数据库的相关链接 */ finally { if(stmt!=null) { try { stmt.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } stmt=null; if(conn!=null) { try { conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } conn=null; } return tempFlag; } /* * 添加工作经历的方法，WorkServlet通过传递参数将数据存入数据库 */ public int insertWork(String sb_time_start,String sb_time_end,String work_name,String user_self ,int user_id) { Connection conn=getConn(); String sqlInsert="INSERT INTO tb_work(time_start,time_end,work_name,user_self,user_id)VALUES(?,?,?,?,?)"; PreparedStatement stmt=null; try { //User user=new User(); //System.out.println(user.getUser_name()); //System.out.println("www"); stmt=conn.prepareStatement(sqlInsert); stmt.setString(1,sb_time_start ); stmt.setString(2, sb_time_end); stmt.setString(3, work_name); stmt.setString(4, user_self); stmt.setInt(5,user_id); } catch (SQLException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } int tempFlag=0; try { tempFlag=stmt.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } /* * 关闭相关的数据连接 */ finally { if(stmt!=null) { try { stmt.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } stmt=null; if(conn!=null) { try { conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } conn=null; } return tempFlag; } /* * 添加语言的方法，StudyServlet通过传递参数，将数据插入到数据库 */ public int insertLanguage(String language_name,String language_step ,int user_id) { Connection conn=getConn(); String sqlInsert="INSERT INTO tb_language(language_name,language_step,user_id)VALUES(?,?,?)"; PreparedStatement stmt=null; try { //User user=new User(); //System.out.println(user.getUser_name()); //System.out.println("www"); stmt=conn.prepareStatement(sqlInsert); stmt.setString(1,language_name ); stmt.setString(2, language_step); stmt.setInt(3, user_id); } catch (SQLException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } int tempFlag=0; try { tempFlag=stmt.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } /* * 关闭相关的数据连接 */ finally { if(stmt!=null) { try { stmt.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } stmt=null; if(conn!=null) { try { conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } conn=null; } return tempFlag; } /* * 此方法是用来获取user_id的，通过传递user_name来获取 */ public int getIdByName(String user_name) { Connection conn=getConn(); String sqlSelect="SELECT user_id FROM tb_student WHERE user_name=?"; PreparedStatement ps=null; int user_id=0; try { ps=conn.prepareStatement(sqlSelect); ps.setString(1, user_name); ResultSet rs=ps.executeQuery(); while(rs.next()) { user_id=rs.getInt("user_id"); } return user_id; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); return user_id; } } /* * 此方法是通过传递user_id来设定用户基本信息的，返回值为ArrayList */ public ArrayList getUser(int user_id) { ArrayList array=new ArrayList(200); Connection conn=getConn(); Statement stmt=null; ResultSet rs=null; String sql1="SELECT * FROM tb_student WHERE user_id='"+user_id+"'"; try { stmt=conn.createStatement(); rs=stmt.executeQuery(sql1); while(rs.n