jdbc数据库操作（二）单例模式

创建单例模式，用来加载驱动

//要点：

两个私有的属性

一个私有方法

一个对外开放的静态方法，返回当前链接

package cn.utils;


import java.io.IOException;
import java.io.InputStream;
import java.util.InvalidPropertiesFormatException;
import java.util.Properties;


import com.sun.org.apache.regexp.internal.recompile;


public class ConfigManage {
private static ConfigManage configManage;
private static Properties properties;


private ConfigManage() {
properties = new Properties();
InputStream is = null;
try {
is = ConfigManage.class.getClassLoader().getResourceAsStream(
"database.properties");
properties.load(is);
} catch (InvalidPropertiesFormatException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
try {
is.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}


public static synchronized ConfigManage getInstance() {
if (configManage == null) {
synchronized (ConfigManage.class) {
if (configManage == null) {
configManage = new ConfigManage();
}
}
}
return configManage;
}


public String getValues(String key) {
return (String) properties.get(key);
}
}

创建一个BaseDao类，他用来创建一些数据库操作方法：

package cn.v.dao;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;


import cn.untils.Untils;


public class BaseDao {
public static Connection conn = null;


// 创建连接
public static Connection connction() {


try {
Class.forName(Untils.name);
conn = DriverManager.getConnection(Untils.url, Untils.user,
Untils.pwd);


} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {<