JDBC (java data base Connectivity)
- 导ojdbc包:
- 连接数据库,定义JDBCUtil类,编写静态块,通过Properties获取:
PathName:oracle.jdbc.driver.OracleDriver;
Url:jdbc:oracle:thin:@localhost:1521:orcl;(localhost为本机地址,也可通过输入其他地址远程操作)
User:数据库用户名;
password:数据库用户密码;
public class JDBCUitl {
private static String pathName;
private static String url;
private static String user;
private static String password;
static{
try {
Properties p = new Properties();
p.load(new FileInputStream("JDBC.properties"));
pathName = p.getProperty("pathName");
url = p.getProperty("url");
user =p.getProperty("user");
password = p.getProperty("password");
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
- 编写方法获取连接(getconnection):
public static Connection getConnection(){
Connection conn = null;
try {
conn = DriverManager.getConnection(url,user,password);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
- 编写close类用来在操作结束是关闭资源(close(Connection conn,PreparedStatement ps,ResultSet rs)):
public static void close(Connection conn,PreparedStatement ps,ResultSet rs){
try {
if(rs!=null){
rs.close();
}
} catch (SQLException e1) {
e1.printStackTrace();
}
try {
if(ps!=null){
ps.close();
}
} catch (SQLException e1) {
e1.printStackTrace();
}
try {
if(conn!=null){
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
- 编写测试类测试连接:
Connection conn =JDBCUitl.getConnection();
System.out.println(conn);
System.out.println("连接成功");
输出如下图即为连接成功: