使用jdbc，查询数据库数据，并将其封装为对象输出

package cn.itcast.jdbc;

import cn.itcast.domain.User;

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

/**
 * @author newcityman
 * @date 2019/8/13 - 23:27
 */
public class JDBCDemo06 {

public static void main(String[] args) {
 JDBCDemo06 demo06 = new JDBCDemo06();
 demo06.findAll();
 }

public List<User> findAll() {
 Connection conn = null;
 Statement stmt = null;
 ResultSet rs = null;
 List<User> list = null;
 try {
 Class.forName("com.mysql.jdbc.Driver");
 conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/day13", "root", "123");
 stmt = conn.createStatement();
 String sql = "select * from user";
 rs = stmt.executeQuery(sql);
 list = new ArrayList<User>();
 User user = null;
 //遍历集合
 while (rs.next()) {
int id = rs.getInt("id");
 String username = rs.getString("username");
 String password = rs.getString("password");
 String sex = rs.getString("sex");
 Date birthday = rs.getDate("birthday");
 String hobbys = rs.getString("hobbys");
 String des = rs.getString("des");
 //封装对象
 user = new User();
 user.setId(id);
 user.setUsername(username);
 user.setPassword(password);
 user.setSex(sex);
 user.setBirthday(birthday);
 user.setHobbys(hobbys);
 user.setDes(des);
 //装载集合
 list.add(user);
 }
 System.out.println(list);
 } catch (ClassNotFoundException e) {
 e.printStackTrace();
 } catch (SQLException e) {
 e.printStackTrace();
 } finally {
if (rs != null) {
try {
 rs.close();
 } catch (SQLException e) {
 e.printStackTrace();
 }
 }
if (stmt != null) {
try {
 stmt.close();
 } catch (SQLException e) {
 e.printStackTrace();
 }
 }
if (conn != null) {
try {
 conn.close();
 } catch (SQLException e) {
 e.printStackTrace();
 }
 }
 }
return list;
 }
}

转载于:https://www.cnblogs.com/newcityboy/p/11349394.html