facilityda.java~38~

是我写的一些关于设备基础管理的一些代码程序

package 设备管理系统2;

import java.sql.Connection;
import java.sql.Statement;
import java.io.*;
import java.sql.*;
import java.util.Date;
import java.util.Vector;

//import com.sun.corba.se.connection.*;



public class FacilityDA {
   static Facility aFacility;
   static String url = "jdbc:odbc:facility";
   // static String url = "jdbc:odbc:test";
    static Connection aConnection;
    static Statement aStatement;
    static String fileNo2;
    static String facilityNo2;
    static String name2;
    static String type2;
    static String factory2;
    static String makeTime2;
    static String useTime2;
    static String coefficientJF2;
    static String coefficientDF2;
    static String value2;
    static String useYear2;
    static String useSpeed2;
    static String motorData2;
    static String power2;
    static String category2;
    static String useDepartment2;
    static String remark2;
    String sql;

    public static void initialize() {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            aConnection = DriverManager.getConnection(url, "sa", "blessme");
            aStatement = aConnection.createStatement();
        } catch (ClassNotFoundException e) {
            System.out.println(e);
        } catch (SQLException e) {
            System.out.println(e);
        }
    }

    public static void terminate() {
        try {
            aConnection.close();
            aStatement.close();
        } catch (SQLException e) {
            System.out.println(e);
        }
    }

    public static Vector getall(String sql)
    {Vector facilities =new Vector();
       //String sql="select * from FACILITY";
       try{ ResultSet re= aStatement.executeQuery(sql);
           boolean more =re.next();
           while(more)
           {   String fileNo = re.getString(1);
                String name = re.getString(2);
                String facilityNo =re.getString(3);

                String type = re.getString(4);
                String factory = re.getString(5);
                String makeDate =re.getString(6);
                String useDate = re.getString(7);
                String paraJF = re.getString(8);
                String paraDF =re.getString(9);
                String value =re.getString(10);
                String useSpeedYear = re.getString(11);

                String useRate =re.getString(12);
                String motorNo = re.getString(13);
                String power =re.getString(14);
                String category = re.getString(15);
                String useDepartment =re.getString(16);
                Facility aFacility = new Facility(fileNo,
                                                  facilityNo,
                                                  name,
                                                  type,
                                                  factory,
                                                  makeDate,
                                                  useDate,
                                                  paraJF,
                                                  paraDF,
                                                  value,
                                                  useSpeedYear,
                                                  useRate,
                                                  motorNo,
                                                  power,
                                                  category,
                                                  useDepartment,
                                                  remark);
                facilities.addElement(aFacility);

           }
           re.close();
       }
       catch ( SQLException ex)
       {System.out.println(); }
       return facilities;
    }

    public static void addNewFacility(Facility aFacility) {
        fileNo2 = aFacility.getFileNo();
        facilityNo2 = aFacility.getFacilityNo();
        name2 = aFacility.getName();
        type2 = aFacility.getType();
        factory2 = aFacility.getFactory();
        makeTime2 = String aFacility.getMakeTime().toString();
        useTime2 = String aFacility.getUseTime().toString();
        coefficientJF2 = aFacility.getCoefficientJF();
        coefficientDF2 = aFacility.getCoefficientDF();
        value2 = aFacility.getValue();
        useYear2 = aFacility.getUseYear();
        useSpeed2 = aFacility.getUseSpeed();
        motorData2 = aFacility.getMotorData();
        power2 = aFacility.getPower();
        category2 = aFacility.getCategory();
        useDepartment2 = aFacility.getUseDepartment();
        remark2 = aFacility.getRemark();
        try {
            String sql = "INSERT INTO FACILITY (fileNo, facilityNo,facilityName, facilityType, manuFactory, manuDate, startUseDate, complexityParaJF, complexityParaDF, facilityValue, depreciationYears, depreciationRate, motorNumber,"
                         + "powerKW, facilityCategory, useDepartment, facilityRemark) VALUES("
                         +"'"+fileNo2 + "',"
                         +"'"+ facilityNo2 + "',"
                         +"'"+ name2 + "',"
                         +"'"+ type2+ "',"
                         +"'"+ factory2 + "',"
                         + "'"+makeTime2 + "',"
                         +"'"+ useTime2 + "',"
                         + "'"+coefficientJF2 + "',"
                          +"'"+ coefficientDF2 + "',"
                         + "'"+value2 + "',"
                         + "'"+useYear2 + "',"
                         + "'"+useSpeed2 + "',"
                        + "'"+motorData2 + "',"
                         + "'"+power2 + "',"
                         + "'"+category2 + "',"
                         + "'"+useDepartment2 + "',"
                         + "'"+remark2 + "')";
            System.out.println("sql");
            System.out.println(sql);
            System.out.println("sql");
                           aStatement.executeUpdate(sql);
        } catch (SQLException ex) {
            System.out.println("error");
            while (ex != null) {
                System.out.println("Message: " + ex.getMessage());
                System.out.println("SQLState: " + ex.getSQLState());
                System.out.println("ErrorCode: " + ex.getErrorCode());
                ex = ex.getNextException();
            }
        }
    }


}