java JDBC数据库链接

来源：互联网发布：js 拼接字符串编辑：程序博客网时间：2024/04/28 03:57

JDBC链接数据库

一、Mysql

1、内部链接形式

实例:

//加载数据库驱动 Class.forName("com.mysql.jdbc.Driver"); //建立连接String url = "jdbc:mysql://localhost:3306/user";//数据库地址 String userName = "root";//登录用户名称 String password = "123456";//登录密码Connection connection = DriverManager.getConnection(url,userName,password); //使用数据库 String sql = "";//需要执行数据库数据的sql语句 PreparedStatement ps = connection.prepareStatement(sql); ps.execute();

2、外部文件，静态引入

实例:

设置外部文件格式为jdbc.properties

driver=com.mysql.jdbc.Driverurl=jdbc\:mysql\://localhost\:3306/webuserName=rootpassword=123456

内部静态引入外部配置文件

package com.hmingqu.java.util;import java.io.IOException;import java.io.InputStream;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.util.Properties;public class DBConnection {private static String driver;private static String url;private static String userName;private static String password;//静态引入外部配置文件 jdbc.propertiesstatic {//通过输入流引入文件InputStream in = DBConnection.class.getClassLoader().getResourceAsStream("jdbc.properties");Properties pro = new Properties();try {//加载文件内容pro.load(in);//提取文件 内容，设置连接数据库参数driver = pro.getProperty("driver");url = pro.getProperty("url");userName = pro.getProperty("userName");password = pro.getProperty("password");} catch (IOException e) {// TODO Auto-generated catch blocke.printStackTrace();}}/** * 静态创建数据库链接 * @return */public static Connection getInstanceConnection(){Connection connection = null;try {Class.forName(driver);connection = DriverManager.getConnection(url, userName, password);} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}return connection;}public static void close(PreparedStatement preparedStatement,Connection connection){if(preparedStatement != null){try {preparedStatement.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}if(connection != null){try {connection.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}public static void close(PreparedStatement preparedStatement,Connection connection,ResultSet resultSet){if(preparedStatement != null){try {preparedStatement.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}if(connection != null){try {connection.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}if(resultSet != null){try {resultSet.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}}

二、Oracle

1、内部链接形式

实例：

 //加载数据库驱动Class.forName("oracle.jdbc.driver.OracleDriver"); //建立连接 String url = "jdbc:oracle:thin:@localhost:1521:USER";String userName = "scott";//登录用户名称String password = "tiger";//登录密码 Connection connection = DriverManager.getConnection(url,userName,password);           //使用数据库 String sql = "";//需要执行数据库数据的sql语句PreparedStatement ps = connection.prepareStatement(sql); ps.execute();

2、外部文件，静态引入

实例:

设置外部配置文件 jdbc.properties

dirveName=oracle.jdbc.driver.OracleDriverurl=jdbc:oracle:thin:@localhost:1521:ORCLuserName=scottuser_pwd=tiger

外部引入文件，静态引入

package com.hmingqu.java.util;import java.io.IOException;import java.io.InputStream;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.util.Properties;public class DBConnection {private static String driver;private static String url;private static String userName;private static String password;//静态引入外部配置文件 jdbc.propertiesstatic {//通过输入流引入文件InputStream in = DBConnection.class.getClassLoader().getResourceAsStream("jdbc.properties");Properties pro = new Properties();try {//加载文件内容pro.load(in);//提取文件 内容，设置连接数据库参数driver = pro.getProperty("driver");url = pro.getProperty("url");userName = pro.getProperty("userName");password = pro.getProperty("password");} catch (IOException e) {// TODO Auto-generated catch blocke.printStackTrace();}}/** * 静态创建数据库链接 * @return */public static Connection getInstanceConnection(){Connection connection = null;try {Class.forName(driver);connection = DriverManager.getConnection(url, userName, password);} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}return connection;}public static void close(PreparedStatement preparedStatement,Connection connection){if(preparedStatement != null){try {preparedStatement.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}if(connection != null){try {connection.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}public static void close(PreparedStatement preparedStatement,Connection connection,ResultSet resultSet){if(preparedStatement != null){try {preparedStatement.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}if(connection != null){try {connection.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}if(resultSet != null){try {resultSet.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}}

0 0