card.java

JAVA邮件系统

/**
*
* CardClass.java
*
*/

import java.io.*;
import java.sql.*;

/*

 @author Liyan

*/

public class Card
{
	//名片基本信息：
	String userName;
	String cardName , nickName ,eMail,homeAddress ,company,city,companyAddress,homeZip;//前8个
	String country,companyZip,phone,classify ,bp,companyPhone,mPhone;//第10到16,第13个是classify
    String companyFax,homeFax,position,sex,birthday,homepage,addition;//第17到23
	int ID;//第9个
	//数据库要用到的变量：
	String sqlStr,queryStr="";
	SingleTemplate cardTemplate;
	
	DBOperater DB ;
	ResultSet rs;
		
	Card()
	{
		userName="";
		cardName="";
		nickName="";
		eMail="";
		homeAddress="";
		company="";
		city="";
		companyAddress="";
		homeZip="";
		ID=0;
		country="";
		companyZip="";
		phone="";
		classify="";
		bp="";
		companyPhone="";
		mPhone="";
		companyFax="";
		homeFax="";
		position="";
		sex="";
		birthday="";
		homepage="";
		addition="";
		queryStr="";
	}
	
	//清空所有变量：
	public void clear()
	{
		userName="";
		cardName="";
		nickName="";
		eMail="";
		homeAddress="";
		company="";
		city="";
		companyAddress="";
		homeZip="";
		ID=0;
		country="";
		companyZip="";
		phone="";
		classify="";
		bp="";
		companyPhone="";
		mPhone="";
		companyFax="";
		homeFax="";
		position="";
		sex="";
		birthday="";
		homepage="";
		addition="";
		queryStr="";

		if(DB!=null)
			DB.close();
	}
	
	//设置名片值
	public void setValues(String tmpUserName,
			String tmpCardName ,String tmpNickName ,String tmpEmail,String tmpHomeAddress ,
			String tmpCompany,String tmpCity,String tmpCompanyAddress,String tmpZip,int tmpID,//前9个
			String tmpCountry,String tmpCompanyZip,String tmpPhone,String tmpClassify ,
			String tmpBp,String tmpCompanyPhone,String tmpMPhone,//第10到16,第13个是classify
			String tmpCompanyFax,String tmpFax,String tmpPosition,String tmpSex,
			String tmpBirthday,String tmpHomepage,String tmpAddition)//第17到23
	{
		userName=tmpUserName.trim();
		cardName=tmpCardName.trim();
		nickName=tmpNickName.trim();
		eMail=tmpEmail.trim();
		homeAddress=tmpHomeAddress.trim();
		company=tmpCompany.trim();
		city=tmpCity.trim();
		companyAddress=tmpCompanyAddress.trim();
		homeZip=tmpZip.trim();
		ID=tmpID;
		country=tmpCountry.trim();
		companyZip=tmpCompanyZip.trim();
		phone=tmpPhone.trim();
		classify=tmpClassify.trim();
		bp=tmpBp.trim();
		companyPhone=tmpCompanyPhone.trim();
		mPhone=tmpMPhone.trim();
		companyFax=tmpCompanyFax.trim();
		homeFax=tmpFax.trim();
		position=tmpPosition.trim();
		sex=tmpSex.trim();
		birthday=tmpBirthday.trim();
		homepage=tmpHomepage.trim();
		addition=tmpAddition.trim();
	}
	
	//名片信息按数组取出：
	public String[] getDataArray()
	{
		String sDataArray[]=new String[24];
		
		sDataArray[0]=userName;
		sDataArray[1]=cardName;
		sDataArray[2]=nickName;
		sDataArray[3]=eMail;
		sDataArray[4]=homeAddress;
		sDataArray[5]=company;
		sDataArray[6]=city;
		sDataArray[7]=companyAddress;
		sDataArray[8]=homeZip;
		sDataArray[9]=""+ID;
		sDataArray[10]=country;
		sDataArray[11]=companyZip;
		sDataArray[12]=phone;
		sDataArray[13]=classify;
		sDataArray[14]=bp;
		sDataArray[15]=companyPhone;
		sDataArray[16]=mPhone;
		sDataArray[17]=companyFax;
		sDataArray[18]=homeFax;
		sDataArray[19]=position;
		sDataArray[20]=sex;
		sDataArray[21]=birthday;
		sDataArray[22]=homepage;
		sDataArray[23]=addition;

		return sDataArray;
	}
	
