小试JDBC（mysql数据库）

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());
        }

    }
}