jdbc编写工具类并测试

1.工具类

package com.mahui.Lesson02.utils;
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 {
   
            //加载配置文件
            //获得一个input流
            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);
    }
    //释放资源
    public static  void release(Connection coon,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(coon!=null){
   
            try {
   
                coon.close();
            } catch (SQLException e) {
   
                e.printStackTrace();
            }
        }
    }

}

2.测试

1. statement对象

1.增加

package com.mahui.Lesson02;

import com.mahui.Lesson02.utils.jdbcUtils;

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

public class TestInsert {
   

    public static void main(String[] args) {
   
        Connection conn =null;
        Statement st=null;
        ResultSet rs=null;
        try {
   
            conn= jdbcUtils.getConnection();
            String sql="INSERT INTO users(`id`,`NAME`,`PASSWORD`,`email`,`birthday`)" +
                    "VALUES (4,'哈士奇','124563','12354552@qq.com','2020-02-01')";
            st=conn.createStatement();
            int i = st.executeUpdate(sql);
            if(i