company.java

本工程模拟网上社区,其中包括银行,软件销售公司,软件投资公司,茶餐馆,和多个服务器.

package bankserver;

import java.sql.*; 

 
public class Company {
      private int id;
      private String name;
      private long property;
      private String JDriver="sun.jdbc.odbc.JdbcOdbcDriver";
      private String conURL="jdbc:odbc:Employee";
      public Connection con;
      
    public Company() {
        try{
            Class.forName(JDriver);   //加载jdbc-odbc驱动程序
        }catch(java.lang.ClassNotFoundException e){
            System.out.println("forname:"+e.getMessage());
        }
        
    }
    public void Sconnection()   //连接数据库 
    {
        try{
             con=DriverManager.getConnection(conURL);
        }catch(SQLException e)
        {
            System.out.println("SQLException: "+e.getMessage());
        }
    }
    public void find(String id,String name)    //查找职工信息
    {
        Sconnection();
        try{
             Statement s =con.createStatement();
             ResultSet rs=s.executeQuery("select * from 职工信息");
             int a=0;
             while(rs.next())
             {
                 if(rs.getString("职工号").equals(id)&&rs.getString("姓名").equals(name))
                 {
                     allJFrame af=new allJFrame(totalJFrame.op);
                     af.set(id,name,rs.getString("性别"),rs.getInt("年龄"),rs.getString("籍贯"),rs.getString("婚姻状况"),rs.getInt("工龄"),rs.getInt("工资"),rs.getString("职位"));
                     af.show();
                     a=1;
                     break;
                 }
             }
             if(a==0)
             {
                  failJFrame ff=new failJFrame();
                  ff.show();
             }
             con.close(); 
        }catch(SQLException e){
            System.out.println("SQLException: "+e.getMessage());
            failJFrame ff=new failJFrame();
            ff.show();
        }
    }
   public void add(employee emp)             //添加职工信息
    {
        Sconnection();
        try{
            Statement s=con.createStatement();
            String r="insert into 职工信息 values(0,0,0,0,0,0,0,0,0)";
            s.executeUpdate(r);
            s.close();
            PreparedStatement ps=con.prepareStatement("UPDATE 职工信息 set 职工号=?, 姓名=?,性别=?, 年龄=?,籍贯=?,婚姻状况=?,工龄=?,工资=?, 职位=? WHERE 工资=0");
            ps.setString(1,emp.id);
            ps.setString(2,emp.name);
            ps.setString(3,emp.sex);
            ps.setInt(4,emp.age);
            ps.setString(5,emp.hometown);
            ps.setString(6,emp.marriage);
            ps.setInt(7,emp.worktime);
            ps.setInt(8,emp.salary);
            ps.setString(9,emp.status);
            ps.executeUpdate();
            ps.close();
            con.close();
            successJFrame sf=new successJFrame();
            sf.show();
        }catch(SQLException e)
        {
            System.out.println("SQLException: "+e.getMessage());
            failJFrame ff=new failJFrame();
            ff.show();
        }
    }  
    public void Sedit(employee emp)           //编辑职工信息
    {
          Sconnection();
            try{
               String temp=emp.id;
            PreparedStatement ps=con.prepareStatement("UPDATE 职工信息 set 职工号=?, 姓名=?,性别=?, 年龄=?,籍贯=?,婚姻状况=?,工龄=?,工资=?, 职位=? WHERE 职工号=?");
            ps.setString(1,emp.id);
            ps.setString(2,emp.name);
            ps.setString(3,emp.sex);
            ps.setInt(4,emp.age);
            ps.setString(5,emp.hometown);
            ps.setString(6,emp.marriage);
            ps.setInt(7,emp.worktime);
            ps.setInt(8,emp.salary);
            ps.setString(9,emp.status);
            ps.setString(10,temp);
            ps.executeUpdate();
            ps.close();
            con.close();
            successJFrame sf=new successJFrame();
             sf.show();
        }catch(SQLException e)
        {
            System.out.println("SQLException: "+e.getMessage());
            failJFrame ff=new failJFrame();
            ff.show();
        }
    }
    public void Sdelete(String id)   //删除职工信息
    {
        Sconnection();
        try{
            PreparedStatement ps=con.prepareStatement("delete from 职工信息 where 职工号=?");
            ps.setString(1,id);
            ps.executeUpdate();
            ps.close();
            con.close();
            successJFrame sf=new successJFrame();
            sf.show();
        }catch(SQLException e)
        {
            System.out.println("SQLException: "+e.getMessage());
            failJFrame ff=new failJFrame();
            ff.show();
        }
    }
}