package com.commns.demo;
@SuppressWarnings("all")
public class User {
private Integer id;
private String name;
private Integer age;
private String address;
public User() {
super();
}
@Override
public String toString() {
return "User [id=" + id + ", name=" + name + ", age=" + age + ", address=" + address + "]";
}
public User(Integer id, String name, Integer age, String address) {
super();
this.id = id;
this.name = name;
this.age = age;
this.address = address;
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
}
package com.commns.demo;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
public class TestUser {
private static final String url="jdbc:mysql://localhost:3306/mybase";
private static final String user="root";
private static final String password="root";
public static void main(String[] args) {
Connection con = getConnctions();
PreparedStatement ps=null;
ResultSet rs=null;
List<User> array=new ArrayList<User>();
String sql="select * from user";
try {
ps = con.prepareStatement(sql);
rs = ps.executeQuery();
while(rs.next()) {
User user=new User(rs.getInt(1),rs.getString("sname"),rs.getInt(3),rs.getString("adderss"));
array.add(user);
}
getLists(array);
} catch (SQLException e) {
e.printStackTrace();
}
close(rs,ps,con);
}
/**
*打印数据
*/
private static void getLists(List<User> list) {
for (User user : list) {
// System.out.println(user);
System.out.println(user.getId()+user.getName()+user.getAge()+user.getAddress());
}
}
/**
* 关闭数据库
* @param ac
*/
public static void close(AutoCloseable... ac) {
for(AutoCloseable auto:ac) {
if(auto!=null) {
try {
auto.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
}
/**
* 获得jdbc的连接并返回
* @return
*/
public static Connection getConnctions() {
try {
Class.forName("com.mysql.jdbc.Driver");
return DriverManager.getConnection(url, user, password);
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
}