JDBC连接和配置文件使用

1、直接连接JDBC并且进行数据库的修改，贴出来的代码是进行数据库的插入操作，修改可进行更改和删除，注释的代码是进行查询操作。

package Test;

import java.sql.*;



public class Connetion1 {
    public static void main(String[] args) {
        Connection conn  = null;
        PreparedStatement prestat = null;
        ResultSet  res = null;
        String driver = "com.mysql.cj.jdbc.Driver";
        String url = "jdbc:mysql://localhost:3306/r1";
        String name = "root";
        String password = "123456";
        try{
            //1、注册驱动
            Class.forName(driver);
            //2、创建连接
            conn = DriverManager.getConnection(url,name,password);
            //3、创建数据库对象
            String sql = "INSERT INTO people (name,sage) VALUES (?,?)";
            prestat = conn.prepareStatement(sql);
            prestat.setString(1,"张三");
            prestat.setInt(2,18);
            //4、执行SQL语句
            int count = prestat.executeUpdate();
            System.out.println("增加记录为："+count);
//            res = prestat.executeQuery();
            //5、数据处理
//            while(res.next()){
//                String bname = res.getString("name");
//                String bage =res.getString("sage");
//                System.out.println(bname+ "  "+ bage);
//            }
        }catch(Exception e){
            e.printStackTrace();
        }finally{
            //6、释放资源
            if(res!=null){
                try {
                    conn.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            if(prestat!=null){
                try {
                    conn.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            if(conn!=null){
                try {
                    conn.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }
    }
}

2、使用配置文件进行连接

package Test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.*;
public class Connection2 {
    public static void main(String[] args) {
        String driver = null;
        String url = null;
        String user = null;
        String password = null;
        Connection conn = null;
        PreparedStatement pre = null;
        ResultSet res =null;
        try {
            ResourceBundle resget = ResourceBundle.getBundle("profile");
            driver = resget.getString("driver");
            url = resget.getString("url");
            user = resget.getString("user");
            password = resget.getString("password");
            Class.forName(driver);
            conn = DriverManager.getConnection(url,user,password);
            String sql = "SELECT * FROM people";
            pre = conn.prepareStatement(sql);
            res =  pre.executeQuery();
            while (res.next()) {
                System.out.println(res.getString("name" ) + "    "+ res.getString("sage"));
            }
        }catch (Exception e) {
                e.printStackTrace();
        }finally{
            if(res!=null){
                try{
                    res.close();
                }catch(Exception e){
                    e.printStackTrace();
                }
            }
            if(pre!=null){
                try{
                    pre.close();
                }catch(Exception e){
                    e.printStackTrace();
                }
            }
            if(conn!=null){
                try{
                    conn.close();
                }catch(Exception e){
                    e.printStackTrace();
                }
            }
        }
    }
}

配置文件中内容，配置文件要放在src目录中，我的配置文件名字是：profile.properties

driver=com.mysql.cj.jdbc.Driver
user=root
password=123456
url=jdbc:mysql://localhost:3306/r1