package com.sevenEleven.javaBean.exam;
import java.util.ArrayList;
import java.util.List;
import com.sevenEleven.Beans.CchooseTestBean;
import com.sevenEleven.Beans.CtextTestBean;
import com.sevenEleven.javaBean.CDBConnection;
/**
* @author Tim
* 关于老师对试题表的操作Bean
*/
public class Cexam extends CDBConnection {
@SuppressWarnings("unchecked")
/**
* @author Tim Something about exam find the teacher who came into this
* system and his's course and make view in the page of
* teacher\exam_addTest.jsp
*/
private String id;
private String countOfChoose1;
private String countOfChoose2;
private String countOfText;
public List findLesson1(String teacherNumber) { // 由老师找必修课
if (!checkParameter(teacherNumber)) {
teacherNumber = "null";
}
try {
sql = "select distinct a.T_SKILL \"course\" from teacher a, lesson1 b where a.T_SKILL = b.L1_Name and a.T_number ="
+ " '" + teacherNumber + "' ";
if (con == null) {
DBConn(); // 连接
}
rs = executeQuery(sql);
List list = new ArrayList();
for (int i = 0; rs.next(); i++) {
// rs.getCursorName().length();
list.add(i, rs.getString("course"));
}
this.dropConnection();
return list;
} catch (Exception e) {
e.printStackTrace();
return null;
}
}
/*
* @author Tim Something about exam find the teacher who came into this
* system and his's course and make view in the page of
* teacher\exam_addTest.jsp
*/
@SuppressWarnings("unchecked")
public List findLesson2(String teacherNumber) { // 由老师找选修课
if (!checkParameter(teacherNumber)) {
teacherNumber = "null";
}
try {
// Clesson1Bean lesson2 = null;
sql = "select distinct a.T_SKILL \"course\" from teacher a, lesson2 b where a.T_SKILL = b.L2_Name and a.T_number ="
+ " '" + teacherNumber + "' ";
if (con == null) {
DBConn(); // 连接
}
rs = executeQuery(sql);
List list = new ArrayList();
for (int i = 0; rs.next(); i++) {
// rs.getCursorName().length();
list.add(i, rs.getString("course"));
}
this.dropConnection();
return list;
} catch (Exception e) {
e.printStackTrace();
return null;
}
}
/*
* @author tim insert infomation of one test to the Table "Choose1"
*
*/
public boolean insertIntoChoose1Table(CchooseTestBean test) {
try {
sql = "insert into choose1 values ("// + test.getCh_id() + ", "
+ test.getL_id() + ", " + " '" + test.getCh_question()
+ "' , '" + test.getKeya() + "' , '" + test.getKeyb()
+ "' , '" + test.getKeyc() + "' , '" + test.getKeyd()
+ "' , '" + test.getAnswer() + "' , " + test.getType()
+ ") ";
if (con == null) {
DBConn(); // 连接
}
if (this.executeUpdate(sql) != 0) {
executeUpdate("commit");
return true;
}
} catch (Exception e) {
e.printStackTrace();
return false;
}
return false;
}
/*
* @author tim update infomation of one test to the Table "Choose1"
*
*/
public boolean updateChoose1Table(CchooseTestBean choose) {
try {
sql = "update choose1 set CH_QUESTION= '" + choose.getCh_question()
+ "' ," + "KEYA= '" + choose.getKeya() + "' ," + "KEYB= '"
+ choose.getKeyb() + "' ," + "KEYC= '" + choose.getKeyc()
+ "' ," + "KEYD= '" + choose.getKeyd() + "' ,"
+ "CH_ANSWER= '" + choose.getAnswer() + "' "
+ " WHERE CH_ID=" + choose.getCh_id();
if (con == null) {
DBConn(); // 连接
}
if (this.executeUpdate(sql) != 0) {
executeUpdate("commit");
return true;
}
} catch (Exception e) {
e.printStackTrace();
return false;
}
return false;
}
/*
* @author tim insert infomation of one test to the Table "Choose2" by the
* attribute of courseType
*/
public boolean insertIntoChoose2Table(CchooseTestBean test) {
try {
sql = "insert into choose2 values (" //+ test.getCh_id() + ", "
+ test.getL_id() + ", " + " '" + test.getCh_question()
+ "' , '" + test.getKeya() + "' , '" + test.getKeyb()
+ "' , '" + test.getKeyc() + "' , '" + test.getKeyd()
+ "' , '" + test.getAnswer() + "' , " + test.getType()
+ ") ";
if (con == null) {
DBConn(); // 连接
}
if (this.executeUpdate(sql) != 0) {
executeUpdate("commit");
return true;
}
return true;
} catch (Exception e) {
e.printStackTrace();
return false;
}
}
/*
* @author tim update infomation of one test to the Table "Choose2" by the
* attribute of courseType
*/
public boolean updateChoose2Table(CchooseTestBean choose) {
try {
sql = "update choose2 set CH_QUESTION= '" + choose.getCh_question()
+ "' ," + "KEYA= '" + choose.getKeya() + "' ," + "KEYB= '"
+ choose.getKeyb() + "' ," + "KEYC= '" + choose.getKeyc()
+ "' ," + "KEYD= '" + choose.getKeyd() + "' ,"
+ "CH_ANSWER= '" + choose.getAnswer() + "' "
+ " WHERE CH_ID=" + choose.getCh_id();
if (con == null) {
DBConn(); // 连接
}
if (this.executeUpdate(sql) != 0) {
executeUpdate("commit");
return true;
}
return true;
} catch (Exception e) {
e.printStackTrace();
return false;
}
}
/**
* @author tim insert infomation of one test to the Table "text1" by the
* attribute of courseType
*/
public boolean insertIntoText1Table(CtextTestBean text) {
try {
sql = "insert into text1 values ( " //+ text.getText_id() + ", "
+ text.getL_id() + ", '" + text.getText_question()
+ "' , '" + text.getText_answer() + "') ";
if (con == null) {
DBConn(); // 连接
}
if (this.executeUpdate(sql) != 0) {
executeUpdate("commit");
return true;
}
} catch (Exception e) {
e.printStackTrace();
return false;
}
return false;
}
/*
* @author tim update infomation of one test to the Table "text1" by the
* attribute of courseType
*/
public boolean updateText1Table(CtextTestBean text) {
try {
sql = "update text1 set TEXT_QUESTION= '" + text.getText_question()
+ "' ," + "TEXT_ANSWER= '" + text.getText_answer() + "' "
+ " WHERE TEXT_ID=" + text.getText_id();
if (con == null) {
DBConn(); // 连接
}
if (this.executeUpdate(sql) != 0) {
executeUpdate("commit");
return true;
}
} catch (Exception e) {
e.printStackTrace();
return false;
}
return false;
}
/*
* @author tim insert infomation of one test to the Table "text2" by the
* attribute of courseType
*/
public boolean insertIntoText2Table(CtextTestBean text) {
try {
sql = "insert into text2 values ( "// + text.getText_id() + ", "
+ text.getL_id() + ", '" + text.getText_question()
+ "' , '" + text.getText_answer() + "') ";
if (con == null) {
DBConn(); // 连接
}
if (this.executeUpdate(sql) != 0) {
executeUpdate("commit");
return true;
}
return true;
} catch (Exception e) {
e.printStackTrace();
return false;
}
}
/*
* @author tim update infomation of one test to the Table "text2" by the
* attribute of courseType
*/
public boolean updateText2Table(CtextTestBean text) {
try {
sql = "update text2 set TEXT_QUESTION= '" + text.getText_question()
+ "' ," + "TEXT_ANSWER= '" + text.getText_answer() + "' "
+ " WHERE TEXT_ID=" + text.getText_id();
if (con == null) {
DBConn(); // 连接
}
if (this.executeUpdate(sql) != 0) {
executeUpdate("commit");
return true;
}
return true;
} catch (Exception e) {
e.printStackTrace();
return false;
}
}
/*
* @author tim delete a item of this table
*
*/
public boolean deleteItemOfChoose1Table(String id) {
try {
sql = "delete Choose1 where CH_ID =" + id;
if (con == null) {
DBConn(); // 连接
}
if (this.executeUpdate(
Java学校教务管理系统.zip
（417个子文件） 
Cexam.class 14KB WeekSchemeMaker.class 11KB CUsMethod.class 9KB CmakeTeacherAndCourseTogether.class 8KB CbestPageBean.class 7KB AbDoing.class 7KB CTakeExam.class 7KB CcheckUser.class 6KB Page.class 6KB Lesson2WeekSchemeMaker.class 5KB SchemeTurnServlet.class 5KB OneSchemeMaker.class 5KB OneLesson2ListSchemeMaker.class 4KB Cexam_giveCompulsoryScore.class 4KB Cexam_giveElectiveScore.class 4KB Cexam_uploadTest2Servlet.class 4KB Cexam_uploadTestServlet.class 4KB CoperationOfExam.class 3KB Cexam_uploadOrDeleteTestServlet.class 3KB CDBConnection.class 3KB AddNorScore.class 3KB CcheckUserServlet.class 3KB CseparateTime.class 3KB CDBOracle.class 3KB TiJiaoL2CourseTable.class 3KB CautoMakeScheme_getLesson1AndTeacherInfo.class 3KB CgetCurrentTimeFromTimeClassBegin.class 3KB CflushExam_updateOrDeleteTestServlet.class 3KB Cexam_updateOrDeleteTestServlet.class 3KB ShowAllListServlet.class 3KB ChangeLesson1listServlet.class 3KB CautoMakeScheme_printCheckedClassAndPhase.class 3KB DelStuFromClass.class 3KB CConnectMSSQL.class 3KB DaySchemeMaker.class 3KB ChangeTurnServlet.class 3KB DelTurnServlet.class 3KB UpdateTeacherInfo.class 3KB StuResult.class 3KB CautoMakeScheme_selectTeacherServlet.class 3KB RegisterTurnServlet.class 2KB Cexam_uploadOrDeleteCompulsoryChooseServlet.class 2KB ChangeStudentServlet.class 2KB Cstudent_updateInfoServlet.class 2KB CdataFormat.class 2KB Cexam_uploadOrDeleteElectiveChooseServlet.class 2KB ChangeLesson2Servlet.class 2KB ModshowServlet.class 2KB DelshowServlet.class 2KB ShowServlet.class 2KB Update.class 2KB Cexam_getStudentCourseTocompulsoryPage.class 2KB Cexam_getStudentCourseToElectivePage.class 2KB CMethod.class 2KB ChangeTeacherServlet.class 2KB ChangeLesson1Servlet.class 2KB ChangeClassServlet.class 2KB SchemeUpdateServlet.class 2KB Cautomakescheme.class 2KB CchooseTestBean.class 2KB Cexam_uploadOrDeleteCompulsoryTextServlet.class 2KB CMethod.class 2KB Cexam_uploadOrDeleteElectiveTextServlet.class 2KB Cexam_newPageUpdateChoose2.class 2KB Cexam_newPageUpdateChoose1.class 2KB AbUsing.class 2KB SQL.class 2KB CourseTable.class 2KB LoginFilter.class 2KB CautoMakeScheme_deleteClassAndTeacherForClasses.class 2KB TeaUpdateServlet.class 2KB StuUpdateServlet.class 2KB Cexam_getElectivePaperToElectiveTestPage.class 2KB Cexam_getCompulsoryPaperToCompulsoryTestPage.class 2KB ModifyServlet.class 2KB Cexam_addtestServlet.class 2KB UpdataServlet.class 2KB Cexam_addtest2Servlet.class 2KB AddServlet.class 2KB DeleteServlet.class 2KB Lesson2RegisterServlet.class 2KB DelStudentServlet.class 2KB StudRegisterServlet.class 2KB Result2.class 2KB TeaRegisterServlet.class 2KB Result.class 2KB Cstudent_showInfoServlet.class 2KB PersonalL2Info.class 2KB Cexam_newPageUpdateText.class 2KB ClassUpdateServlet.class 2KB Lesson1RegisterServlet.class 2KB CreateTime.class 2KB Lesson2UpdateServlet.class 2KB Lesson1UpdateServlet.class 2KB ClassRegisterServlet.class 2KB Cexam_testExamServlet.class 2KB CautoMakeScheme_getAllClasses.class 2KB CstudentBean.class 2KB DelLesson2Servlet.class 2KB DelLesson1Servlet.class 2KB共 417 条
- 1
- 2
- 3
- 4
- 5
资源评论
2401_83200053
- 粉丝: 0
最新资源
- 基于分布式多智能体的平均一致性减载算法：全局信息决策与故障应对协调策略
- 基于毫米波雷达目标检测数据计算交通常见指标
- 基于DBSCAN密度聚类的风电与电负荷场景生成及削减优化策略的MATLAB实现 - 密度聚类
- 基于DBSCAN密度聚类的风电-负荷场景生成与削减模型及其MATLAB实现
- 基于Comsol技术铌酸锂BIC倍频研究与应用。
- 水力压裂与断裂力学研究：从THM程序到Python实现的全面探索
- yolov10 目标检测部署版本，便于移植不同平台（onnx、tensorRT、rknn、Horizon），全网部署最简单、运行速度最快的部署方式（全网首发）
- 基于粒子群算法的冷热电三联供系统优化调度：微型燃气轮机能量管理成本分析与比较
- 电力系统优化：基于关键场景辨识的两阶段微网鲁棒调度策略应对光伏不确定性 · 微电网调度
- 基于Matlab和Yalmip编程的电动汽车充电站优化配置及路电网协同研究——以31节点系统为例
- 华为云OBS（对象存储）错误码查询工具
- 三相PWM整流器的双闭环控制与C语言实现：PI控制及SVPWM模块详解
- 电-气综合能源系统短期可靠性评估技术及其时序蒙特卡罗模拟应用
- Oracle数据库日常维护手册doc
- 基于一致性算法的分布式能源去中心化交易模型及其隐私保护与激励相容策略 - 隐私保护
- yolov10 目标检测部署版本，便于移植不同平台（onnx、tensorRT、rknn、Horizon），全网部署最简单、运行速度最快的部署方式（全网首发）
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
