opendb.java

包括从业人员信息录入等功能

package DB;
import java.sql.*;

public class OpenDB {

    private String Driver = "oracle.jdbc.driver.OracleDriver";
    private String url= "jdbc:oracle:thin:@localhost:1521:zagl";
    private String user="system";
    private String password="a";

    private Connection con = null;

    public OpenDB() {

    }


    public boolean openConnect(){
        try {
            Class.forName(Driver).newInstance();
            con = DriverManager.getConnection(url,user,password);
            return true;
        } catch (Exception e) {System.out.print(e);
            return false;
        }
    }

    public Connection getConnection(){
        return con;
    }

    public boolean closeConnection(){
        try{
            con.close();
            return true;
        }catch(Exception e){return false;}
    }
    public static void main(String args[]){
    	OpenDB op = new OpenDB();
    	try{
    	if(op.openConnect()){System.out.print("成功");}else{
    	System.out.print("失败");

    	}
    	}catch(Exception e){System.out.print(e);}

    }
}