这个代码貌似有问题
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBConnection
{
private static String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
private static String url = "jdbc:sqlserver://localhost:1433;DataBaseName=jdbc_test";
private static String username = "sa";
private static String password = "sa";
static
{
try
{
Class.forName(driverName);
}
catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Connection getConnection() throws SQLException {
return DriverManager.getConnection(url, username, password);
}
public static void close(ResultSet rs, Statement st, Connection conn) {
try {
if (rs == null)
rs.close();
}
catch (SQLException e)
{
e.printStackTrace();
} finally {
try {
if (st == null)
st.close();
}
catch (SQLException e)
{
e.printStackTrace();
if (conn == null)
try {
conn.close();
}
catch (SQLException e) {
e.printStackTrace();
}
}
finally
{
if (conn != null)
try {
conn.close();
}
catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}