Contact_List.zip_contact_struts通讯录

package StudentOper; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import javax.servlet.http.HttpSession; import util.MyDate; import dao.Student; import dateBase.DBManager; public class sOperate { HttpSession session=null; DBManager dbm=new DBManager(); Connection con=null; boolean boo=false; PreparedStatement ps=null; Statement st=null; ResultSet rs=null; static int id=0; //注冊 public boolean SRegister(Student stu) { con=dbm.getCon(); String sql="INSERT INTO student (username,pwd,realname,age,sex,birthday," + "university,email,major,xueli,jianli)VALUES('" +stu.getName()+"','"+stu.getPwd()+"','"+stu.getRealname()+"'," +stu.getAge()+",'"+stu.getSex()+"','"+stu.getBirthday()+"','" +stu.getUniversity()+"','"+stu.getMajor()+"','" +stu.getEmail()+"','"+stu.getMajor()+"','"+stu.getJianli()+"')"; System.out.println("学生注册---------"+sql); try { ps = con.prepareStatement(sql); int a = ps.executeUpdate(); if(a>0) { doLogin(stu.getName(),stu.getPwd(),"student"); boo = true; } } catch (SQLException e) { System.out.println("学生注册失败"); e.printStackTrace(); }finally{ dbm.Close(null, null, con, ps); } return boo; } //登录 public int doLogin(String name,String pwd,String status) { String sql="select * from "+status+" where username='"+name+"'and pwd='"+pwd+"'"; System.out.println("登录-------"+sql); try { st=dbm.getCon().createStatement(); rs=st.executeQuery(sql); if(rs.next()) { id=rs.getInt("id"); return id; } } catch (SQLException e) { e.printStackTrace(); }finally{ dbm.Close(null,null, con, ps); } return id; } //修改学生信息 public boolean findStu(Student stu) { System.out.println("-------id-------"+id); String sql="UPDATE student SET pwd='"+stu.getPwd()+"',realname='"+stu.getRealname() +"',age='"+stu.getAge()+"',sex='"+stu.getSex() +"',birthday='"+stu.getBirthday()+"',university='"+stu.getUniversity() +"',email='"+stu.getEmail()+"',major='"+stu.getMajor() +"',xueli='"+stu.getXueli()+"',jianli='"+stu.getJianli()+ "' WHERE username='"+stu.getName()+"';"; System.out.println("修改学生信息------------"+sql); try { ps=dbm.getCon().prepareStatement(sql); int i=ps.executeUpdate(); if(i>0) { boo=true; } } catch (SQLException e) { System.out.println("修改学生信息失败------------"); e.printStackTrace(); } return boo; } //发布求职信息 public boolean Announce(Student stu){ System.out.println("---Announce----id-------"+id); MyDate date=new MyDate(); String sql="INSERT INTO stuannounce(userid,posi,salary,indate,remark,specialty,mydate)" + "VALUES ("+id+",'"+stu.getPosition()+"','"+stu.getSalary()+"','"+stu.getDate()+"','" +stu.getRemark()+"','"+stu.getSpecialty()+"','"+date.getDate()+"')"; System.out.println("--发布求职信息-------"+sql); try { ps=dbm.getCon().prepareStatement(sql); int i=ps.executeUpdate(); if(i>0) { boo=true; } } catch (SQLException e) { System.out.println("--发布求职信息失败-----"); e.printStackTrace(); } return boo; } //查询求职信息 public ResultSet findInfo() { Student student = null; String sql="select * FROM stuannounce WHERE userid="+id+";"; try { st=dbm.getCon().createStatement(); rs=st.executeQuery(sql); } catch (SQLException e) { System.out.println("--删除求职信息失败-------"); e.printStackTrace(); }finally{ dbm.Close(rs, st, con, ps); } return rs; } //删除求职信息 public boolean DeleteInfo(int id) { String sql="DELETE FROM stuannounce WHERE id="+id+";"; System.out.println("---删除求职信息----------"+sql); try { ps=dbm.getCon().prepareStatement(sql); int i=ps.executeUpdate(); if(i>0) { boo=true; } } catch (SQLException e) { System.out.println("--删除求职信息失败-------"); e.printStackTrace(); }finally { dbm.Close(rs, st, con, ps); } return boo; } //查询学生求职信息 public ResultSet findResume() { String sql="SELECT * FROM stuannounce ORDER BY mydate desc"; try { st=dbm.getCon().createStatement(); rs=st.executeQuery(sql); } catch (SQLException e) { System.out.println("----查询学生求职信息--------"); e.printStackTrace(); } return rs; } //查询学生求职详细信息 public Student findDetailInfo(int id) { Student stu=new Student(); String sql="select * from student where id="+id; try { st=dbm.getCon().createStatement(); rs=st.executeQuery(sql); if(rs.next()) { stu.setRealname(rs.getString("realname")); stu.setSex(rs.getString("sex")); stu.setEmail(rs.getString("email")); stu.setMajor(rs.getString("major")); stu.setUniversity(rs.getString("university")); stu.setXueli(rs.getString("xueli")); stu.setBirthday(rs.getString("birthday")); String sql1="select * from stuannounce where userid="+id; System.out.println("查询学生求职详细信息--------"+sql1); ResultSet rs1=st.executeQuery(sql1); if(rs1.next()) { stu.setSpecialty(rs1.getString("specialty")); stu.setPosition(rs1.getString("posi")); stu.setSalary(rs1.getString("salary")); stu.setTime(rs1.getString("mydate")); stu.setDate(rs1.getInt("indate")); } } } catch (SQLException e) { System.out.println("查询学生求职详细信息失敗--------"); e.printStackTrace(); }finally { dbm.Close(rs, st, con, ps); } return stu; } }