JDBC实现文本信息连接

JDBC实现文本信息连接

声明:时间关系整理仓促注释不全JDBC详细基础请查看上一篇

1.创建dbinfo.Properties文本

driverClass=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/myjdbc
user=root
password=123456

2.创建JBDC文本读取类

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ResourceBundle;

public class JDBCUtil {
    private static String driverClass;
    private static String url;
    private static String user;
    private static String password;
    //使用静态代码块加载驱动 读取配置文件
    static {
        //使用系统类来读取配置文件
        ResourceBundle rb = ResourceBundle.getBundle("dbinfo");
        //获取文件中的数据
        driverClass=rb.getString("driverClass");
        url=rb.getString("url");
        user=rb.getString("user");
        password=rb.getString("password");



        //利用集合读取文件
//      Properties properties = new Properties();
//      FileInputStream fis = null;
//      try {
//          fis = new FileInputStream("src/dbinfo.properties");
//      } catch (FileNotFoundException e) {
//          // TODO Auto-generated catch block
//          e.printStackTrace();
//      }
//      try {  
//          properties.load(fis);
//          //读文件
//          driverClass=properties.getProperty("driverClass");
//          url=properties.getProperty("url");
//          user=properties.getProperty("user");
//          password=properties.getProperty("password");
//          
//      } catch (IOException e) {
//          // TODO Auto-generated catch block
//          e.printStackTrace();
//      }

    }

    //获取数据库连接数据库方法
    //如果没有结果集需要关闭 直接传空就行
    public static Connection getConnection() throws SQLException{
        //让驱动加载一次
         try {
            Class.forName(driverClass);
        } catch (ClassNotFoundException e) {

            e.printStackTrace();
        }
         return DriverManager.getConnection(url,user,password);
    }
    //关闭数据库方法
    public  static void closeAll(ResultSet resultSet,
            Statement statement,Connection connection) {

                //关闭资源前判断是否为空 防止空指针出现
                if (resultSet != null) {
                    try {
                        resultSet.close();
                    } catch (Exception e2) {
                        throw new RuntimeException("关闭失败");
                    }
                    //加快系统回收速度
                    resultSet = null;
                }
                if (statement != null) {
                    try {
                        statement.close();
                    } catch (Exception e2) {
                        throw new RuntimeException("关闭失败");
                    }
                    //加快系统回收速度
                    statement = null;
                }
                if (connection != null) {
                    try {
                        connection.close();
                    } catch (Exception e2) {
                        throw new RuntimeException("关闭失败");
                    }
                    //加快系统回收速度
                    connection = null;
                }

    }
}

3.创建用户类

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

import org.junit.jupiter.api.Test;

/*
 * 测试类
 */
public class TextJDBCtil {
      @Test
      public void testSelect() {
        Connection connection = null;
        ResultSet resultSet = null;
        Statement statement = null;
        try {
            //获取连接
            connection = JDBCUtil.getConnection();
            statement = connection.createStatement();
            String sql = "select * from users";
             resultSet = statement.executeQuery(sql);
             ArrayList<User> list = new ArrayList<>();
            while(resultSet.next()) {
                //创建user对象
                User user = new User();
                user.setId(resultSet.getInt("id"));;
                user.setName(resultSet.getString("name"));
                user.setPassword(resultSet.getString("password"));
                user.setBirthday(resultSet.getDate("birthday"));
                user.setEmail(resultSet.getString("email"));
                //放入集合中
                list.add(user);
            }
            //遍历查看
            for(User user : list) {
                System.out.println(user);
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }finally {
            //关闭资源
            JDBCUtil.closeAll(resultSet, statement, connection);
        }
    }
}

4.创建JDBC测试类

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

import org.junit.jupiter.api.Test;

/*
 * 测试类
 */
public class TextJDBCtil {
      @Test
      public void testSelect() {
        Connection connection = null;
        ResultSet resultSet = null;
        Statement statement = null;
        try {
            //获取连接
            connection = JDBCUtil.getConnection();
            statement = connection.createStatement();
            String sql = "select * from users";
             resultSet = statement.executeQuery(sql);
             ArrayList<User> list = new ArrayList<>();
            while(resultSet.next()) {
                //创建user对象
                User user = new User();
                user.setId(resultSet.getInt("id"));
                user.setName(resultSet.getString("name"));
                user.setPassword(resultSet.getString("password"));
                user.setBirthday(resultSet.getDate("birthday"));
                user.setEmail(resultSet.getString("email"));
                //放入集合中
                list.add(user);
            }
            //遍历查看
            for(User user : list) {
                System.out.println(user);
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }finally {
            //关闭资源
            JDBCUtil.closeAll(resultSet, statement, connection);
        }
    }
}