java中的QueryRunner的8种结果集的实现方法

定义Sort类

	public Sort() {
		super();
		// TODO Auto-generated constructor stub
	}
	public Sort(int uid, String uname, String uaddress, String tel) {
		super();
		this.uid = uid;
		this.uname = uname;
		this.uaddress = uaddress;
		this.tel = tel;
	}
	public int getUid() {
		return uid;
	}
	public void setUid(int uid) {
		this.uid = uid;
	}
	public String getUname() {
		return uname;
	}
	public void setUname(String uname) {
		this.uname = uname;
	}
	public String getUaddress() {
		return uaddress;
	}
	public void setUaddress(String uaddress) {
		this.uaddress = uaddress;
	}
	public String getTel() {
		return tel;
	}
	public void setTel(String tel) {
		this.tel = tel;
	}
	@Override
	public String toString() {
		return "Sort [uid=" + uid + ", uname=" + uname + ", uaddress=" + uaddress + ", tel=" + tel + "]";
	}
}

定义databaseproperties文件

driverClass=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/shujuku
username=root
password=***

创建数据库连接对象

package jdbcuitl;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
impo