question.java

在线考试 jsp+javabean 主要对试题管理 实现分页显示统计分数 校对答案

package com;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class question {
	public question(){}
	
	public int addquestion(String title,String key1,String key2,String key3,String type,String score,String answer){
		
	
	    ResultSet rs = null;
	    Connection con = null;
	    Statement stmt = null;
	    String slevel="";
	    dbconnectionbean.ConnectionPoolBean mytest = new dbconnectionbean.
	        ConnectionPoolBean();

	    String sql = "insert into question values('"+title+"','"+key1+"','"+key2+"','"+key3+"','"+type+"','"+score+"','"+answer+"')";

	    System.out.println("sql:" + sql);

	    try {

	      mytest.setinit();
	      mytest.setName("gateway");
	      con = mytest.getSqlCon();

	      stmt = con.createStatement();

	      int i=stmt.executeUpdate(sql);
	      

	      if (i>0) {
	      
	      
	        return i;	
	       
	    	 
	      }
	      else
	        i = 0;
	
	    } catch (SQLException ex) {
	      System.out.print(ex.getMessage());
	    }

	    return 0;
	  }
		
	}