	//名片信息，单值设置：
	public void setUserName(String tmpUserName) {userName=tmpUserName;}
	public void setCardName(String tmpCardName) {cardName=tmpCardName;}
	public void setNickName(String tmpNickName) {nickName=tmpNickName;}
	public void setEmail(String tmpEmail) {eMail=tmpEmail;}
	public void setHomeAddress(String tmpHomeAddress){homeAddress=tmpHomeAddress;}
	public void setCompany(String tmpCompany){company=tmpCompany;}
	public void setCity(String tmpCity){city=tmpCity;}
	public void setCompanyAddress(String tmpCompanyAddress){companyAddress=tmpCompanyAddress;}
	public void setHomeZip(String tmpZip){homeZip=tmpZip;}
	public void setID(int tmpID){ID=tmpID;}
	public void setCountry(String tmpCountry){country=tmpCountry;}
	public void setCompanyZip(String tmpCompanyZip){companyZip=tmpCompanyZip;}
	public void setPhone(String tmpPhone){phone=tmpPhone;}
	public void setClassify(String tmpClassify){classify=tmpClassify;}
	public void setBp(String tmpBp){bp=tmpBp;}
	public void setCompanyPhone(String tmpCompanyPhone){companyPhone=tmpCompanyPhone;}
	public void setMphone(String tmpMPhone){mPhone=tmpMPhone;}
	public void setCompanyFax(String tmpCompanyFax){companyFax=tmpCompanyFax;}
	public void setFax(String tmpFax){homeFax=tmpFax;}
	public void setPosition(String tmpPosition){position=tmpPosition;}
	public void setSex(String tmpSex){sex=tmpSex;}
	public void setBirthday(String tmpBirthday){birthday=tmpBirthday;}
	public void setHomepage(String tmpHomepage){homepage=tmpHomepage;}
	public void setAddition(String tmpAddition){addition=tmpAddition;}
	
	//名片信息，单值取出：
	public String getUserName() {return userName;}
	public String getCardName() {return cardName;}
	public String getNickName() {return nickName;}
	public String getEMail() {return eMail;}
	public String getHomeAddress(){return homeAddress;}
	public String getCompany(){return company;}
	public String getCity(){return city;}
	public String getCompanyAddress(){return companyAddress;}
	public String getHomeZip(){return homeZip;}
	public int getID(){return ID;}
	public String getCountry(){return country;}
	public String getCompanyZip(){return companyZip;}
	public String getPhone(){return phone;}
	public String getClassify(){return classify;}
	public String getBp(){return bp;}
	public String getCompanyPhone(){return companyPhone;}
	public String getMphone(){return mPhone;}
	public String getCompanyFax(){return companyFax;}
	public String getFax(){return homeFax;}
	public String getPosition(){return position;}
	public String getSex(){return sex;}
	public String getBirthday(){return birthday;}
	public String getHomepage(){return homepage;}
	public String getAddition(){return addition;}
	
	//查询设置：
	public void setQuery(String qType,String qValue)
	{
		queryStr+=" and " + qType.trim() + " like '" + qValue.trim() + "%'";
	}
	

	//执行数据库操作：
	public boolean query(String user)
	{
		sqlStr = "select * from card where UserName='" + user + "'" +queryStr+" order by cardname";
		DB = new DBOperater("Card");
		rs = DB.executeQuery(sqlStr);
		return true;
	}
	
