java遍历查询的某一列_java常用知识:jdbc的练习查询某个表将其封装为对象并遍历...

类

package domain;

import java.util.Date;

public class stu_emp {

private int id;

private String name;

private String gender;

private double salary;

private Date join_date;

private int dept_id;

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 String getGender() {

return gender;

}

public void setGender(String gender) {

this.gender = gender;

}

public double getSalary() {

return salary;

}

public void setSalary(double salary) {

this.salary = salary;

}

public Date getJoin_date() {

return join_date;

}

public void setJoin_date(Date join_date) {

this.join_date = join_date;

}

public int getDept_id() {

return dept_id;

}

public void setDept_id(int dept_id) {

this.dept_id = dept_id;

}

@Override

public String toString() {

return "stu_emp{" +

"id=" + id +

", name='" + name + '\'' +

", gender='" + gender + '\'' +

", salary=" + salary +

", join_date=" + join_date +

", dept_id=" + dept_id +

'}';

}

}

main

package jdbc;

import domain.stu_emp;

import java.io.Reader;

import java.sql.*;

import java.util.ArrayList;

import java.util.List;

public class test01jdbc {

public static void main(String[] args) {

List list = new test01jdbc().findAll();

System.out.println(list);

}

/**

* 查询所有stu_emp对象

*/

public List findAll(){

Connection conn =null;

Statement stat=null;

ResultSet rs=null;

List list = null;

try {

Class.forName("com.mysql.jdbc.Driver");

conn = DriverManager.getConnection("jdbc:mysql://服务器:端口/数据库名字", "账号", "密码");

String sql = "select * from stu_emp";

stat = conn.createStatement();

rs = stat.executeQuery(sql);

stu_emp emp = null;

list = new ArrayList<>();

while(rs.next()){

int id = rs.getInt("id");

String name = rs.getString("name");

String gender = rs.getString("gender");

double salary = rs.getDouble("salary");

Date join_date = rs.getDate("join_date");

int dept_id = rs.getInt("dept_id");

emp = new stu_emp();

emp.setId(id);

emp.setName(name);

emp.setGender(gender);

emp.setSalary(salary);

emp.setJoin_date(join_date);

emp.setDept_id(dept_id);

list.add(emp);

}

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}finally{

if(rs !=null){

try {

rs.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

if(stat !=null){

try {

stat.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

if(conn !=null){

try {

conn.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

return list;

}

}

分享到：