package cn.itcast.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import java.util.concurrent.locks.StampedLock;
import cn.itcast.domain.Users;
//查询出所有的记录 打印到控制台上
public class JDBCDemo3 {
public static void main(String[] args) throws SQLException {
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/day14", "root", "gqcmysql");//url 不同数据库不同 具体看数据库说明
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select id,name,password,email,birthday from users");
List<Users> users=new ArrayList<Users>();
; while(rs.next()) {
System.out.println("----------");
/* System.out.println(rs.getObject("id"));
System.out.printl
查询所有记录打印到控制台上2
最新推荐文章于 2020-05-27 19:13:23 发布