package com.jdbc; import com.domain.User; import com.mysql.jdbc.Driver; import java.sql.*; import java.util.ArrayList; import java.util.Iterator; import java.util.List; public class JdbcDemo { public static void main(String[] args) throws SQLException { //1.注册驱动 DriverManager.registerDriver(new Driver()); //2.获取与数据库的链接 Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/world", "root", "admin"); //3.创建代表SQL语句的对象 Statement statement = connection.createStatement(); //4.执行SQL语句 ResultSet resultSet = statement.executeQuery("SELECT * FROM users"); List<User> users=new ArrayList<User>(); //5.如果是查询语句,返回结果集 //将结果集存入JAVABEAN的列表中 while (resultSet.next()){ User user=new User(); user.setId(resultSet.getInt("id")); user.setName(resultSet.getString("name")); user.setPassword(resultSet.getString("password")); user.setEmail(resultSet.getString("email")); user.setBirthday(resultSet.getDate("birthday")); users.add(user); } //6.释放资源 resultSet.close(); statement.close(); connection.close(); //遍历列表 Iterator<User> iterator = users.iterator(); while (iterator.hasNext()){ System.out.println(iterator.next()); } } }
小试JDBC(mysql数据库)
最新推荐文章于 2021-06-18 15:15:28 发布