IDEA中db.properties配置文件以及增删改查在java中的实现

然后在具体的包下新建一个utils包

然后在utils包下新建一个jdbcutils的class类

在jdbcutils中编辑

package com.linfeng.Demo02.utils;

import java.io.IOException;
import java.io.InputStream;
import java.sql.*;
import java.util.Properties;

public class Jdbcutils {
    private static String driver = null;
    private static String url = null;
    private static String username = null;
    private static String password = null;
    static {
        try {
            InputStream in = Jdbcutils.class.getClassLoader().getResourceAsStream("db.properties");
            Properties properties = new Properties();
            properties.load(in);

            driver=properties.getProperty("driver");
            url=properties.getProperty("url");
            username=properties.getProperty("username");
            password=properties.getProperty("password");
            //驱动只用加载一次
            Class.forName(driver);
        }catch(Exception e){
            e.printStackTrace();
        }
    }

    //释放连接资源
public static Connection getConnection() throws SQLException {
    return DriverManager.getConnection(url, username, password);
}

    //6.释放连接
    public static void release(Connection conn, Statement st, ResultSet rs) {
       if (rs!=null){
           try {
               rs.close();
           } catch (SQLException e) {
               e.printStackTrace();
           }
       }
        if (st!=null){
            try {
                st.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if (conn!=null){
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

编写增删改的方法，executeUpdate

package com.linfeng.Demo02.utils;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class test01 {
    public static void main(String[] args) {

        Connection conn=null;
        Statement st=null;
        ResultSet rs=null;

        try {
             conn = Jdbcutils.getConnection();//获取数据库连接
            st = conn.createStatement();//获得sql的执行对象
            String sql="INSERT INTO users(`id`,`name`,`password`,`email`,`birthday`)" +
                    "VALUES (5,'钱七','123456','qianqi@sina.com','1988-12-04')";
            int i=st.executeUpdate(sql);
            if(i>0){
                System.out.println("插入成功！");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            Jdbcutils.release(conn,st,rs);
        }
    }
}

增删改都只需要改变sql语句即可

查询语句

```java
package com.linfeng.Demo02.utils;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class ChaXun {
    public static void main(String[] args) {

        Connection conn=null;
        Statement st=null;
        ResultSet rs=null;

        //获取连接
        try {
            conn = Jdbcutils.getConnection();//要释放一个对象，把他提出来
            st=conn.createStatement();

            //sql
            String sql = "select * from users where id= 1";

           rs= st.executeQuery(sql);//查询完毕会返回一个结果集

            while (rs.next()){
                System.out.println(rs.getString("name"));
            }

        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            Jdbcutils.release(conn,st,rs);
        }

    }
}