linkmanmanager.java

地址薄

package javabean;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Iterator;
import java.util.Vector;
import javabean.LinkMan;

public class LinkManManager {

    private Dao dao=Dao.Instance();
	
	public LinkManManager()
	{
		
	}
	//返回影响的行数,返回1正确,其它错误
	public int insertLinkMan(LinkMan linkMan)
	{
		String sql="insert into linkman (name,sex,phone,address,userid) values ('"+linkMan.getName()+"',"+linkMan.getSex()
		            +",'"+linkMan.getPhone()+"','"+linkMan.getAddress()+"',"
		            +linkMan.getUserId()+")";
		int i=dao.executeUpdate(sql);
		return i;
	}
	//返回影响的行数,返回1正确,其它错误
	public int deleteLinkMan(int id)
	{
		String sql="delete linkman where id="+id;
		int i=dao.executeUpdate(sql);
		return i;
	}
	//返回影响的行数,返回1正确,其它错误
	public int updateLinkMan(LinkMan linkMan)
	{
		String sql="update linkman set name='"+linkMan.getName()+"',sex="+linkMan.getSex()
		            +",phone='"+linkMan.getPhone()+"',address='"+linkMan.getAddress()
		               +"' where id="+linkMan.getId();
		int i=dao.executeUpdate(sql);
		return i;
	}
    //检索满足条件的联系人,
	public Vector queryLinkMan(String condition)
	{
		ResultSet rs=dao.executeQuery(condition);
		Vector vector=new Vector();
		try {
			while(rs.next())
			{
				LinkMan linkMan=new LinkMan();
				linkMan.setId(rs.getInt("id"));
				linkMan.setUserId(rs.getInt("userid"));
				linkMan.setName(rs.getString("name"));
				linkMan.setSex(rs.getInt("sex"));
				linkMan.setPhone(rs.getString("phone"));
				linkMan.setAddress(rs.getString("address"));
				vector.add(linkMan);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally
		{
			dao.CloseDB();
		}
		return vector;
	}
	
//	public static void main(String[] args)
//	{
//		LinkManManager linkManManager=new LinkManManager();
//		LinkMan linkMan=new LinkMan();
//		String condition="select linkman.* from linkman,userInfo where linkman.userid=userInfo.id and userInfo.id=10";
//		Vector vector=linkManManager.queryLinkMan(condition);
//		
//		Iterator i=vector.iterator();
//		while(i.hasNext())
//		{
//			linkMan=(LinkMan) i.next();
//			System.out.println(linkMan.getId()+" "+linkMan.getName()+" "+linkMan.getSex()+" "+linkMan.getAddress());
//		}
//		linkMan.setUserId(10);
//		linkMan.setName("dddddd");
//		linkMan.setSex(1);
//		linkMan.setPhone("01329291292");
//		linkMan.setAddress("重庆市南岸区96号");
//		linkMan.setId(8);
//		System.out.println(linkManManager.updateLinkMan(linkMan));
//		System.out.println(linkManManager.insertLinkMan(linkMan));
//		System.out.println(linkManManager.deleteLinkMan(7));
//	}
}