import java.sql.*;
//ResultSet
public class JDBCDEMO2 {
public static void main(String[] args) throws Exception {
//1.注册驱动
// Class.forName("com.mysql.cj.jdbc.Driver");
//2.获取连接
//如果连接的是本机的mysql服务器,并且mysql的默认端口号是3306,则url可以写为jdbc:mysql:///db1
String url="jdbc:mysql://127.0.0.1:3306/db1?serverTimezone=GMT&useSSL=false";
String name="root";
String password="20020630";
Connection connection = DriverManager.getConnection(url, name, password);
//3.定义sql
String sql="select * from account";
//4.获取执行sql的对象Statement
Statement statement = connection.createStatement();
//
ResultSet rs = statement.executeQuery(sql);
//处理结果
//光标向下移动一行,判断当前行是否有数据
while (rs.next()){
int id= rs.getInt(1);
//可以写列数,也可以写列名
String Name= rs.getString("name");
double money=rs.getDouble(3);
System.out.println(id);
System.out.println(Name);
System.out.println(money);
System.out.println("--------------");
}
}
}
将返回结果用List集合存储
新建一个student类
public class student {
private int id;
private String name;
private double money;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public double getMoney() {
return money;
}
public void setMoney(double money) {
this.money = money;
}
@Override
public String toString() {
return "student{" +
"id=" + id +
", name='" + name + '\'' +
", money=" + money +
'}';
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
//查询account账户表数据,封装为Account对象中
public class JDBCDEMO3 {
public static void main(String[] args) throws Exception {
//1.注册驱动
// Class.forName("com.mysql.cj.jdbc.Driver");
//2.获取连接
//如果连接的是本机的mysql服务器,并且mysql的默认端口号是3306,则url可以写为jdbc:mysql:///db1
String url="jdbc:mysql://127.0.0.1:3306/db1?serverTimezone=GMT&useSSL=false";
String name="root";
String password="20020630";
Connection connection = DriverManager.getConnection(url, name, password);
//3.定义sql
String sql="select * from account";
//
Statement statement = connection.createStatement();
//
List<student> list=new ArrayList<>();
ResultSet rs = statement.executeQuery(sql);
//处理结果
//光标向下移动一行,判断当前行是否有数据
while (rs.next()){
student s=new student();
int id= rs.getInt(1);
//可以写列数,也可以写列名
String Name= rs.getString("name");
double money=rs.getDouble(3);
s.setId(id);
s.setName(Name);
s.setMoney(money);
list.add(s);
}
System.out.println(list);
rs.close();
statement.close();
connection.close();
}
}