backupdata.java

对数据库中的信息进行撮合匹配

package com.cuohe.dblic;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import com.cuohe.userobj.BizReqinfo;

public class BackupData {
	public int BizdataBackup(ResultSet res,Connection conn)
	{
		try
		{
			BizReqinfo reqinfo = new BizReqinfo();
			reqinfo.setID(res.getInt(1));
			String title = res.getString(2);
			if(title == null)
			{
				title = "";
			}
			reqinfo.setTitle(title);
			String Group = res.getString(3);
			if(Group == null)
			{
				Group = "";
			}
			reqinfo.setGroup(Group);
			String CompName = res.getString(4);
			if(CompName == null)
			{
				CompName = "";
			}
			reqinfo.setCompName(CompName);
			String CompInfo = res.getString(5);
			if(CompInfo == null)
			{
				CompInfo = "";
			}
			reqinfo.setCompInfo(CompInfo);
			String Compmod = res.getString(6);
			if(Compmod == null)
			{
				Compmod = "";
			}
			reqinfo.setCompmod(Compmod);
			String PerName = res.getString(7);
			if(PerName == null)
			{
				PerName = "";
			}
			reqinfo.setPerName(PerName);
			String AreaPrv = res.getString(8);
			if(AreaPrv == null)
			{
				AreaPrv = "";
			}
			reqinfo.setAreaPrv(AreaPrv);
			String AreaCty = res.getString(9);
			if(AreaCty == null)
			{
				AreaCty = "";
			}
			reqinfo.setAreaCty(AreaCty);
			String CompAdds = res.getString(10);
			if(CompAdds == null)
			{
				CompAdds = "";
			}
			reqinfo.setCompAdds(CompAdds);
			String CompTel = res.getString(11);
			if(CompTel == null)
			{
				CompTel = "";
			}
			reqinfo.setCompTel(CompTel);
			String Mobile = res.getString(12);
			if(Mobile == null)
			{
				Mobile = "";
			}
			reqinfo.setMobile(Mobile);
			String Email = res.getString(13);
			if(Email == null)
			{
				Email = "";
			}
			reqinfo.setEmail(Email);
			String Fax = res.getString(14);
			if(Fax == null)
			{
				Fax = "";
			}
			reqinfo.setFax(Fax);
			String Web = res.getString(15);
			if(Web == null)
			{
				Web = "";
			}
			reqinfo.setWeb(Web);
			String Amount = res.getString(16);
			if(Amount == null)
			{
				Amount = "";
			}
			reqinfo.setAmount(Amount);
			String Price = res.getString(17);
			if(Price == null)
			{
				Price = "";
			}
			reqinfo.setPrice(Price);
			String Industry = res.getString(18);
			if(Industry == null)
			{
				Industry = "";
			}
			reqinfo.setIndustry(Industry);
			String Brand = res.getString(19);
			if(Brand == null)
			{
				Brand = "";
			}
			reqinfo.setBrand(Brand);
			String Notice = res.getString(20);
			if(Notice == null)
			{
				Notice = "";
			}
			reqinfo.setNotice(Notice);
			String SendTime = res.getString(21);
			if(SendTime == null)
			{
				SendTime = "";
			}
			reqinfo.setSendTime(SendTime);
			String Spec = res.getString(22);
			if(Spec == null)
			{
				Spec = "";
			}
			reqinfo.setSpec(Spec);
			String PubTime = res.getString(23);
			if(PubTime == null)
			{
				PubTime = "";
			}
			reqinfo.setPubTime(PubTime);
			String EndTime = res.getString(24);
			if(EndTime == null)
			{
				EndTime = "";
			}
			reqinfo.setEndTime(EndTime);
			reqinfo.setCreateTime(res.getString(25));
			
//			向表中插值
			String sql_str = "insert into Mth_RequirementInfobak values('" + reqinfo.getID() + "','" + reqinfo.getTitle() + 
							 "','" + reqinfo.getGroup() + "','" + reqinfo.getCompName() + "','" + reqinfo.getCompInfo() + 
							 "','" + reqinfo.getCompmod() + "','" + reqinfo.getPerName() + "','" + reqinfo.getAreaPrv() + 
							 "','" + reqinfo.getAreaCty() + "','" + reqinfo.getCompAdds() + "','" + reqinfo.getCompTel() + 
							 "','" + reqinfo.getMobile() +  "','" + reqinfo.getEmail() +  "','" + reqinfo.getFax() + 
							 "','" + reqinfo.getWeb() +  "','" + reqinfo.getAmount() +  "','" + reqinfo.getPrice() +
							 "','" + reqinfo.getIndustry() +  "','" + reqinfo.getBrand() +  "','" + reqinfo.getNotice() +
							 "','" + reqinfo.getSendTime() +  "','" + reqinfo.getSpec() +  "','" + reqinfo.getPubTime() +
							 "','" + reqinfo.getEndTime() + "'," + 0 + ",'" + reqinfo.getCreateTime() + "')";
			Statement stmt = conn.createStatement();
			stmt.executeUpdate(sql_str);
			stmt.close();
			return 1;
		}
		catch(Exception ex)
		{
			System.out.println("backuperr msg:" + ex);
		}
		return 0;
	}
}