int i = dbo.executeUpdate(\into jcdg(xid,dg_jcdm,dg_dgsl,Dg_ydjc,Dg_wdjc,Dg_bz)\ \
values('\ if(i == 1) return Constant.SUCCESS; else return Constant.SYSTEM_ERROR; } }
catch(Exception e) { e.printStackTrace(); return Constant.SYSTEM_ERROR; }finally{ dbo.close(); } } public List getDg(String xid){ String sql=\ DBConn dbo=new DBConn(); dbo.open();
List list = new ArrayList(); try {
rs = dbo.executeQuery(sql); if(rs.next()){
list.add(rs.getString(1));//0 list.add(rs.getString(2));//1 list.add(rs.getString(3));//2 list.add(rs.getString(4));//3 list.add(rs.getString(5));//3 list.add(rs.getString(6));//3 }
return list;
} catch (SQLException ex) { ex.printStackTrace(); return list; } finally { dbo.close(); } } public List getDgJcDm(){ String sql=\ DBConn dbo=new DBConn();
第 25 页
dbo.open();
List list = new ArrayList(); try {
rs = dbo.executeQuery(sql); while(rs.next()){
list.add(rs.getString(1)); }
return list;
} catch (SQLException ex) { ex.printStackTrace(); return list; } finally { dbo.close(); } }
3.4.8 领取、查询
教师和学生可以领取，可以进行教材编号查询入库，出库，订购的信息：
主要代码如下：
public int getKuCun(String sql){ DBConn dbo = new DBConn(); dbo.open(); try{ rs=dbo.executeQuery(sql); if(rs.next()) return rs.getInt(1); else return 0; }catch(Exception e){
第 26 页
e.printStackTrace(); return 0; }finally{ dbo.close(); } } public int addJsl(String jlq_jsh,String jlq_jcdm,String jlq_lqbs,String jLq_lqsj,String Jlq_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; }catch(Exception e){ e.printStackTrace(); return Constant.SYSTEM_ERROR; }finally{ dbo.close(); } } //修改 public int upJsl(String id,String jlq_jsh,String jlq_jcdm,String jlq_lqbs,String jLq_lqsj,String Jlq_bz){ String sql = \jslq set jlq_jsh='\ \ 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{
第 27 页
dbo.close(); } }
//删除
public int delJsl(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(); } }
3.4.9 用户管理
可以实现增加用户和修改密码
主要代码如下：
public class UserLoginBean { Connection conn = null; Statement st = null;
第 28 页
ResultSet rs = null; ArrayList al = new ArrayList(); public int login(String name,String pwd){ int temp = 0; DBConn dbo=new DBConn(); dbo.open(); try { rs = dbo.executeQuery(\ if(rs.next()) { String id = rs.getString(\ String tname = rs.getString(\ String tpwd = rs.getString(\ if(pwd.equals(tpwd)){ temp = 1; al.add(id); al.add(tname); al.add(tpwd); }else{ temp = 2; } }else{ temp = 3; } } catch (SQLException e) { e.printStackTrace(); } finally{ dbo.close(); } return temp; } public List getMygl(){ String sql=\hickey.name,mygl.* from hickey,mygl where mygl.ypmc=hickey.id order by hickey.id desc\ List list=new ArrayList(); Connection conn = null; Statement st = null; ResultSet rs = null; DBConn dbo=new DBConn(); dbo.open(); try { rs=dbo.executeQuery(sql);
第 29 页