querydata.java

来自「远程电子考试系统」· Java 代码 · 共 40 行

package dbconnect;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class QueryData {

	/**
	 * @param args
	 * @throws SQLException 
	 */
	public static void main(String[] args) throws SQLException {
		// TODO 自动生成方法存根
		Statement stmt;
		ResultSet rs;
		String limit_time, number;
		
		DbConnect dbcon=new DbConnect();
		dbcon.connect();
		 stmt=(dbcon.getConnction()).createStatement();
			rs = stmt.executeQuery("select limit_time,total_num from test_paper" +
					" where test_name='java 知识测试'");
			// 下面开始遍历结果集
			while (rs.next()) { // 游标象后移动
				limit_time = rs.getString("limit_time");
				number = rs.getString("total_num");
				System.out.println("时间限制");
				System.out.println( limit_time);
				System.out.println("试题数量");
				System.out.println(number);
			}

	dbcon.disconnect();

	}
}