without0815的专栏

package org.yingmm.entity.conn.utils;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;/** * @ClassName: JdbcConnHelp * @Date:2015-1-12 下午05:13:23 * @author yingmm * @description: 数据库连接 辅助类 */public class JdbcConnHelp {private static final String driver = "oracle.jdbc.driver.OracleDriver";private static String url = "jdbc:oracle:thin:@192.168.1.190:1521:orclvids";private static final String user = "mgr";private static final String password = "vids123";/* * private static final String driver = * TemplateUtil.getTemplateUtil().getProperties("jdbc.driver",""); private static String * url=TemplateUtil.getTemplateUtil().getProperties("jdbc.url",""); private static final String * user = TemplateUtil.getTemplateUtil().getProperties("jdbc.user",""); private static final * String password = TemplateUtil.getTemplateUtil().getProperties("jdbc.password",""); */private static Connection getConnection = null;/** * getConnections:开启session会话 * * @author yingmm * @Date:2015-1-13下午04:27:22 * @description */public static Connection getConnections() {try {Class.forName(driver);getConnection = DriverManager.getConnection(url, user, password);/**conn =JdbcConnHelp.getConnections();statement =conn.createStatement();*/System.out.println("★★★★★★★★★★–jdbc连接数据库成功…用户：" + user + "-★★★★★★★★★★★★★★");} catch (Exception e) {e.printStackTrace();}return getConnection;}/** * closeConnection:关闭session会话 * * @author yingmm * @Date:2015-1-13下午04:27:52 * @description */public static void closeConnection(ResultSet rs, Statement statement, Connection conn) {try {if (rs != null) {rs.close();}if (statement != null) {statement.close();}if (conn != null) {conn.close();}System.out.println("★★★★★★★★★★–session连接已关闭–★★★★★★★★★★★★★★");} catch (SQLException e) {e.printStackTrace();}}/** * getSchema:得到用户的方案名称 * * @author yingmm * @Date:2015-1-13下午04:28:11 * @description */public static String getSchema() throws Exception {String schema;schema = getConnection.getMetaData().getUserName();if ((schema == null) || (schema.length() == 0)) {throw new Exception("ORACLE数据库模式不允许为空");}return schema.toUpperCase().toString();}}

，我们人生中最大的懒惰，就是当我们明知自己拥有作出选择的能力，