sql.java~130~

企业固定资产管理系统

package zhican;
import java.sql.*;
import java.util.List;
import java.util.ArrayList;
public class sql {//连接数据库
    static Connection con=null;//连接对象
    static Statement sta=null;//操作对象
    ResultSet rs=null;//结果级
    public sql() {
    }
    public Statement  getsta(){
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载驱动程序
            con = java.sql.DriverManager.getConnection("jdbc:odbc:wubi");//连接数据库
            sta = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);//更改游标类型
        } catch (ClassNotFoundException ex) {
            System.out.println(ex);
        } catch (SQLException ex) {
           System.out.println(ex);
        }

        return sta;

    }
  //员工增加方法
  public void zhengjia(String a,String b,String c){
    try {
      sta.executeUpdate("INSERT INTO wwwworkers VALUES('"+a+"','"+b+"','"+c+"')");

    } catch (SQLException ex) {
      System.out.println(ex);
    }
  }
  //员工删除方法
  public void shanchu(String a,String b,String c){
    try {
      sta.executeUpdate("delete wwwworkers where 员工姓名='"+a+"'");

    } catch (SQLException ex) {
      System.out.println(ex);
    }
  }
//查询员工信息内容
  public ArrayList xinxi(String a){
    ArrayList arr=new ArrayList();
    try {
     rs=sta.executeQuery("SELECT * FROM wwwworkers where 员工姓名='"+a+"'");
     if(rs.next()){
       arr.add(rs.getString(1).toString());
       arr.add(rs.getString(3).toString());
       arr.add(rs.getString(4).toString());
     }
     return arr;
    } catch (SQLException ex) {
      System.out.println(ex);
    }
    return null;
  }
  //员工修改方法
public void xiugai(String a,String b,String c,String d){
  try {
    sta.executeUpdate("update wwwworkers set 员工姓名='"+a+"', 职位='"+b+"',备注='"+c+"' where 员工编号="+d+"");

  } catch (SQLException ex) {
    System.out.println(ex);
  }
}
//,类增加
public void leizhengjia(String a,String b,String c,String d){
    try {
      sta.executeUpdate("INSERT INTO category VALUES('"+a+"','"+b+"','"+c+"','"+d+"')");

    } catch (SQLException ex) {
      System.out.println(ex);
    }
  }
  //类删除
  public void leishanchu(String c){
     try {
       sta.executeUpdate("delete category where subcatename ='"+c+"'");

     } catch (SQLException ex) {
       System.out.println(ex);
     }
   }
  //select
   public ArrayList leixinxi(String c){
       ArrayList arr=new ArrayList();
       try {
        rs=sta.executeQuery("SELECT * FROM category where subcatename='"+c+"'");
        if(rs.next()){
          arr.add(rs.getString(1).toString());
          arr.add(rs.getString(2).toString());
          arr.add(rs.getString(3).toString());
        }
        return arr;
       } catch (SQLException ex) {
         System.out.println(ex);
       }
       return null;
     }
     //类修改方法
   public void leixiugai(String a,String b,String c,String d){
     try {
       sta.executeUpdate("update category set subcatename='"+d+"', catename='"+b+"',subcateid="+c+" where cateid="+a+"");
     } catch (SQLException ex) {
       System.out.println(ex);
     }
   }

   public void zeng(String a,String b){//增加用户
    try {
      sta.executeUpdate("INSERT INTO wwwuser VALUES('"+a+"','"+b+"')");

    } catch (SQLException ex) {
      System.out.println(ex);
    }
  }

  public void deluser(String a){  //用户删除
       try {
         sta.executeUpdate("delete wwwuser where 管理员ID ='"+a+"'");

       } catch (SQLException ex) {
         System.out.println(ex);
       }
     }

      //添加借用信息表
      public boolean instr(String aa,String bb,String ee,String ff){
          int xx=Integer.parseInt(aa);
          int yy=Integer.parseInt(bb);
          try {
         sta.executeUpdate("insert into wwwlend(固定资产编号,借用人编码,是否归还,操作员,备注) values("+xx+","+yy+",'否','"+ee+"','"+ff+"')");
         return true;
       } catch (SQLException ex) {
         System.out.println(ex);
       }
       return false;
      }
      //修改借用信息表
      public boolean update(String aa,String dd,String ee,String ff){
          int xx=Integer.parseInt(aa);
          try {
         sta.executeUpdate("update wwwlend set  归还日期='"+ dd +"',是否归还='是',操作员='"+ee+"',备注='"+ff+"' where 固定资产编号="+aa+" and 是否归还='否'");
         return true;
       } catch (SQLException ex) {
         System.out.println(ex);
       }
       return false;
      }
      //combobox添加小类别
      public List qq(){
      ArrayList jiang=new ArrayList();
        try {
            rs = sta.executeQuery("select DISTINCT * from wwwgoods ");
            while(rs.next()){
                jiang.add(rs.getString(4));
            }
        } catch (SQLException ex) {
            System.out.println(ex);
        }
        return jiang;
    }
  //查询固定
  public ArrayList zhi(String abc){
  ArrayList arr=new ArrayList();
  int rrr=Integer.parseInt(abc);
  try {
   rs=sta.executeQuery("SELECT * FROM wwwgoods where 编号="+rrr+"");
   if(rs.next()){
     arr.add(rs.getString(2).toString());
     arr.add(rs.getString(3).toString());
     arr.add(rs.getString(4).toString());
     arr.add(rs.getString(5).toString());
     arr.add(rs.getString(6).toString());
     arr.add(rs.getString(7).toString());
     arr.add(rs.getString(8).toString());
     arr.add(rs.getString(9).toString());
     arr.add(rs.getString(10).toString());
     arr.add(rs.getString(11).toString());

   }
   return arr;
  } catch (SQLException ex) {
    System.out.println(ex);
  }
  return arr;
}
//固定资产增加
    public boolean zzc(String aaa,String bbb,String ccc,String ddd,String fff,String gr1,String gr2,String gr3,String hhh,String ggg){
       int moy=Integer.parseInt(ccc);
       try {
           sta.executeUpdate("INSERT INTO wwwgoods(名称,大类别,小类别,型号,价值,购买日期,状态,使用者,图片名称,备注)VALUES('"+aaa+"','"+gr1+"','"+gr2+"','"+bbb+"',"+moy+",'"+ddd+"','"+gr3+"','"+fff+"','"+ggg+"','"+hhh+"')");
           return true;
       } catch (SQLException ex) {
         System.out.println(ex);
       }
       return false;
     }

//xiugai固定
public boolean updateg(String aaaa,String bbbb,String gr11,String gr22,String cccc,String dddd,String eeee,String gr33,String ffff,String gggg,String hhhh){
   int bianhao=Integer.parseInt(aaaa);
  int mey=Integer.parseInt(dddd);
          try {
         sta.executeUpdate("update wwwgoods set  名称='电脑',大类别='"+gr11+"',小类别='"+gr22+"',型号='"+cccc+"',价值="+mey+",购买日期='"+eeee+"',状态='"+gr33+"',使用者='"+ffff+"',图片名称='"+gggg+"',备注='"+hhhh+"' where  编号="+bianhao+"");
             return true;
       } catch (SQLException ex) {
         System.out.println(ex);
       }
       return false;
      }

public void delgd(String a){  //资产删除
       try {
         sta.executeUpdate("delete wwwgoods where 编号 ='"+a+"'");

       } catch (SQLException ex) {
         System.out.println(ex);
       }
     }

}