text.java

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

package day01;

import java.sql.*;

public class Text {

	public static void main(String[] args) {
		Connection con = null;
		String url = "jdbc:oracle:thin:@192.168.0.1:1521:tarena";
		String username = "openlab";
		String password = "open123";
		Statement stmt = null;
		String sql = null;
		ResultSet rs = null;
		try {
			// Class.forName("oracle.jdbc.driver.OracleDriver");
			Driver drv = new oracle.jdbc.driver.OracleDriver();
			DriverManager.registerDriver(drv);
			// 1.加载驱动 2.建立连接
			con = DriverManager.getConnection(url, username, password);
			// 3.取得statement对象
			stmt = con.createStatement();
			// 4.操作数据
			sql = "drop table xun";
			stmt.executeUpdate(sql);
			sql = "create table xun(studentId number(8) primary key,name varchar2(20) not null)";
			stmt.executeUpdate(sql);
			sql = "insert into xun values(1,'zhang')";
			stmt.executeUpdate(sql);
			sql = "insert into xun values(2,'li')";
			stmt.executeUpdate(sql);
			sql = "insert into xun values(3,'yang')";
			stmt.executeUpdate(sql);
			// 5.执行查询语句，获取ResuleSet对象
			sql = "select * from xun";
			rs = stmt.executeQuery(sql);
			//6.遍历已经获取的结果集，释放数据库资源
			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();
				}
			}
		}
	}
}