JDBCUtil
时间：2021-07-01 10:21:17
帮助过：23人阅读
cn.itsource.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
public class JDBCUtil {
private static JDBCUtil instance =
null;
private static Properties p =
null;
private JDBCUtil() {
}
static {
try {
p =
new Properties();
p.load(Thread.currentThread().getContextClassLoader()
.getResourceAsStream("jdbc.properties"
));
Class.forName(p.getProperty("driverClassname"
));
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
instance =
new JDBCUtil();
}
public Connection getConnection() {
try {
return DriverManager.getConnection(p.getProperty("url"
),
p.getProperty("username"), p.getProperty("password"
));
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}
public static JDBCUtil getInstance() {
return instance;
}
public void close(ResultSet rs, Statement st, Connection conn) {
try {
if (rs !=
null)
rs.close();
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} finally {
try {
if (st !=
null)
st.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
if (conn !=
null)
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
}
JDBCUtil
标签：ace ade bsp exception manage word todo ati tcl
