Java连接SQLServer数据库的JDBC驱动,里面含有java连接数据库的代码,将驱动jar包add到你的库中,然后改一改代码,(如更换数据库用户名密码,查询语句),就可以使用了,适合新人.
2019-12-21 20:47:38
2.09MB
1
package com.hexiang.utils.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;
import org.apache.log4j.Logger;
public class DBConnection {
/**
* 获得与数据库的连接
*
* @param path
* @return Connection
*/
public static Connection getConn(String classDriver, String url,
String user, String pwd) {
try {
Class.forName(classDriver);
return DriverManager.getConnection(url, user, pwd);
} catch (ClassNotFoundException ex) {
ex.printStackTrace();
} catch (SQLException ex) {
ex.printStackTrace();
}
return null;
}
public static Connection getConn(DataSource dataSource) {
try {
return dataSource.getConnection();
} catch (SQLException ex) {
ex.printStackTrace();
}
return null;
}
public static Connection getConn(String jndiName) {
try {
Context ctx;
ctx = new InitialContext();
DataSource dataSource = (DataSource) ctx.lookup("java:comp/env/"
+ jndiName);
return dataSource.getConnection();
} catch (NamingException ex) {
ex.printStackTrace();
} catch (SQLException ex) {
ex.printStackTrace();
}
return null;
}
public static Connection getConn(Properties properties) {
try {
String driver = properties.getProperty("jdbc.driverClassName");
String url = properties.getProperty("jdbc.url");
String user = properties.getProperty("jdbc.username");
String password = properties.getProperty("jdbc.password");
Class.forName(driver);
return DriverManager.getConnection(url, user, password);
} catch (ClassNotFoundException ex) {
ex.printStackTrace();
} catch (SQLException ex) {
ex.printStackTrace();
}
return null;
}
/**
* oracle连接
*
* @param path
* @return Connection
*/
public static Connection getOracleConn(String
2019-12-21 19:52:10
1013B
1