systembean.java

1 系统简介 1.1 系统名称：bugtrail 1.2 适用范围：大型或小型公司 1.3 用途：在项目周期内进行项目管理

/*
 * 创建日期 2006-12-19
 *
 * TODO 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
package bugtrail.bean;

import java.sql.ResultSet;

import bugtrail.util.CharsetProcess;
import bugtrail.util.SqlHelper;
import bugtrail.basic.System;

public class SystemBean {
	private SqlHelper helper;
	
	//得到一个连接
//    public SystemBean() throws Exception{
//    	helper = new SqlHelper();
//    }
    
	public System getCompanyInfo()throws Exception{
		System sysInfo = new System();
		helper = new SqlHelper();
		ResultSet rs = helper.executeHelper("select * from system");
		while(rs.next()){
			sysInfo.setCompanyName(rs.getString("companyName"));
			sysInfo.setCompanyURL(rs.getString("companyURL"));
			sysInfo.setCopyright(rs.getString("copyright"));
			
			sysInfo.setEmailAddress(rs.getString("emailAddress"));	
			sysInfo.setEmailUsername(rs.getString("emailUsername"));
			sysInfo.setEmailPassword(rs.getString("emailPassword"));
			sysInfo.setSmtp(rs.getString("smtp"));	
		}
		helper.closeAll();
		return sysInfo;
	 }
	
	public void updateSystem(System sys)throws Exception{
		helper = new SqlHelper();
		helper.updateHelper("update system set " 
				+"companyName='"+ CharsetProcess.U2C(sys.getCompanyName())
				+ "',companyURL='" +  CharsetProcess.U2C(sys.getCompanyURL())
				+"',copyright='"+  CharsetProcess.U2C(sys.getCopyright())
				+"',smtp='"+ CharsetProcess.U2C(sys.getSmtp())
				+"', emailAddress='"+  CharsetProcess.U2C(sys.getEmailAddress())
				+ "', emailUsername='"+  CharsetProcess.U2C(sys.getEmailUsername())
				+ "', emailPassword='"+  CharsetProcess.U2C(sys.getEmailPassword())
				+ "' where id='1'");
		helper.closeAll();
	}
	
	public System getJMailInfo()throws Exception{
		System mailInfo = new System();
		helper = new SqlHelper();
		ResultSet rs = helper.executeHelper("select * from system");
		while(rs.next()){
			mailInfo.setEmailAddress(rs.getString("emailAddress"));
			mailInfo.setEmailUsername(rs.getString("emailUsername"));
			mailInfo.setEmailPassword(rs.getString("emailPassword"));
			mailInfo.setSmtp(rs.getString("smtp"));		
		}
		helper.closeAll();
		return mailInfo;
	}
}