defaultexamrecorddaoimpl.java

基于struts框架编写的在线考试系统

package examonline.service.impl;

import examonline.beans.*;
import examonline.service.*;
import java.sql.*;


public class DefaultExamRecordDAOImpl implements ExamRecordDAO
{
  DBManager dm = ManagerFactory.getDBManager();
  public DefaultExamRecordDAOImpl()
  {
  }

  /**
   * saveExamRecord
   *
   * @param record ExamRecord
   * @todo Implement this examonline.models.ExamRecordManager method
   */
  public int saveExamRecord(ExamRecord record)
  {
    Connection conn = dm.openConnection();
    StringBuffer sql = new StringBuffer();
    sql.append("insert into userexam values('");
    sql.append(record.getStudentId() + "',");
    sql.append(record.getScore() + ",");
    sql.append(record.getTotalNumber() + ",'");
    sql.append(record.getExamTime() + "',");
    sql.append(record.getRightNumber()+")");
  System.out.println(sql.toString());
    try
    {
      Statement stat = conn.createStatement();
      return stat.executeUpdate(sql.toString());
    }
    catch (SQLException ex)
    {
      ex.printStackTrace();
    }
    finally
    {
      if (conn != null)
        try
        {
          conn.close();
        }
        catch (SQLException ex1)
        {
          ex1.printStackTrace();
        }
    }

    return 0;

  }
}