func.java

主要是描述的同学录系统

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;
	 }
}