dbbase.java~12~

管理系统

package com.aptech.cdjj.sex;

import java.sql.Connection;
import java.util.Vector;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.DriverManager;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;

public class DBbase {
    static private Connection con;
    static private PreparedStatement ps;
    static private ResultSet rs;

    public DBbase() {
    }
    public static void createCon(){
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            con=DriverManager.getConnection("jdbc:odbc:CheongSam","sa","9413");
        } catch (ClassNotFoundException ex) {
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }
    public static void close(){
        try {
             if(rs!=null){
                 rs.close();
             }
             if(ps!=null){
                 ps.close();
             }
             if(con!=null){
                 con.close();
             }
         } catch (Exception ex) {
             ex.printStackTrace();
         }

    }
    public static Vector getFirstColumn(String sql){//
       Vector v = new Vector();
       createCon();
       try {
           ps = con.prepareStatement(sql);
           rs = ps.executeQuery();
           while(rs.next()){
               v.add(rs.getString(1));
           }
       } catch (SQLException ex) {
           ex.printStackTrace();
       }
       close();

       return v;
    }
    public static Vector getTitle(String sql){
        Vector v = new Vector();
        createCon();
        try {
            ps = con.prepareStatement(sql);
            rs = ps.executeQuery();
            ResultSetMetaData rsmd = rs.getMetaData();
            int num = rsmd.getColumnCount();
            for (int i = 0; i < num; i++) {
                v.add(rsmd.getColumnName(i));
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }finally{
            close();
        }
        return v;
    }
    public static Vector getAll(String sql){
        Vector v = new Vector();
        createCon();
        try {
            ps = con.prepareStatement(sql);
            rs = ps.executeQuery();
            while(rs.next()){
                Vector temp = new Vector();
                for (int i = 1; i < rs.getMetaData().getColumnCount(); i++) {
                    temp.add(rs.getObject(i));
                }
                v.add(temp);
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }finally{
            close();
        }
        return v;
    }
    public static int dbUpdate(String sql){
        createCon();
        try {
            ps = con.prepareStatement(sql);
            return ps.executeUpdate();
        } catch (SQLException ex) {
            ex.printStackTrace();
            return 0;
        }
    }
}