sql.printStackTrace(); }
return flag; // 将标识量返回 }
// 执行删除数据表中的数据
public boolean DeleteObject(String deleteSql) { infoStr = \删除\
return AdapterObject(deleteSql); }
// 验证数据表中是否存在数据
private boolean validateID(String id, String tname, String idvalue) { String sqlStr = null;
sqlStr = \定义SQL语句
try {
con = CommonaJdbc.conection; // 获取数据库连接
pstmt = con.prepareStatement(sqlStr); // 获取PreparedStatement实例 java.sql.ResultSet rs = null; // 获取ResultSet实例 rs = pstmt.executeQuery(); // 执行SQL语句 if (rs.next()) {
if (rs.getInt(1) > 0) // 如果数据表中有值 return true; // 返回true值 }
} catch (java.sql.SQLException sql) { // 如果产生异常 sql.printStackTrace(); // 输出异常 return false; // 返回false值 }
return false; // 返回false值 }
public boolean InsertOrUpdateObject(Obj_gradeinfo objgradeinfo) { String sqlStatement = null;
if (validateID(\ sqlStatement = \tb_gradeinfo set gradeID = '\+ objgradeinfo.getGradeID() + \
+ \ infoStr = \更新年级\ } else {
sqlStatement = \tb_gradeinfo(gradeID,gradeName) values ('\+ objgradeinfo.getGradeID() + \
infoStr = \添加年级\ }
17
System.out.println(sqlStatement); return AdapterObject(sqlStatement); }
public boolean InsertOrUpdateObject(Obj_classinfo objclassinfo) { String sqlStatement = null;
if (validateID(\
sqlStatement = \tb_classinfo set className = '\+ objclassinfo.getClassName() + \
+ \
infoStr = \更新班级\ } else {
sqlStatement = \tb_classinfo(classID,gradeID,className) values ('\+ objclassinfo.getClassID() + \
+ objclassinfo.getClassName() + \ infoStr = \添加班级\ }
System.out.println(sqlStatement); return AdapterObject(sqlStatement); }
public boolean InsertOrUpdateObject(Obj_subject objsubject) { String sqlStatement = null;
if (validateID(\
sqlStatement = \tb_subject set code = '\+ objsubject.getCode() + \
+ objsubject.getCode().trim() + \ infoStr = \更新考试科目\ } else {
sqlStatement = \tb_subject(code,subject) values ('\+ objsubject.getCode() + \
infoStr = \添加考试科目\ }
return AdapterObject(sqlStatement); }
public boolean InsertOrUpdateObject(Obj_examkinds objexamkinds) {
18
String sqlStatement = null;
if (validateID(\
sqlStatement = \tb_examkinds set KindID = '\+ objexamkinds.getKindID() + \
+ \
infoStr = \更新考试类别\ } else {
sqlStatement = \tb_examkinds(KindID,KindName) values ('\+ objexamkinds.getKindID() + \
infoStr = \添加考试类别\ }
return AdapterObject(sqlStatement); }
public boolean InsertOrUpdateObject(Obj_user objuser) { String sqlStatement = null;
if (validateID(\
sqlStatement = \tb_user set userid = '\+ objuser.getUserid() + \
+ \ infoStr = \更新用户\ } else {
sqlStatement = \tb_user(userid,username,pass) values ('\+ objuser.getUserid() + \
+ \
infoStr = \添加用户\ }
return AdapterObject(sqlStatement); }
// ///////////////////////////////////////////// // 产生更新存盘学生信息语句
public boolean InsertOrUpdateObject(Obj_student objstudent) { String sqlStatement = null;
if (validateID(\
sqlStatement = \\
+ objstudent.getStuname() + \= '\+ objstudent.getSex() + \
19
+ \= '\+ objstudent.getPhone() + \where stuid = '\+ objstudent.getStuid().trim() + \
infoStr = \更新学生信息\ } else {
sqlStatement = \tb_studentinfo(stuid,classid,stuname,sex,age,addr,phone) values ('\
+ objstudent.getClassID() + \objstudent.getSex() + \
+ objstudent.getAddress() + \ infoStr = \添加学生信息\ }
return AdapterObject(sqlStatement); }
// 产生更新存盘教师信息语句
public boolean InsertOrUpdateObject(Obj_teacher objteacher) { String sqlStatement = null;
if (validateID(\
sqlStatement = \tb_teacher set teaid = '\+ objteacher.getTeaid() + \
+ objteacher.getTeaname() + \= '\+ objteacher.getSex() + \
+ objteacher.getKnowlevel() + \where teaid = '\+ objteacher.getTeaid().trim() + \
infoStr = \更新教师信息\ } else {
sqlStatement = \tb_teacher(teaid,classID,teaname,sex,knowledge,knowlevel) values ('\+ objteacher.getTeaid() + \
+ objteacher.getClassID() + \objteacher.getSex() + \
+ objteacher.getKnowlevel() + \
infoStr = \添加教师信息\ }
return AdapterObject(sqlStatement); }
// 验证数据表中是否存在数据
private boolean validateobjgradeinfo(String stuid, String kindid, String code) { String sqlStr = null;
sqlStr = \
20
kindID = '\
System.out.println(sqlStr); try {
con = CommonaJdbc.conection;
pstmt = con.prepareStatement(sqlStr); java.sql.ResultSet rs = null; rs = pstmt.executeQuery(); if (rs.next()) {
if (rs.getInt(1) > 0) return true; }
} catch (java.sql.SQLException sql) { sql.printStackTrace();
new appstu.view.JF_view_error(\执行的SQL语句为:\\n\错误信息为：\
return false; }
return false; }
// 产生更新学生信息信息语句
public boolean InsertOrUpdate_Obj_gradeinfo_sub(Obj_gradeinfo_sub[] object) { try {
con = CommonaJdbc.conection; stmt = con.createStatement();
for (int i = 0; i < object.length; i++) { String sqlStr = null;
if (validateobjgradeinfo(object[i].getStuid(), object[i].getKindID(), object[i].getCode())) {
sqlStr = \+ \
+ object[i].getKindID() + \+ \
+ object[i].getExamdate() + \where stuid = '\+ object[i].getStuid() + \
+ \ } else { sqlStr = \ tb_gradeinfo_sub(stuid,stuname,kindID,code,grade,examdate) values ('\\
+ object[i].getSutname() + \
21