JDBC

习惯用Hibernate，发现最近连最基本的JDBC连接数据库都忘记了
写个例子下来

package com.dao;

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

import com.Bb;

public class DBConnection {

public static final String URL = "jdbc:microsoft:sqlserver://localhost:1423;DatabaseName=test";

public static final String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

public Connection getConn(){
Connection conn = null;
try {
Class.forName(Bb.DRIVER);
conn = DriverManager.getConnection(Bb.URL, "sa", "tyq");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}

public static void closeAll(Connection conn,PreparedStatement ps,ResultSet rs){

try {
if(null != conn){
conn.close();
}

if(null != rs){
rs.close();
}

if(null != ps){
ps.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}