感觉写的还凑活,基本符合模板的样式,和大家共享一下,希望给大家带来方便奥。 package com.dao; import java.sql.*; public class DBCon { private static final String DBDRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; private static final String DBURL = "jdbc:sqlserver://localhost:1433;DatabaseName=company"; private static final String DBUSRE = "sa"; private static final String DBPASSWORD = "sa"; public static Connection getConnection() { Connection conn = null; try { Class.forName(DBDRIVER); conn = DriverManager.getConnection(DBURL, DBUSRE, DBPASSWORD); } catch (Exception e) { e.printStackTrace(); } return conn; } public static void closeConnection(Connection conn) { try { if (conn != null && (!conn.isClosed())) { conn.close(); } } catch (Exception e) { e.printStackTrace(); } } }