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 org.mmxbb.exam.bean.ExaminationPaper;
import org.mmxbb.exam.business.program.RandomDistributeExamPaperForm;
import org.mmxbb.exam.business.program.SearchActionForm;
import org.mmxbb.exam.util.DBConn;
import org.mmxbb.exam.util.GetQuestionCount;
public class ExaminationPaperDAO {
private final static String GETALL_EXAMINATIONPAPER =
"select * from EX_EXAMINATIONPAPER";
private final static String GET_SHARCH_RESULT =
"select e.e_id as e_id,e.e_name as e_name,e.e_type as e_type,b.b_value as e_typename,date_format(e.e_begin,'%Y-%m-%d') as e_begin,date_format(e.e_end,'%Y-%m-%d') as e_end,e.e_total as e_total,e.e_passvalue as e_passvalue,e.e_timer as e_timer,t.t_state as t_state from ex_examinationpaper e,ex_baseinfo b,ex_testpaper t where b.b_id=e.e_type and e.e_id=t.e_id and t.examinee_id=? and (now())<e.e_end and (now())>e.e_begin and t_state='096' ORDER BY E_ID DESC";
private final static String UPDATE_PAPER =
"UPDATE EX_EXAMINATIONPAPER SET E_NAME=?,E_TYPE=?,E_TIMER=?,E_IDLIST=?,E_BEGIN=date_format(?,'%Y-%m-%d'),E_END=date_format(?,'%Y-%m-%d'),E_EXAMINEELIST=?,E_PASSVALUE=?,E_TOTAL=?,E_STATE=? WHERE E_ID=?";
private final static String UPDATE_PAPER2 =
"UPDATE EX_EXAMINATIONPAPER SET E_NAME=?,E_TYPE=?,E_TIMER=?,E_IDLIST=?,E_BEGIN=(now()),E_END=(DATE_ADD(now(),INTERVAL 10 DAY )),E_EXAMINEELIST=?,E_PASSVALUE=?,E_TOTAL=?,E_STATE=? WHERE E_ID=?";
private final static String UPDATE_PAPER_BASEINFO =
"UPDATE EX_EXAMINATIONPAPER SET E_NAME=?,E_TYPE=?,E_TIMER=?,E_BEGIN=date_format(?,'%Y-%m-%d'),E_END=date_format(?,'%Y-%m-%d'),,E_PASSVALUE=?,E_TOTAL=?,WHERE E_ID=?";
private final static String ADDPAPER =
"INSERT INTO EX_EXAMINATIONPAPER (E_ID,E_IDLIST,E_BEGIN,E_END) VALUES ('','@@0@@0@@0@@0',(now()),(DATE_ADD(now(),INTERVAL 1 DAY )))";
private final static String REMOVEEXAMINATIONPAPERBYKEY =
"delete from EX_EXAMINATIONPAPER WHERE E_ID=?";
private final static String UPDATE_E_STATE =
"update ex_examinationpaper set e_state=? where e_id=?";
private final static String GETBYKEY =
"SELECT exam.e_id as e_id,exam.e_name as e_name,exam.e_type as e_type,exam.e_timer as e_timer,exam.e_idlist as e_idlist,date_format(exam.e_begin,'%Y-%m-%d') as e_begin,date_format(exam.e_end,'%Y-%m-%d') as e_end,exam.e_examineeList as e_examineeList,exam.e_passvalue as e_passvalue,exam.e_total as e_total,b2.b_value as e_state FROM EX_EXAMINATIONPAPER exam,EX_BASEINFO b2 WHERE exam.e_state=b2.b_id and exam.e_id=?";
private final static String FINDBYE_STATE =
"SELECT E_ID,E_NAME,E_TYPE,E_TIMER,E_IDLIST,date_format(E_BEGIN,'%Y-%m-%d') as E_BEGIN,date_format(E_END,'%Y-%m-%d') as E_END,E_EXAMINEELIST,E_PASSVALUE,E_TOTAL,E_STATE FROM EX_EXAMINATIONPAPER where e_state IS NULL";
private final static String GET_BY_KEY_WHEN_ESTATE_NULL =
"select e_id,e_name,e_type,e_timer,date_format(e_begin,'%Y-%m-%d') as e_begin,date_format(e_end,'%Y-%m-%d') as e_end,e_idlist,e_examineelist,e_passvalue,e_total,e_state from ex_examinationpaper where e_id=?";
private final static String GET_IDLIST =
"SELECT E_IDLIST FROM EX_EXAMINATIONPAPER WHERE E_ID = ?";
private final static String CLEAR_IDLIST =
"UPDATE EX_EXAMINATIONPAPER SET E_IDLIST = ? WHERE E_ID = ?";
private final static String REMOVEEXAMINEE_LIST =
"UPDATE EX_EXAMINATIONPAPER SET E_EXAMINEELIST='' WHERE E_ID=?";
private final static String UPDATE_E_STATE_UNVALIDATE_EXAMPAPER =
"UPDATE EX_EXAMINATIONPAPER SET e_state='040' where e_end<(now())";
private Connection conn;
private DBConn dbconn;
private int length = 3;
private int rowCount;
private int pageCount;
private String pagestr;
private String conditionStr = "";
//Connect to db!!
public ExaminationPaperDAO() {
dbconn = new DBConn();
conn = dbconn.getConnection();
}
public void setLength(int length) {
this.length = length;
}
public int getLength() {
return length;
}
public String getConditionStr() {
return (this.conditionStr);
}
public void setConditionStr(String conditionStr) {
this.conditionStr = conditionStr;
}
//Add ExaminationPaper!
public void addExamintionPaper(ExaminationPaper examinationPaper) {
PreparedStatement pstmt = null;
try {
pstmt = conn.prepareStatement(ADDPAPER);
pstmt.executeUpdate();
} catch (SQLException ex) {
ex.printStackTrace();
} finally {
try {
pstmt.close();
pstmt = null;
conn.close();
conn = null;
} catch (SQLException ex1) {
ex1.printStackTrace();
}
}
}
public Collection getCanGrade(SearchActionForm searchForm, int ipage) throws
SQLException {
ArrayList src = (ArrayList)this.getSearch(searchForm, ipage);
Collection res = new ArrayList();
ExaminationPaper ePaper = new ExaminationPaper();
for (int i = 0; i < src.size(); i++) {
ePaper = (ExaminationPaper) src.get(i);
if (ePaper.getE_state().equals("进行中") || ePaper.getE_state().equals("已结束")) {
res.add(src.get(i));
}
}
this.rowCount = res.size();
int pagesize = getLength();
if (getLength() < 1) {
pagesize = rowCount;
this.pageCount = 1;
} else {
this.pageCount = rowCount / getLength() +
( (rowCount % getLength()) > 0 ? 1 : 0);
}
return res;
}
public String getPagestr(int ipage) {
String strPage = "";
if (getLength() > 0) {
strPage += "共";
strPage += String.valueOf(rowCount);
strPage += "条记录,共";
strPage += String.valueOf(pageCount);
strPage += "页,当前是第";
strPage += String.valueOf(ipage);
strPage += "页, ";
int istart, iend;
istart = ipage - 5;
if (istart < 0) {
istart = 0;
}
iend = istart + 10;
if (iend > pageCount) {
iend = pageCount;
}
istart = iend - 10;
if (istart < 0) {
istart = 0;
}
for (int i = istart; i < iend; i++) {
strPage +=
"<a href='searchAction.do?page=";
strPage += String.valueOf(i + 1);
strPage += conditionStr;
strPage += "'>";
strPage += String.valueOf(i + 1);
strPage += "</a>";
strPage += " ";
}
}
this.pagestr = strPage;
return strPage;
}
public String getPagestr_(int ipage) {
String strPage = "";
if (getLength() > 0) {
strPage += "共";
strPage += String.valueOf(rowCount);
strPage += "条记录,共";
strPage += String.valueOf(pageCount);
strPage += "页,当前是第";
strPage += String.valueOf(ipage);
strPage += "页, ";
int istart, iend;
istart = ipage - 5;
if (istart < 0) {
istart = 0;
}
iend = istart + 10;
if (iend > pageCount) {
iend = pageCount;
}
istart = iend - 10;
if (istart < 0) {
istart = 0;
}
for (int i = istart; i < iend; i++) {
strPage +=
"<a href='examinationPaperListAction.do?page=";
strPage += String.valueOf(i + 1);
strPage += "'>";
strPage += String.valueOf(i + 1);
strPage += "</a>";
strPage += " ";
}
}
this.pagestr = strPage;
return strPage;
}
//Remove Examinationpaper!!
public void removeExaminationPaper(ExaminationPaper examinationPaper) {
removeExaminationPaper(examinationPaper.getE_id());
}
//Remove by key!!
public void removeExaminationPaper(long e_id) {
PreparedStatement pstmt = null;
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
java-exam-SSH.bak.zip_java exam_ssh系统_数据库 java_框架_考试系统Java (314个子文件)
ExaminationPaperDAO.class 29KB
TestPaperDAO.class 21KB
ExamineeDAO.class 21KB
QuestionDAO.class 12KB
AddExaminationPaperForm.class 9KB
GradeAction.class 7KB
TestPaperDetailDAO.class 7KB
ExamDAO.class 7KB
ExamineeChooserDAO.class 6KB
baseInfoDAO.class 6KB
RandomDistributeExamPaperForm.class 6KB
UserDatabase.class 6KB
ExamTestActionForm.class 6KB
ShowExamTestAction.class 6KB
GetQuestionCount.class 6KB
PreViewExamTestPaperForm.class 5KB
InquryExamAction.class 5KB
InquiryExamTestPaperAction.class 5KB
AddSelectorAction.class 5KB
AUD_QuestionAction.class 5KB
QuestionActionForm.class 5KB
ChooseExamineeActionForm.class 5KB
ExamineeTestDetailsDAO.class 5KB
ToListQuestionAction.class 5KB
TestPaper.class 5KB
ExamineeInquiryDAO.class 5KB
ExamineeActionForm.class 5KB
ChooseExamineeAction.class 5KB
Examinee.class 5KB
SaveTestPaperAction.class 5KB
DoRandomDistributeAction.class 5KB
ShowQuestionDetailsAction.class 4KB
QuestionInTest.class 4KB
SearchAction.class 4KB
ExamBeginAction.class 4KB
EditExamineeAction.class 4KB
ExaminationPaper.class 4KB
PreViewExamTestPaperAction.class 4KB
CheckLogonTag.class 4KB
EditExamineeAction.class 4KB
ListQuestionAction.class 3KB
InitRandomDistributeAction.class 3KB
UpLoad.class 3KB
BaseInfoActionForm.class 3KB
ControlAction.class 3KB
StatisticAction.class 3KB
ShowExamineeAction.class 3KB
AddQuestionToExaminationPaperAction.class 3KB
ExaminationPaperListAction.class 3KB
ExamineeTestDetailsAction.class 3KB
Selector.class 3KB
StopExamAction.class 3KB
Filter.class 3KB
LogonForm.class 3KB
SearchActionForm.class 3KB
ExamineeInquiryAction.class 3KB
RemoveQuestionAction.class 3KB
EditAdminPwdActionForm.class 3KB
Question.class 3KB
SaveChooseExamineeAction.class 3KB
SaveAddExamineeAction.class 3KB
Transformer.class 3KB
GradeActionForm.class 2KB
DistributeActionForm.class 2KB
EditPwdAction.class 2KB
CheckUserFilter.class 2KB
SaveEditPwdAction.class 2KB
EditAdminPwdAction.class 2KB
InitialQuestionAction.class 2KB
AddExamineeAction.class 2KB
BaseInfoAction.class 2KB
ExaminationPaperDetailDAO.class 2KB
ManiAction.class 2KB
SetCharacterEncodingFilter.class 2KB
AbsenceAction.class 2KB
CheckOverlap.class 2KB
LogonAction.class 2KB
SaveEditExamineeAction.class 2KB
CheckAdminFilter.class 2KB
ReAttandExamAction.class 2KB
ClearIdListAction.class 2KB
AddExaminationPaperAction.class 2KB
DeleteExamineeAction.class 2KB
PortalLogonAction.class 2KB
ExaminationPaperDetail.class 2KB
ExamineeTestDetailsActionForm.class 2KB
SaveEditExamineeAction.class 2KB
MakeSureStopExamTestPaperAction.class 1KB
StrTokenConverter.class 1KB
MakeSureRemoveQuestionAction.class 1KB
DBConn.class 1KB
AdminLogonAction.class 1KB
ExamineeInquiryActionForm.class 1KB
LogoffAction.class 1KB
ErrorReturnAction.class 1KB
DeleteExamineeActionForm.class 1KB
FileUpload.class 1KB
DealWithFileName.class 1KB
MakeSureStopExamTestPaperActionForm.class 1KB
TestPaperDetail.class 1KB
共 314 条
- 1
- 2
- 3
- 4
资源评论
JonSco
- 粉丝: 72
- 资源: 1万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- Python 程序语言设计模式思路-创建型模式:原型模式:通过复制现有对象来创建新对象,面向对象编程
- 卸载软件geek卸载软件geek
- Python 程序语言设计模式思路-创建型模式:单例模式,确保一个类的唯一实例(装饰器)面向对象编程、继承
- skywalking-plugins.jar skywalking-alarm.jar
- 独栋别墅图纸D020-两层-10.00&11.00米- 施工图.dwg
- Python 程序语言设计模式思路-创建型模式:工厂模式,创建对象的统一接口,封装对象的创建逻辑
- python自学教程-05-json数据格式的介绍.ev4.rar
- python自学教程-04-自定义JavaScript.ev4.rar
- 《淘宝后台系统...》
- skywalking-plugins.jar
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功