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

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

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


public boolean modify_program(String program_pro,String program_answ ,int program_num){
try{
db_conn.ConnectDB();
String sql="update 编程题 set 题目='"+program_pro+"',标准答案='"+program_answ+"' where 题号="+program_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_program(int program_num){
try{
db_conn.ConnectDB();
String sql="delete 编程题 where 题号="+program_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_program tb = new select_program();
	//ArrayList list = tb.getTestList1();
	 // for(int i=0;i<list.size();i++)
	  //{
		//select_program bea= (select_program)list.get(i);
		// System.out.println("题号:" + bea.getTest_number());
	   //  System.out.println(bea.getTest_Title()); 
	    // System.out.println("标准答案:" + bea.getTest_answer());          
    // }
	//tb.modify_program("a", "a", 1);
	//tb.delete_program(1);
//}

}