tongxunlu.rar_同学录_同学录系统_留言本

package com.friend; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import com.friend.Vo; import com.user.Conn; public class Func { Conn conn=null; Vo vo=null; Connection con=null; Statement stmt=null;//一般的操作平台 PreparedStatement pstmt=null;//预处理操作平台 ResultSet rs=null; boolean flag=false; List list=null; public Vo getVo() { return vo; } public void setVo(Vo vo) { this.vo = vo; } public String trans(String chi) { String result = null; byte temp[]; try { temp = chi.getBytes("iso-8859-1"); result = new String(temp); } catch (java.io.UnsupportedEncodingException e) { System.out.println(e.toString()); } return result; } public String trans(Object chi) { return trans(chi.toString()); } public boolean doAdd(Vo vo) { String str="select max(id) from friend"; String sql="insert into friend values(?,?,?,?,?,?,?,?,?)"; int num=0; try { conn=new Conn(); con=conn.getConn(); stmt=con.createStatement(); rs=stmt.executeQuery(str); if(rs.next()) { num=rs.getInt(1); } rs.close(); stmt.close(); String address = vo.getAddress(); if(address!=""||address!=null) { address=this.trans(address); } pstmt=con.prepareStatement(sql); pstmt.setInt(1, num+1); pstmt.setInt(2, vo.getUserid()); pstmt.setInt(3,vo.getSex()); pstmt.setInt(4,vo.getRelation()); pstmt.setString(5,vo.getPhone()); pstmt.setString(6,vo.getEmail()); pstmt.setString(7,address); pstmt.setDate(8,new java.sql.Date(new java.util.Date().getTime())); pstmt.setString(9,vo.getName()); pstmt.executeUpdate(); con.close(); flag=true; }catch(Exception e) { System.out.println("添加出现异常"); e.printStackTrace(); } return flag; } public List getAll(int userid) { list = new ArrayList(); String sql="select * from friend where userid="+userid; try { conn=new Conn(); con=conn.getConn(); stmt=con.createStatement(); rs=stmt.executeQuery(sql); while(rs.next()) { Vo vo = new Vo(); vo.setId(rs.getString(1)); vo.setUserid(rs.getInt(2)); vo.setSex(rs.getInt(3)); vo.setRelation(rs.getInt(4)); vo.setPhone(rs.getString(5)); vo.setEmail(rs.getString(6)); vo.setAddress(rs.getString(7)); vo.setAddtime(rs.getDate(8).toString()); vo.setName(rs.getString(9)); list.add(vo); } rs.close(); stmt.close(); con.close(); }catch(Exception e) { System.out.println("查询出现异常"); e.printStackTrace(); } return list; } public boolean deleteFriend(String id) { String str1="delete from friend where id="+id; try { conn=new Conn(); con=conn.getConn(); stmt=con.createStatement(); stmt.executeUpdate(str1); flag=true; stmt.close(); con.close(); }catch(Exception e) { System.out.println("删除出现异常"); e.printStackTrace(); } return flag; } public Vo findFriend(String id) { String str1="select * from friend where id="+id; try { conn=new Conn(); con=conn.getConn(); stmt=con.createStatement(); rs=stmt.executeQuery(str1); if(rs.next()) { vo =new Vo(); vo.setId(rs.getString(1)); vo.setUserid(rs.getInt(2)); vo.setSex(rs.getInt(3)); vo.setRelation(rs.getInt(4)); vo.setPhone(rs.getString(5)); vo.setEmail(rs.getString(6)); vo.setAddress(rs.getString(7)); vo.setName(rs.getString(9)); } rs.close(); stmt.close(); con.close(); }catch(Exception e) { System.out.println("查找出现异常"); e.printStackTrace(); } return vo; } public boolean editFriend(Vo vo) { String address = vo.getAddress(); if(address!=""||address!=null) { address=this.trans(address); } String str1="update friend set name='"+vo.getName()+"', relation="+vo.getRelation()+", phone='"+vo.getPhone()+"', address='"+address+"',sex="+vo.getSex()+", email='"+vo.getEmail()+"' where id="+vo.getId(); System.out.print(str1); try { conn=new Conn(); con=conn.getConn(); stmt=con.createStatement(); stmt.executeUpdate(str1); flag=true; stmt.close(); con.close(); }catch(Exception e) { System.out.println("修改出现异常"); e.printStackTrace(); } return flag; } }