MySQL-数据表数据存储对象

package demo4;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import JDBCUtil.JDBCUtils;
import demo4.domain.Sort;

/*
 * JDBC读取数据表sort,每行数据封装到Sort类的对象中
 * 很多个Sort类对象,存储到集合中
 */
public class JDBCDemo {
	public static void main(String[] args) throws SQLException {
		// 原来的大量代码现在只有这些
		Connection con = JDBCUtils.getconnConnection();
		PreparedStatement pst = con.prepareStatement("select * from `sort`;");
		ResultSet rs = pst.executeQuery();

		// 创建集合对象存储Sort对象
		List<Sort> list = new ArrayList<Sort>();

		while (rs.next()) {
			// 直接把数据存储到sort对象中
			Sort s = new Sort(rs.getInt("id"), rs.getString("name"),
					rs.getInt("sprice"), rs.getString("sdesc"));
			// 把sort对象储存到集合对象中
			list.add(s);
		}
		// 增强for 输出list集合对象sort
		for (Sort s : list) {
			System.out.println(s);
		}

		JDBCUtils.close(con, pst);
	}
}

sort方法

package demo4.domain;

public class Sort {
	private int id;
	private String name;
	private int sprice;
	private String sdesc;

	public Sort() {
	}

	public Sort(int id, String name, int spricce, String sdesc) {
		this.id = id;
		this.name = name;
		this.sprice = spricce;
		this.sdesc = sdesc;
	}

	@Override
	public String toString() {
		return "Sort [id=" + id + ", name=" + name + ", spricce=" + sprice
				+ ", sdesc=" + sdesc + "]";
	}

	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 getSpricce() {
		return sprice;
	}

	public void setSpricce(int spricce) {
		this.sprice = spricce;
	}

	public String getSdesc() {
		return sdesc;
	}

	public void setSdesc(String sdesc) {
		this.sdesc = sdesc;
	}

}

输出结果,没有美化..