package com.bitc.store;

//定義Bean所屬的套件



//定義欲使用的套件

import java.sql.*;



public class QusBean

{

	//書籍名稱

	private String Title = "Access 2000 徹底研究";

	

	//書籍副標(biāo)題

	private String SubTitle = "入門應(yīng)用、設(shè)計(jì)實(shí)例與數(shù)據(jù)庫理論(附光盤)";



	//問題數(shù)目

	private int QusNum = 3;



	//問卷問題

	private String Qus[] = {"您滿意本書的內(nèi)容嗎?",

				"您滿意本書的版面編輯嗎?",

				"您滿意該書的封面設(shè)計(jì)嗎?"};



	//定義產(chǎn)生圖表的顏色

	private String Color[] = {"Yellow","DeepPink","DarkCyan","DeepSkyBlue",

				  "Orange","LightSlateGray"};



	//定義選項(xiàng)個(gè)數(shù)

	private int OptNum = 5;



	//定義選項(xiàng)

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



	//與數(shù)據(jù)庫連結(jié)有關(guān)的Bean屬性

	private Connection con = null;

	private Statement stmt = null;



	public QusBean()  //建構(gòu)子

	{			

	}



	//將問卷的答案新增數(shù)據(jù)庫, 回傳值此動(dòng)作所影響的記錄筆數(shù)

	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 + ")";

		//建立將記錄至數(shù)據(jù)庫的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;

	}



	//取得記錄的筆數(shù)

	public int RecNum(Connection con, String filter)

	{

		String strSQL = "SELECT ID FROM Qus";

		int num = 0;



		//判斷filter字串是否為空白字串

		if(!filter.equals(""))

		{

			strSQL = strSQL + " WHERE " + filter;

			//建立執(zhí)行的SQL敘述

		}	

	

		try{

			Statement lstmt = con.createStatement(

					ResultSet.TYPE_SCROLL_INSENSITIVE,

					ResultSet.CONCUR_READ_ONLY);

			//建立Statement物件

	

			ResultSet rs = lstmt.executeQuery(strSQL);

			//執(zhí)行SQL敘述并取得ResultSet物件			



			rs.last(); //移至最後一筆記錄

			

			num =  rs.getRow(); //取得記錄的列數(shù)



			rs.close(); //關(guān)閉ResultSet物件

			lstmt.close(); //關(guān)閉Statement物件

		}

		catch(SQLException sex)

		{

			System.out.println(sex.toString());

		}



		return num;

	}

}