使用JDBC完成数据库的查询

1、修改增加里面的内容然后实现对数据库里面信息得查询，粉红颜色的为新增加的内容

2、创建一个FindAll的java类进行测试

//完成对数据库的增删改查
package dao;

import qqq.JDBCUtils;
import qqq.User;

import java.sql.*;
import java.text.SimpleDateFormat;
import java.util.ArrayList;

public class UsersDao {
    //提供一个添加方法
    public  boolean insert(User user){
        Connection conn=null;
        Statement stmt=null;
        ResultSet rs=null;
        try{
            //获取数据的连接
            conn=JDBCUtils.getConnection();
            //获取Statement对象
            stmt=conn.createStatement();
            //发送Sql语句
            SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
            String birthday=sdf.format(user.getBirthday());

            String sql="insert into users(id,name,password,email,birthday)"+
                    "values ('"
                    + user.getId()       +"','"
                    + user.getUsername() +"','"
                    + user.getPassword() +"','"
                    + user.getEmail()    +"','"
                    +birthday            +"')";
            int num=stmt.executeUpdate(sql);
            if (num>0){
                return true;
            }
            return false;

        }catch (Exception e) {
            e.printStackTrace();

        }finally {
            JDBCUtils.release(rs,stmt,conn);
        }
        return false;

    }
    //查询所有的User对象
    public ArrayList<User> findAll(){
        Connection conn=null;
        Statement stmt=null;
        ResultSet rs=null;
        ArrayList<User> list= new ArrayList<>();
        try{
            //获得数据的连接
            conn=JDBCUtils.getConnection();
            //获取Statement对象
            stmt=conn.createStatement();
            //发送SQL语句
            String sql="select*from users";
            rs=stmt.executeQuery(sql);
            //处理结果集
            while(rs.next()){
                User user=new User();
                user.setId(rs.getInt("id"));
                user.setUsername(rs.getString("name"));
                user.setPassword(rs.getString("password"));
                user.setEmail(rs.getString("email"));
                user.setBirthday(rs.getDate("birthday"));
                list.add(user);

            }
            return list;
        } catch (SQLException | ClassNotFoundException e) {
            e.printStackTrace();
        }finally {
            JDBCUtils.release(rs,stmt,conn);
        }
        return null;
    }

}

//进行测试

import dao.UsersDao;
import qqq.User;

import java.util.ArrayList;

public class FindAllUsersTest {
    public static void main(String args[]){
       //创建一个名称为userDao的对象
        UsersDao usersDao=new UsersDao();
        //将UsersDao对象的findAll()方法执行后的结果放入到list集合
        ArrayList<User> list=usersDao.findAll();
        //x循环输出集合中的数据
        for(int i=0;i<list.size();i++){
            System.out.println("第"+(i+1)+"条数据的username值为:"
            +list.get(i).getUsername()
            );
        }
    }
}

数据库里面的内容

查询的结果