test.java

来自「java swing 和sql server 数据库做的 图书管理系统」· Java 代码 · 共 30 行

package bookmanager.bean;

import java.sql.ResultSet;
import java.sql.SQLException;

public class test {

	public static void main(String[] args) {
		String sql="select * from T_BOOKLIBRARY";
		DB oa = new DB();
		ResultSet rs;
		rs=oa.executeQuery(sql);
		try {
			while (rs.next()) {
				System.out.print(rs.getInt("ID")+"\t");
				System.out.print(rs.getString("NAME")+"\t");
				System.out.print(rs.getString("PRINCIPAL")+"\t");
				System.out.print(rs.getString("ADDRESS")+"\t");
				System.out.print(rs.getString("POSTCODE")+"\t");
			   System.out.println(rs.getString("PHONE"));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		oa.closeCon();
	}

}