	public boolean read()
	{
		if(rs==null){
			DB.close();
			return false;
		}
		try 
		{	   	    	
	   	    if(!rs.next())
	   	    { // 记录已空
				DB.close();
	   	    	return false;
	   	    }
	   	    //"UserName"
			userName=rs.getString(1);
			//"ID"
			ID=rs.getInt(2);
			//"CardName"
			cardName=rs.getString(3);
			//"Sex"
			sex=rs.getString(4);
			//"Classify"
			classify=rs.getString(5);
			//"Company"
			company=rs.getString(6);
			//"Position"
			position=rs.getString(7);
			//"Phone"
			phone=rs.getString(8);
			//"MPhone"
			mPhone=rs.getString(9);
			//"Bp"
			bp=rs.getString(10);
			//"Email"
			eMail=rs.getString(11);
			//"country"
			country=rs.getString(12);
			//"city"
			city=rs.getString(13);
			//"homeaddress"
			homeAddress=rs.getString(14);
			//"homezip"
			homeZip=rs.getString(15);
			//"homeFax"
			homeFax=rs.getString(16);
			//"nickname"
			nickName=rs.getString(17);
			//"companyaddress"
			companyAddress=rs.getString(18);
			//"companyzip"
			companyZip=rs.getString(19);
			//"companyphone"
			companyPhone=rs.getString(20);
			//"companyfax"
			companyFax=rs.getString(21);
			//"homepage"
			homepage=rs.getString(22);
			//"birthday"
			birthday=rs.getString(23);
			//"addition"
			addition=rs.getString(24);
		} catch(Exception ex) {
			System.err.println("SQLException: " + ex.getMessage());
			DB.close();
			return false;
		}
		return true;
	}
	
	public boolean save()
	{
		if (cardName.compareTo("")==0)
			return false;
		
		if (ID==0)//新名片入库：
		{
			
			//寻找最大Id
			DB = new DBOperater("Card");
			rs=DB.executeQuery("Select Id From card Where UserName='"+userName+"' order by Id Desc");
			if(rs==null){
				DB.close();
				return false;
			}
			try
			{
				if (rs.next())
					//"id"
	   				ID=rs.getInt(1);
				ID++;
			} catch(Exception ex) {
				System.err.println("SQLException: " + ex.getMessage());
				DB.close();
			}
			DB.close();
			
			//加新名片：
			sqlStr="INSERT INTO card(username,id,cardname,sex,classify,company,position,phone, mphone,";
			sqlStr+="bp, email,country,city, homeaddress,homezip,homefax,nickname,companyaddress,";
			sqlStr+="companyzip, companyphone, companyfax,homepage,birthday,addition )";
			sqlStr+="VALUES ('"+userName+"',"+ID+",'"+cardName+"','"+sex+"','"+classify+"','";
			sqlStr+=company+"','"+position+"','"+phone+"','"+mPhone+"','"+bp+"','"+eMail+"','";
			sqlStr+=country+"','"+city+"','"+homeAddress+"','"+homeZip+"','"+homeFax+"','"+nickName+"','";
			sqlStr+=companyAddress+"','"+companyZip+"','"+companyPhone+"','"+companyFax+"','"+homepage+"','";
			sqlStr+=birthday+"','"+addition+"' )";
		} else {//更新数据库：
			sqlStr="update card set CardName='"+cardName+"',Sex='"+sex+"',Classify='"+classify;
			sqlStr+="',Company='"+company+"',Position='"+position+"',Phone='"+phone;
			sqlStr+="',mPhone='"+mPhone+"',Bp='"+bp+"',Email='"+eMail+"' ";//旧表中的数据
			sqlStr+=",country='"+country+"',city='"+city+"',homeAddress='"+homeAddress+"' ";
			sqlStr+=",homeZip='"+homeZip+"',homeFax='"+homeFax+"',nickName='"+nickName+"' ";
			sqlStr+=",companyAddress='"+companyAddress+"',companyZip='"+companyZip+"',companyPhone='"+companyPhone+"' ";
			sqlStr+=",companyFax='"+companyFax+"',homepage='"+homepage+"',birthday='"+birthday+"' ";
			sqlStr+=",addition='"+addition+"' ";
			sqlStr+="where id="+ ID + " and username='"+userName+"'";
		}
		
		//数据库中的操作：
		DB = new DBOperater("Card");
	    DB.executeUpdate(sqlStr);
		DB.close();
		return true;
	}
	
	public boolean delete(String user,String sId)
	{
		DB = new DBOperater("card");
		sqlStr="Delete From Card Where UserName='" + user + "' AND id=" + sId;
	    DB.executeUpdate(sqlStr);
        DB.close();
		return true;
	}
	
}