62,621
社区成员
发帖
与我相关
我的任务
分享
package com.testandroid.dbtest;
import java.sql.Connection;
import java.sql.DriverManager;
public class DBUtil {
private String driver="sun.jdbc.odbc.JdbcOdbcDriver";
private String jdbcName="jdbc:odbc:Schedule01";
public Connection getCon() throws Exception{
Class.forName(driver);
Connection con=DriverManager.getConnection(jdbcName);
return con;
}
/*
* Close dataBase Connection
*/
public void closeCon(Connection con) throws Exception{
if(con!=null){
con.close();
}
}
public static void main(String[]args){
DBUtil dbu = new DBUtil();
Connection con = null;
try{
con=dbu.getCon();
}catch(Exception e){
e.printStackTrace();
}finally {
try {
dbu.closeCon(con);//close connection;
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}