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;
	}
}