lab12.java

加拿大达内科技有限公司配需java程序员的上课时的代码

package day03;

import java.sql.*;

public class Lab12 {

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		Connection con = null;
		ResultSet rs = null;
		Statement stmt = null;
		String url = "jdbc:oracle:thin:@192.168.0.1:1521:tarena";
		String username = "openlab";
		String password = "open123";
		String sql = null;
		try {
			Driver drv = new oracle.jdbc.driver.OracleDriver();
			DriverManager.registerDriver(drv);
			con = DriverManager.getConnection(url, username, password);
			stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
					ResultSet.CONCUR_UPDATABLE);
			sql = "create table xun4(studentId number(8) primary key,name varchar2(20) not null)";
			stmt.executeUpdate(sql);
			sql = "insert into xun4 values(1,'zhang')";
			stmt.executeUpdate(sql);
			sql = "insert into xun4 values(2,'li')";
			stmt.executeUpdate(sql);
			sql = "insert into xun4 values(3,'yang')";
			stmt.executeUpdate(sql);
			sql = "select * from xun4";
			rs = stmt.executeQuery(sql);
			StringBuffer sb = new StringBuffer();
			sb.append("　　结果集：\n");
			sb.append("studentId	Name\n");
			while (rs.next()) {
				sb.append(rs.getInt(1) + "		");
				sb.append(rs.getString(2) + "\n");
			}
			System.out.print(sb);
			
			
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			if (rs != null) {
				try {
					rs.close();
				} catch (Exception ers) {
					ers.printStackTrace();
				}
			}

			if (stmt != null) {
				try {
					stmt.close();
				} catch (Exception ex) {
					ex.printStackTrace();
				}
			}
			if (con != null) {
				try {
					con.close();
				} catch (Exception ee) {
					ee.printStackTrace();
				}
			}
		}
	}
}