connectdatabase.java~127~

用java实现的固定资产管理系统相信对于初学者可以从中学到一点知识....!

             }
             return vt;
   }


    public void astaddinfo(String assetid,String asset_name,
            String cateid,String subcateid,String model,Float price,
            String date,String status,String useby,String remarks){
        try {
            st.executeUpdate("insert into Asset values('"+assetid+"','"+
                    asset_name+"','"+cateid+"','"+subcateid+"','"+model+"',"+
                    price+",'"+date+"','"+status+"','"+useby+"','"+remarks+"')");
        } catch (SQLException ex) {
        }
    }

    public void cateaddinfo(String cateid,String catename,
            String subcateid,String subcatename){
        try {
            rs=st.executeQuery("select * from category where subcatename='"+
                  subcatename+"'");
            if(!rs.next()){
                st.executeUpdate("insert into Category values('" + cateid +
                                 "','" +
                                 catename + "','" + subcateid + "','" +
                                 subcatename + "')");
            }
        } catch (SQLException ex) {
        }
    }


    public void empaddinfo(String empno,String empname,
        String position,String remarks){
    try {
        st.executeUpdate("insert into Employee values('"+empno+"','"+
                empname+"','"+position+"','"+remarks+"')");
    } catch (SQLException ex) {
    }
}


    public boolean astdelinfo(String id){
       try {
           rs=st.executeQuery("select * from Asset where assetid='"+id+
                            "' and status='在库'");
         while(!rs.next()){
              return true;
           }
           st.executeUpdate("delete from Asset where assetid='"+id+
                            "' and status='在库'");
       } catch (SQLException ex) {
       }
       return false;
   }

   public boolean catedelinfo(String cateid,String subcateid){
       try {
           rs=st.executeQuery("select * from Asset where cateid='"+cateid+
                   "' and subcateid='"+subcateid+"'");
           if(!rs.next())
           {
               st.executeUpdate("delete from Category where cateid='" + cateid +
                                "' and subcateid='" + subcateid + "'");
           }else{
               return true;
           }
       } catch (SQLException ex) {
           return true;
       }
       return false;
   }


   public boolean empdelinfo(String no){
       try {
           st.executeUpdate("delete from Employee where empno='"+no+"'");
       } catch (SQLException ex) {
           return true;
       }
       return false;
   }


   public void astrenew(String assetid,String asset_name,
               String cateid,String subcateid,String model,Float price,
               String date,String status,String useby,String remarks){
           try {
               st.executeUpdate("update Asset set asset_name='"+asset_name+
                                "',cateid='"+cateid+"',subcateid='"+subcateid+
                                "',model='"+model+"',price="+price+
                                ",purchase_date='"+date+"',status='"+status+
                                "',useby='"+useby+"',remarks='"+remarks+
                                "' where assetid='"+assetid+"'");
           } catch (SQLException ex) {
           }
    }


    public void emprenew(String empno,String empname,
        String position,String remarks){
               try {
                   st.executeUpdate("update Employee set ename='"+empname+
                                    "',eposition='"+position+"',remarks='"+remarks+
                                    "' where empno='"+empno+"'");
               } catch (SQLException ex) {
               }
        }

    public boolean user_check(String name,String pwf,String permission){
        try {
            rs = st.executeQuery("select * from Operator where name='" + name +
                                 "' and pwf='" + pwf + "' and permission='"+
                                 permission+"'");
            if(rs.next())
                return true;
        } catch (SQLException ex) {
        }
        return false;
    }

    public void operatoraddinfo(String operator,String pwf,String permission){
   try {
       st.executeUpdate("insert into Operator values('"+operator+"','"+
               pwf+"','"+permission+"')");
   } catch (SQLException ex) {
   }
}


    public void updateuserpwf(String name,String pwf,String newpwf){
        try {
            st.executeUpdate("update Operator set pwf='" + newpwf + "'where name='" +
                             name +"' and pwf='" + pwf+"'");
        } catch (SQLException ex) {
        }

    }

    public DefaultTableModel getOperatorinfo(){
     try {
         rs = st.executeQuery("select * from Operator");
         vt=new Vector();
         while (rs.next()) {
             tempvt=new Vector();
             for(int i=1;i<=rs.getMetaData().getColumnCount();i++)
                    tempvt.add(rs.getString(i));
             vt.add(tempvt);
         }
         vtColName=new Vector();
         for(int i=1;i<=rs.getMetaData().getColumnCount();i++){
             vtColName.add(rs.getMetaData().getColumnName(i));
         }
         dt=new DefaultTableModel(vt,vtColName);
     } catch (SQLException ex) {
     }
     return dt;
 }


    public void updatelend(String assetid,String ename,String usedate,
                           String lendoperator,String remarks){
        try {
            rs=st.executeQuery("select empno from employee where ename='"+ename+"'");
            while(rs.next()){
                st.executeUpdate("insert into lend (assetid,empno,usedate,isreturn,lendoperator,remarks) values ('"
                                 +assetid+"','"+rs.getString(1)+"','"+usedate
                                 +"','否','"+lendoperator+"','"+remarks+"')");
                st.executeUpdate("update Asset set status='领用中' where assetid='"+assetid+"'");
            }
        } catch (SQLException ex) {
        }

    }

    public Vector getreturninfo(String assetid){
        Vector vt=new Vector();
        try {
        rs = st.executeQuery(
                    "select empno from lend where assetid='"
                                     +assetid+"' and isreturn='否'");
                while (rs.next()) {
                    vt.add(rs.getString(1));
                }
        rs=st.executeQuery(
                    "select ename from Employee where empno='"
                                     +vt.get(0)+"'");
                while (rs.next()) {
                    vt.add(rs.getString(1));
                }
        rs=st.executeQuery("select usedate from lend where assetid='"
                                     +assetid+"' and isreturn='否'");
                while (rs.next()) {
                    vt.add(rs.getString(1));
                }
              } catch (SQLException ex) {
              }
              return vt;
       }

       public void updatereturn(String assetid,String retdate,String returnoperator){
               try {
                   st.executeUpdate("update lend set retdate='"+retdate+
                                    "',returnoperator='"+returnoperator+
                                    "',isreturn='是' where assetid='"+
                                    assetid+"' and retdate is null and returnoperator is null");
                   st.executeUpdate("update asset set status='在库' where assetid='"+
                                    assetid+"'");

               } catch (SQLException ex) {
               }

    }

    public DefaultTableModel getlendsearchinfo(String str){
        try {
            rs = st.executeQuery(str);
            vt=new Vector();
            while (rs.next()) {
                tempvt=new Vector();
                for(int i=1;i<=rs.getMetaData().getColumnCount();i++)
                    tempvt.add(rs.getString(i));
                vt.add(tempvt);
            }
            vtColName=new Vector();
            for(int i=1;i<=rs.getMetaData().getColumnCount();i++){
                vtColName.add(rs.getMetaData().getColumnName(i));
            }
            dt=new DefaultTableModel(vt,vtColName);
        } catch (SQLException ex) {
        }
        return dt;
    }

    public DefaultTableModel getlendinfo(){
     try {
         rs = st.executeQuery("select * from lend");
         vt=new Vector();
         while (rs.next()) {
             tempvt=new Vector();
             for(int i=1;i<=rs.getMetaData().getColumnCount();i++)
                    tempvt.add(rs.getString(i));
             vt.add(tempvt);
         }
         vtColName=new Vector();
         for(int i=1;i<=rs.getMetaData().getColumnCount();i++){
             vtColName.add(rs.getMetaData().getColumnName(i));
         }
         dt=new DefaultTableModel(vt,vtColName);
     } catch (SQLException ex) {
     }
     return dt;
 }


    private void jbInit() throws Exception {
    }

}