jdbcdemo.java

软通公司培训的课件和习题里面有答案。。。

package com.ten.jdbc;

import java.sql.*;


public class JdbcDemo {
	
	public JdbcDemo(){	
	}
	
	public static void main(String[] args) {
		
		Connection conn = null ;
		Statement stmt = null ;
		ResultSet rs = null ;
		
		String url = "jdbc:oracle:thin:@127.0.0.1:1521:stan" ;
		String username = "stan";
		String password = "stan";
		String sql = "" ;
		
		try {
			// 1 注册，加载Oacle驱动程序
			DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
			
			// 2 建立连接
			conn = DriverManager.getConnection(url,username,password);
			
			// 3 创建 Statement 对象
			stmt = conn.createStatement();
			
			// 4 执行指定的sql语句
			sql = " select empno,ename,sal from emp " ;
			rs = stmt.executeQuery(sql);
			
			// 5 获取结果集中的数据
			while(rs.next()){
				int no = rs.getInt("empno");
				String name = rs.getString("ename");
				Double sal = rs.getDouble("sal");
				System.out.println("EmpNo: "+no+ "     EmpName: "+name+"     Salery: "+sal);
			}
			
		} catch (SQLException e) {
			e.printStackTrace();
			
		}finally{
			try {
				// 6 关闭数据库所有的连接
				rs.close();
				stmt.close();
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}

}