fff

package db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ResourceBundle;
import java.sql.Statement;

public class test2 {
	public static void main(String[] args) {
		// JDBC 对 DQL语句的操作
	new test2().jdbcDql();
	}

	ResourceBundle rb = ResourceBundle.getBundle("db.JDBC");
	String driver = rb.getString("driver");
	String url = rb.getString("url");
	String user = rb.getString("user");
	String pass = rb.getString("pass");

	public void jdbcDql() {
	
		// 1 -加载驱动
		try {
			Class.forName(driver);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		Connection conn = null;
		Statement st = null;
		ResultSet rs = null;
		String sql  =   "select  s_id,s_name,s_age,s_sex from student ";

		try {
			// 2获得链接
			conn = DriverManager.getConnection(url, user, pass);
			// 3 获得状态集
			st = conn.createStatement();
			// 4 执行DQL 返回结果集
			rs = st.executeQuery(sql);
			while (rs.next()) { 
				String sId =rs.getString(1);
				String sName  =rs.getString(2);
				String sAge =rs.getString(3);
				String sSex =rs.getString(4);
		//		String  sId = rs.getString("s_id");
//				String sName = rs.getString("s_name");
//				String sAge = rs.getString("s_age");
//				String  sSex = rs.getString("s_sex");
				System.out.println(sId + "" + sName + "" + sAge + "" + sSex);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally   {
			
			if (rs!=null)
			{
				try {
					rs.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				rs=null;
			}
			
			if  (st!=null) {
				try {
					st.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				st = null;}
				if (conn != null) {
				try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				conn = null;}
			
		}

	}
}