select_judge.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_judge {
	
    private int test_number;
	private String test_Title;
	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_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_judge tb = new select_judge();

tb.setTest_number(rs.getInt("题号"));
tb.setTest_Title(rs.getString("题目").trim());
tb.setTest_answer(rs.getString("标准答案").trim());

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

/////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////修改判断题///////////////////////////////////////////////// 


public boolean modify_judge(String judge_pro,String judge_answ ,int judge_num){
try{
db_conn.ConnectDB();
String sql="update 判断题 set 题目='"+judge_pro+"',标准答案='"+judge_answ+"' where 题号="+judge_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_judge(int judge_num){
try{
db_conn.ConnectDB();
String sql="delete 判断题 where 题号="+judge_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_judge tb = new select_judge();
	//ArrayList list = tb.getTestList1();
	//  for(int i=0;i<list.size();i++)
	 // {
		//select_judge bea= (select_judge)list.get(i);
		// System.out.println("题号:" + bea.getTest_number());
	   //  System.out.println(bea.getTest_Title()); 
	    // System.out.println("标准答案:" + bea.getTest_answer());       
     //}
	//tb.modify_judge("a", "a", 1);
	//tb.delete_judge(1);
//}

}