小试JDBC（mysql数据库）

来源：互联网发布：苹果耳机手绘淘宝编辑：程序博客网时间：2024/05/29 07:44
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());        }    }}
阅读全文
0 0