package com.itbinge.example;
import com.alibaba.druid.pool.DruidDataSourceFactory;
import com.itbinge.pojo.Brand;
import javax.sql.DataSource;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import java.util.Properties;
/**
* 品牌数据的增删改查操作
*/
public class BrandTest {
/**
* 查询所有
* 1.sql:select * from tb_brand;
* 2.参数:无
* 3.结果:List<Brand>
*
*/
public static void main(String[] args) throws Exception {
//获取连接Connection
//加载配置文件
Properties prop = new Properties();
prop.load(new FileInputStream("src/druid.properties"));
DataSource dataSource = DruidDataSourceFactory.createDataSource(prop);
Connection conn = dataSource.getConnection();
//定义sql语句
String sql="select * from tb_brand;";
//获取pstmt对象
PreparedStatement pstmt = conn.prepareStatement(sql);
//设置参数
//执行sql
ResultSet rs = pstmt.executeQuery();
//处理结果List<Brand> -- 封装Brand对象,装载List集合
Brand brand = null;
List<Brand> list = new ArrayList<>();
while(rs.next()){
//获取对应数据
int id = rs.getInt("id");
String brandName = rs.getString("brand_name");
String companyName = rs.getString("company_name");
int ordered = rs.getInt("ordered");
String description = rs.getString("description");
int status = rs.getInt("status");
//封装Brand
brand = new Brand();
brand.setId(id);
brand.setBrandName(brandName);
brand.setCompanyName(companyName);
brand.setOrdered(ordered);
brand.setDescription(description);
brand.setStatus(status);
//装载List集合
list.add(brand);
}
System.out.println(list);
//释放资源
rs.close();
pstmt.close();
conn.close();
}
}
JDBC练习--查询所有
最新推荐文章于 2024-07-18 15:45:25 发布