public class ConnectionManager {
private static final String DRIVER_NAME = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
private static final String URL = "jdbc:sqlserver://localhost:1433;databaseName=newsDB";
private static final String USERNAME = "sa";
private static final String PASSWORD = "123456";
public static Connection getConnectionFromJDBC() {
Connection conn = null;
try {
Class.forName(DRIVER_NAME);
conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
public static Connection getConnectionFromJNDI() {
Connection conn = null;
try {
Context ctx = new InitialContext();
DataSource source = (DataSource) ctx.lookup("java:comp/env/jdbc/ch05");// 需要在xml配置
conn = source.getConnection();
} catch (SQLException e) {
e.printStackTrace();
} catch (NamingException e) {
e.printStackTrace();
}
return conn;
}
public static void closeConnection(Connection conn) {
try {
if (conn != null && !conn.isClosed()) {
conn.close();
conn = null;
}
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void closePreparedStatement(PreparedStatement psmt) {
try {
if (psmt != null) {
psmt.close();
psmt = null;
}
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void closeResultSet(ResultSet rs) {
try {
if (rs != null) {
rs.close();
rs = null;
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
2个连接方式,一个直连,一个连接池,连的是sql server
追问我写好了 连不上呢 数据库要哪些操作?
追答private static final String DRIVER_NAME = "com.microsoft.sqlserver.jdbc.SQLServerDriver";//驱动文件类名,要连接数据库首先要将你的数据库驱动包仍到项目里,要去网上下
private static final String URL = "jdbc:sqlserver://localhost:1433;databaseName=newsDB";//这里写的是数据库连接的配置,每个数据库都不同,这里写的是sqlserver 2005
private static final String USERNAME = "sa";//数据库登陆账号
private static final String PASSWORD = "123456";//数据库登陆密码
建议你先用直连,比较容易,会了之后再去弄连接池,连接池需要配置xml
本回答被网友采纳