text02.java

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

package day01;

import java.sql.*;

public class Text02 {

	public static void main(String[] args) {
		String url = "jdbc:oracle:thin:@192.168.0.1:1521:tarena";
		String username = "openlab";
		String password = "open123";
		Connection con = null;
		Statement stmt = null;
		String sql = null;
		ResultSet rs = null;
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			// Driver drv= new oracle.jdbc.driver.OracleDriver();
			// DriverManager.deregisterDriver(drv);
			con = DriverManager.getConnection(url, username, password);
			stmt = con.createStatement();
			sql = "drop table stu_88";
			stmt.executeUpdate(sql);
			sql = "create table stu_88(name varchar(20),age number(8) not null)";
			stmt.executeUpdate(sql);
			sql = "insert into stu_88 values('zhangxun',20)";
			stmt.executeUpdate(sql);
			sql = "insert into stu_88 values('lijian',21)";
			stmt.executeUpdate(sql);
			sql = "select name, age from stu_88";
			rs = stmt.executeQuery(sql);
			StringBuffer sb = new StringBuffer();
			sb.append("**ResultSet**\n");
			sb.append("name		age\n");
			while (rs.next()) {
				sb.append(rs.getString(1) + "	");
				sb.append(rs.getInt(2) + "\n");
			}
			System.out.println(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 estmt) {
					estmt.printStackTrace();
				}
			}
			if (con != null) {
				try {
					con.close();
				} catch (Exception econ) {
					econ.printStackTrace();
				}
			}
		}
	}

}