select_single.java

在线考试系统

package com.gton.bean;

import java.io.PrintWriter;
import java.sql.ResultSet;
import java.util.ArrayList;

import com.gton.bean.Bean.test1Bean;
import com.gton.bean.util.DB_Conn;

public class select_single {
	
    private int test_number;
	private String test_Title;
    private String test_A;
    private String test_B;
    private String test_C;
    private String test_D;
	private String test_answer;
  
    
	 DB_Conn db_conn=new DB_Conn();
	 private PrintWriter out = null;
	 ResultSet  rs=null;
	 
	   public int getTest_number() {
			return test_number;
		}


		public void setTest_number(int test_number) {
			this.test_number = test_number;
		}


		public String getTest_Title() {
			return test_Title;
		}


		public void setTest_Title(String test_Title) {
			this.test_Title = test_Title;
		}


		public String getTest_A() {
			return test_A;
		}


		public void setTest_A(String test_A) {
			this.test_A = test_A;
		}


		public String getTest_B() {
			return test_B;
		}


		public void setTest_B(String test_B) {
			this.test_B = test_B;
		}


		public String getTest_C() {
			return test_C;
		}


		public void setTest_C(String test_C) {
			this.test_C = test_C;
		}


		public String getTest_D() {
			return test_D;
		}


		public void setTest_D(String test_D) {
			this.test_D = test_D;
		}

        public String getTest_answer() {
		return test_answer;
	    }


	    public void setTest_answer(String test_answer) {
		this.test_answer = test_answer;
	    }


/////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////取单选题///////////////////////////////////////////////// 
public ArrayList getTestList1()
{ 
ArrayList list = new ArrayList();
db_conn.ConnectDB();
try 
{
String sql ="select * from 单选题";
rs=db_conn.sm.executeQuery(sql);
while(rs.next())
{
select_single tb = new select_single();

tb.setTest_number(rs.getInt("题号"));
tb.setTest_Title(rs.getString("题目").trim());
tb.setTest_A(rs.getString("a"));
tb.setTest_B(rs.getString("b"));
tb.setTest_C(rs.getString("c"));
tb.setTest_D(rs.getString("d"));
tb.setTest_answer(rs.getString("标准答案").trim());

list.add(tb);
}
}
catch(Exception e)
{
e.printStackTrace();
out.print("数据库连接失败!");
}
return list;
}
/////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////修改单选题///////////////////////////////////////////////// 


public boolean modify_single(String single_pro,String single_A,String single_B,String single_C,String single_D,String single_answ ,int single_num){
	try{
		db_conn.ConnectDB();
		String sql="update 单选题 set 题目='"+single_pro+"',a='"+single_A+"',b='"+single_B+"',c='"+single_C+"',d='"+single_D+"',标准答案='"+single_answ+"' where 题号="+single_num;
		if(db_conn.sm.executeUpdate(sql)==0) return false;
	}catch(Exception e){
		System.out.println(e.toString());
	}finally {
		db_conn.CloseDB();
	}
	return true;
}

/////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////删除单选题///////////////////////////////////////////////// 


public boolean delete_single(int single_num){
try{
db_conn.ConnectDB();
String sql="delete 单选题 where 题号="+single_num;
if(db_conn.sm.executeUpdate(sql)==0) return false;
}catch(Exception e){
System.out.println(e.toString());
}finally {
db_conn.CloseDB();
}
return true;
}

//public static void main(String[] args) 
//{
	//select_single tb = new select_single();
	//ArrayList list = tb.getTestList1();
	//  for(int i=0;i<list.size();i++)
	 // {
	//	select_single bea= (select_single)list.get(i);
		// System.out.println("题号:" + bea.getTest_number());
	   //  System.out.println(bea.getTest_Title()); 
	  //   System.out.println("A:" + bea.getTest_A());
	  //  System.out.println("B:" + bea.getTest_B()); 
	   //  System.out.println("C:" + bea.getTest_C());
	  //   System.out.println("D:" + bea.getTest_D()); 
	   //  System.out.println("标准答案:" + bea.getTest_answer());          
   //  }
	//tb.modify_single("a", "a", "a", "a", "a", "a", 2);
	//tb.delete_single(1);
//}

}