select_many.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_many {
	
    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_many tb = new select_many();

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_many(String many_pro,String many_A,String many_B,String many_C,String many_D,String many_answ ,int many_num){
try{
db_conn.ConnectDB();
String sql="update 多选题 set 题目='"+many_pro+"',a='"+many_A+"',b='"+many_B+"',c='"+many_C+"',d='"+many_D+"',标准答案='"+many_answ+"' where 题号="+many_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_many(int many_num){
try{
db_conn.ConnectDB();
String sql="delete 多选题 where 题号="+many_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_many tb = new select_many();
	//ArrayList list = tb.getTestList1();
	 // for(int i=0;i<list.size();i++)
	  //{
		//select_many bea= (select_many)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_many("a", "a", "a", "a", "a", "a", 2);
   // }
	//tb.delete_many(2);
     
//}

}