java 中list集合遍历数据库内容关于bean 的 sat get方法

最新推荐文章于 2024-05-05 12:58:56 发布

小生有礼了_志石

最新推荐文章于 2024-05-05 12:58:56 发布

阅读量3.5k

点赞数

分类专栏： java 文章标签：数据库遍历 bean list JDBC

本文链接：https://blog.csdn.net/M1059185159/article/details/39151571

版权

java 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

首先建立一个bean：

public class Stu

{
private int id;
private String name;
private int age;
private String Email;
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 int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
public String getEmail() {
return Email;
}
public void setEmail(String email) {
Email = email;
}

}

建立数据库连接：

package com.conn.util;

import java.sql.Connection;
import java.sql.DriverManager;

public class ConnectionUtil {
public static Connection getconn() {
try {
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/test", "root", "111");
return conn;
} catch (Exception e) {
return null;
}
}

}

得到数据库内容：

public class DaoIMPL {
public List listquery() {
Connection conn = ConnectionUtil.getconn();
Statement st = null;
ResultSet rs = null;
try {
st = conn.createStatement();
rs = st.executeQuery("SELECT * FROM stu");
List list = new ArrayList();
while (rs.next()) {
Stu s = new Stu();
String name = rs.getString("name");
int age = rs.getInt("age");
String Email = rs.getString("Email");
System.out.print(name);
System.out.print(age);
System.out.println(Email);
s.setAge(age);
s.setEmail(Email);
s.setName(name);
list.add(s);

}
return list;
} catch (Exception e) {
// TODO: handle exception
System.out.println("添加失败");
return null;
} finally {
try {
rs.close();
st.close();
conn.close();
} catch (Exception e2) {
// TODO: handle exception
}
}
}

遍历list集合的内容：

第一种：

使用for循环：

public static void main(String[] args) {
DaoIMPL d=new DaoIMPL();
List list = d.listquery();
for(int i=0;i<list.size();i++){
Stu s=(Stu) list.get(i);

System.out.println(s.getName());

System.out.println(s.getAge());

System.out.println(s.getEmail());

}

第二种添加泛型：

public class DaoIMPL{

public List<Stu> listquery() {
Connection conn = ConnectionUtil.getconn();
Statement st = null;
ResultSet rs = null;
try {
st = conn.createStatement();
rs = st.executeQuery("SELECT * FROM stu");
ArrayList<Stu> list = new ArrayList<Stu>();
while (rs.next()) {
Stu s = new Stu();
String name = rs.getString("name");
int age = rs.getInt("age");
String Email = rs.getString("Email");
System.out.print(name);
System.out.print(age);
System.out.println(Email);
s.setAge(age);
s.setEmail(Email);
s.setName(name);
list.add(s);

}
return list;
} catch (Exception e) {
// TODO: handle exception
System.out.println("添加失败");
return null;
} finally {
try {
rs.close();
st.close();
conn.close();
} catch (Exception e2) {
// TODO: handle exception
}
}