JDBC六步骤

//1 注册数据库驱动 
	Class.forName("oracle.jdbc.driver.OracleDriver");
	//2 获取数据库连接
	Connection conn = 
    DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","hr","123");
	//3 获取Statement
	Statement s = conn.createStatement();
	//4 编写sql语句 并 执行
	String sql = "select first_name,last_name,salary from employees";
	rs = s.executeQuery(sql); 
	//5 遍历结果集(执行的sql语句如果是查询语句  才需要做这个操作)
			while(rs.next()){
				count++;
				// rs.get类型(查询结果中的第几列)
				String fn = rs.getString(1);
				String ln = rs.getString(2);
				double sal = rs.getDouble(3);
				System.out.println(fn+"\t"+ln+"\t"+sal);
			}
	//6 关流
	conn.close();
	statement.close();
	rs.close();