if(i == 1) return Constant.SUCCESS; else return Constant.SYSTEM_ERROR; }catch(Exception e){ e.printStackTrace(); return Constant.SYSTEM_ERROR; }finally{ dbo.close(); } } //修改 public int upBook(String Jc_jcdm,String Jc_jcmc,String Jc_lb,String jc_dj,String Jc_cbs,String Jc_zz,String Jc_kcsl,String Jc_bz)
{ String sql = \jcxx set Jc_jcmc='\+\ Jc_jcdm='\
DBConn dbo = new DBConn(); dbo.open(); try{ int i = dbo.executeUpdate(sql); if(i == 1) return Constant.SUCCESS; else return Constant.SYSTEM_ERROR; }catch(Exception e){ e.printStackTrace(); return Constant.SYSTEM_ERROR; }finally{ dbo.close(); } } //删除 public int delBook(String Jc_jcdm){ String sql=\ DBConn dbo=new DBConn(); dbo.open(); try{ int i = dbo.executeUpdate(sql); if(i == 1) return Constant.SUCCESS; else return Constant.SYSTEM_ERROR;
第 20 页
}catch(Exception e){ e.printStackTrace(); return Constant.SYSTEM_ERROR; }finally{ dbo.close(); } } public int getMessageCountJc() { //得到信息总数 DBConn dbo=new DBConn(); dbo.open(); try {
rs = dbo.executeQuery(\ rs.next();
count = rs.getInt(1); return count;
} catch (SQLException ex) { ex.printStackTrace(); return -1; } finally {
dbo.close(); } }
public List getMessageJc(int page) { //得到每页要显示的信息 DBConn dbo=new DBConn(); dbo.open();
List list = new ArrayList(); try {
rs = dbo.executeQuery(\ for (int i = 0; i < (page - 1) * EVERYPAGENUM; i++) { rs.next(); }
for (int t = 0; t < EVERYPAGENUM; t++) { if (rs.next()) { qq++;
List list2=new ArrayList(); list2.add(rs.getString(1));//0 list2.add(rs.getString(2));//1 list2.add(rs.getString(3));//2 list2.add(rs.getString(4));//3 list2.add(rs.getString(5));//3 list2.add(rs.getString(6));//3 list2.add(rs.getString(7));//3 list2.add(rs.getString(8));//3 list.add(list2);
第 21 页
} else {
break; //减少空循环的时间 } }
return list;
} catch (SQLException ex) { ex.printStackTrace(); return null; } finally { dbo.close(); } }
3.4.6教材选定
对应的教材和课程，年级等信息
主要代码如下：
public int addXdjh(String xd_kch,String xd_njzyh,String xd_jcdm,String xd_xq,String xd_bz ){ String sql = \ \\ DBConn dbo = new DBConn(); dbo.open(); try{ int i = dbo.executeUpdate(sql); if(i == 1) return Constant.SUCCESS; else return Constant.SYSTEM_ERROR;
第 22 页
}catch(Exception e){ e.printStackTrace(); return Constant.SYSTEM_ERROR; }finally{ dbo.close(); } } //修改 public int upXdjh(String id,String xd_kch,String xd_njzyh,String xd_jcdm,String xd_xq,String xd_bz){ String sql = \
xd_kch='\bz='\ id='\ DBConn dbo = new DBConn(); dbo.open(); try{ int i = dbo.executeUpdate(sql); if(i == 1) return Constant.SUCCESS; else return Constant.SYSTEM_ERROR; }catch(Exception e){ e.printStackTrace(); return Constant.SYSTEM_ERROR; }finally{ dbo.close(); } } //删除 public int delXdjh(String id){ String sql=\ DBConn dbo=new DBConn(); dbo.open(); try{ int i = dbo.executeUpdate(sql); if(i == 1) return Constant.SUCCESS; else return Constant.SYSTEM_ERROR; }catch(Exception e){ e.printStackTrace(); return Constant.SYSTEM_ERROR; }finally{ dbo.close();
第 23 页
}
}
3.4.7 教材订购
选定教材即可订购数量
主要代码如下：
public int dG(String xid,String dg_jcdm,String dg_dgsl,String Dg_ydjc,String Dg_wdjc,String Dg_bz) { String sql=\ DBConn dbo=new DBConn(); dbo.open(); try{ rs=dbo.executeQuery(sql); if(rs.next()) { int i = dbo.executeUpdate(\jcdg set dg_jcdm='\ \where xid='\ if(i == 1) return Constant.SUCCESS; else return Constant.SYSTEM_ERROR; } Else {
第 24 页