exam-master/src/org/mmxbb/exam/dao/TestPaperDetailDAO.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package org.mmxbb.exam.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Vector;

import org.mmxbb.exam.bean.TestPaperDetail;
import org.mmxbb.exam.util.DBConn;
import org.mmxbb.exam.util.Transformer;


public class TestPaperDetailDAO {
  DBConn dbConn = null;
  private Connection conn = null;
  public TestPaperDetailDAO() {
    try {
      dbConn = new DBConn();
      conn = dbConn.getConnection();
    } catch (Exception ex) {
      ex.printStackTrace();
    }
  }

public void updateTestPaperDetail(long t_id,long q_id,String t_answer,float t_value){
  PreparedStatement pstmt = null;
     try {
       String sql =
           "UPDATE ex_testpaperdetail set t_answer=?,t_value=? WHERE t_id=? and q_id=?";
       pstmt = conn.prepareStatement(sql);
       pstmt.setString(1,t_answer);
       pstmt.setFloat(2,t_value);
       pstmt.setLong(3,t_id);
       pstmt.setLong(4,q_id);

       pstmt.executeUpdate();

     } catch (SQLException ex) {
       ex.getStackTrace();
     }finally {
     	  try {
            conn.close();
          } catch (SQLException ex1) {
            ex1.printStackTrace();
          }
     
     }
     
  }
  public void close(){
    try {
        conn.close();
      } catch (SQLException ex1) {
        ex1.printStackTrace();
      }

  }