dbbase.java~6~

管理系统

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 {           
                rs.close();             
                ps.close();         
                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();
       } finally {
           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();
        ps = con.prepareStatement(sql);
        rs = ps.executeQuery();
        
    }
    public static boolean dbUpdate(String sql){
        createCon();
        int num=0;
        try {
            ps=con.prepareStatement(sql);
            num=ps.executeUpdate();
            
        } catch (Exception ex) {
            ex.printStackTrace();
        }finally{
            close();
        }
        if(num > 0){
            return true;
        }else{
            return false;
        }
    }
}