www.pudn.com > StoreJava.rar > QusBean.java

package com.bitc.store;  
//定义Bean所属的套件  
  
//定义欲使用的套件  
import java.sql.*;  
  
public class QusBean  
{  
	//书籍名称  
	private String Title = "Access 2000 彻底研究";  
	  
	//书籍副标题  
	private String SubTitle = "入门应用、设计实例与数据库理论(附光盘)";  
  
	//问题数目  
	private int QusNum = 3;  
  
	//问卷问题  
	private String Qus[] = {"您满意本书的内容吗?",  
				"您满意本书的版面编辑吗?",  
				"您满意该书的封面设计吗?"};  
  
	//定义产生图表的颜色  
	private String Color[] = {"Yellow","DeepPink","DarkCyan","DeepSkyBlue",  
				  "Orange","LightSlateGray"};  
  
	//定义选项个数  
	private int OptNum = 5;  
  
	//定义选项  
	private String Opt[] = {"很满意","满意","尚可",  
			      	"不满意","很不满意"};  
  
	//以下的方法将取得Bean物件的属性  
	public String getQus(int i)  
	{ return Qus[i]; }  
	public String getOpt(int i)  
	{ return Opt[i]; }  
	public String getColor(int i)  
	{ return Color[i]; }  
	public String getTitle()  
	{ return this.Title; }  
	public String getSubTitle()  
	{ return this.SubTitle; }  
  
	//与数据库连结有关的Bean属性  
	private Connection con = null;  
	private Statement stmt = null;  
  
	public QusBean()  //建构子  
	{			  
	}  
  
	//将问卷的答案新增数据库, 回传值此动作所影响的记录笔数  
	public int InsertAns(Connection con, String rad1,   
				String rad2, String rad3)  
	{  
		int affect = 0;  
				  
		String strSQL = "INSERT INTO Qus(Qus1, Qus2, Qus3) " +  
			 	"VALUES(" + rad1 + "," +  
			 	rad2 + "," + rad3 + ")";  
		//建立将记录至数据库的SQL叙述  
  
		try{  
			this.con = con;  
			stmt = this.con.createStatement(  
				ResultSet.TYPE_SCROLL_INSENSITIVE,  
				ResultSet.CONCUR_READ_ONLY);  
			  
			affect = stmt.executeUpdate(strSQL);  
		}  
		catch(SQLException sex)  
		{  
			System.out.println(sex.toString());  
		}  
  
		return affect;  
	}  
  
	//取得记录的笔数  
	public int RecNum(Connection con, String filter)  
	{  
		String strSQL = "SELECT ID FROM Qus";  
		int num = 0;  
  
		//判断filter字串是否为空白字串  
		if(!filter.equals(""))  
		{  
			strSQL = strSQL + " WHERE " + filter;  
			//建立执行的SQL叙述  
		}	  
	  
		try{  
			Statement lstmt = con.createStatement(  
					ResultSet.TYPE_SCROLL_INSENSITIVE,  
					ResultSet.CONCUR_READ_ONLY);  
			//建立Statement物件  
	  
			ResultSet rs = lstmt.executeQuery(strSQL);  
			//执行SQL叙述并取得ResultSet物件			  
  
			rs.last(); //移至最後一笔记录  
			  
			num =  rs.getRow(); //取得记录的列数  
  
			rs.close(); //关闭ResultSet物件  
			lstmt.close(); //关闭Statement物件  
		}  
		catch(SQLException sex)  
		{  
			System.out.println(sex.toString());  
		}  
  
		return num;  
	}  
}