学习_Java_Base_JDBC_示例_(一)_02

这个是测试之前的连接数据库的类

package com.dbutil;

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

public class TestJdbcConnection {

	public void list() {
		DButil util = new DButil();
		Connection conn = util.getConnection();
		String sql = "select * from UserTbl";
		try {
			java.sql.Statement stmt = conn.createStatement();
			ResultSet rs = stmt.executeQuery(sql);
			while (rs.next()) {
				int id = rs.getInt("id");
				String username = rs.getString(2);
				String passwd = rs.getString(3);
				System.out.println(id + "  " + username + "   " + passwd);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			util.closeConnection(conn);
		}
	}

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		TestJdbcConnection test = new TestJdbcConnection();
		test.list();

	}

}