package com.imooc.jdbc.goodsapp;

import com.alibaba.druid.pool.DruidDataSourceFactory;
import com.imooc.jdbc.common.DbUtils;

import javax.sql.DataSource;
import java.io.FileInputStream;
import java.net.URLDecoder;
import java.sql.*;
import java.util.Properties;

public class DruidQueryDemo {
    public static void main(String[] args) {
        /*1.加载配置文件*/
        Properties properties = new Properties();
        String propertyFile = DruidQueryDemo.class.getResource("/druid-config.properties").getPath();
        try {
            propertyFile = URLDecoder.decode(propertyFile, "UTF-8");
            properties.load(new FileInputStream(propertyFile));
        } catch (Exception e) {
            e.printStackTrace();
        }

        Connection conn = null;
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        try {
            /*2.获取DataSource数据源对象*/
            DataSource dataSource = DruidDataSourceFactory.createDataSource(properties);
            /*3.创建数据库连接*/
            conn = dataSource.getConnection();
            pstmt = conn.prepareStatement("select * from goods");
            rs = pstmt.executeQuery();
            /*4.遍历查询结果*/
            while (rs.next()) {
                Integer id = rs.getInt("id");
                String name = rs.getString("name");
                Float price = rs.getFloat("price");
                String desp = rs.getString("desp");
                Date create_date = rs.getDate("create_date");
                System.out.println(id + " " + name + " " + price + " " + desp + " " + create_date);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            /*5.将连接回收到连接池*/
            DbUtils.closeConnection(rs, pstmt, conn);
        }
    }
}