【JDBC学习笔记】之【快速入门——JDBC工具类的封装】

封装工具类

结构

代码

JDBCUtile

package cn.goktech.util;

import java.io.FileReader;
import java.net.URL;
import java.sql.*;
import java.util.Properties;

public class JDBCUtil {
    public static void main(String[] args) throws Exception {
        getConn();
    }

    /**
    * 获取连接的方法
    * @return
    * @throws Exception
    */
    public static Connection getConn() throws Exception {
        //读取配置文件，获取登录信息
        Properties properties=new Properties();

        //获取类加载器
        ClassLoader loader = JDBCUtil.class.getClassLoader();
        URL resource = loader.getResource("jdbc.properties");
        String path = resource.getPath();
        FileReader reader=new FileReader(path);

        properties.load(reader);//Reader
        String url = properties.getProperty("url");
        String username = properties.getProperty("username");
        String password = properties.getProperty("password");
        System.out.println(url+" "+username+" "+password);

        Class.forName("org.gjt.mm.mysql.Driver");

        //2.获取连接
        Connection connection = DriverManager.getConnection(url,username, password);
        return connection;
    }

    /**
    * 释放资源
    * @param rs
    * @param ps
    * @param connection
    */
    public static void close(ResultSet rs, Statement ps, Connection connection){
        //释放资源
        if (rs!=null){
            try {
                rs.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if (ps!=null){
            try {
                ps.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if (connection!=null){
            try {
                connection.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

    /**
    * 释放资源
    *
    * @param ps
    * @param connection
    */
    public static void close2(Statement ps, Connection connection){
        //释放资源
        if (ps!=null){
            try {
                ps.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if (connection!=null){
            try {
                connection.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

jdbc.properties

url=jdbc:mysql://192.168.8.46:3306/school?characterEncoding=utf8
username=root
password=123456

JDBC_05_Util_Test01_Query

package cn.goktech;

import cn.goktech.util.JDBCUtil;

import java.sql.*;

public class JDBC_05_Util_Test01_Query {
    public static void main(String[] args) {
        Connection connection = null;
        PreparedStatement ps = null;
        ResultSet rs = null;

        //1.注册驱动
        try {
            //调用方法返回连接对象
            connection = JDBCUtil.getConn();

            //2.创建SQL
            String sql = "select * from student";

            //3.创建通道
            ps = connection.prepareStatement(sql);

            //4.设置参数
            //5.执行SQL语句
            rs = ps.executeQuery();

            //6.处理结果集
            while (rs.next()) {
                int Sno=rs.getInt("Sno");
                String Sname= rs.getString("Sname");
                String Ssex= rs.getString("Ssex");
                int Sbirthday=rs.getInt("Sbirthday");
                int SClass=rs.getInt("SClass");

                System.out.print("学号: " + Sno);
                System.out.print("\t姓名: " + Sname);
                System.out.print("\t\t性别: " + Ssex);
                System.out.print("\t生日: " + Sbirthday);
                System.out.println("\t班级号" + SClass);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            JDBCUtil.close(rs, ps, connection);
        }
    }
}

JDBC_05_Util_Test01_DML

package cn.goktech;

import cn.goktech.util.JDBCUtil;
import java.sql.Connection;
import java.sql.Statement;

public class JDBC_05_Util_Test02_DML {
    public static void main(String[] args) {
        Connection conn=null;
        Statement st=null;

        try {
            //1.注册驱动+获取连接
            conn = JDBCUtil.getConn();

            //2.创建通道
            st= conn.createStatement();

            //3.sql
            String sql="insert into student values(110,'黄小明','男','1975-02-10 00:00:00','95031')";

            //4.执行SQL
            int i = st.executeUpdate(sql);
            System.out.println(i);

            //5.关闭连接
            JDBCUtil.close2(st,conn);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

测试

• 查询测试
  

• 插入测试