?? dbpool.java
字號:
package com.publish.shop.util.db;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.Statement;public class DbPool{ public static Connection getConnection() throws Exception { String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=shop"; String user="sa"; String pwd="sa"; Connection con = null; try { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); con = DriverManager.getConnection(url,user,pwd); } catch(Exception e) { e.printStackTrace(); throw e; } return con; } public static Connection getConnectionEx() throws Exception { String url="jdbc:microsoft:sqlserver://localhost:9999;DatabaseName=shop"; String user="shop"; String pwd="shop"; Connection con = null; try { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); con = DriverManager.getConnection(url,user,pwd); } catch(Exception e) { e.printStackTrace(); throw e; } return con; } /*{ Connection con = null; try { DataSource ds = null; Context initCtx = new InitialContext(); Context envCtx = (Context)initCtx.lookup("java:comp/env"); ds = (DataSource)envCtx.lookup("jdbc/shop"); if (ds != null) { con = ds.getConnection(); } } catch(Exception e) { e.printStackTrace(); throw e; } return con; }*/ public static void closeConnection(Connection con) { try { if (con != null) con.close(); } catch(Exception e) { } } public static void closeStatement(Statement stmt) { try { if (stmt != null) stmt.close(); } catch(Exception e) { } } public static void closeStatement(PreparedStatement stmt) { try { if (stmt != null) stmt.close(); } catch(Exception e) { } } public static void closeResultSet(ResultSet rs) { try { if (rs != null) rs.close(); } catch(Exception e) { } }}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -