jdbc的建立步骤

package com.sxt;




import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;




public class TesstJdbc {
	// 准备工作
	// orcle的驱动路径
	public static final String drivername = "oracle.jdbc.driver.OracleDriver";
	// oracle的网络位置
	public static final String url = "jdbc:oracle:thin:@localhost:1521:orcl";
	// 账号密码
	public static final String username = "scott";
	public static final String password = "tiger";
	public static void main(String[] args) throws ClassNotFoundException, SQLException {
	// 利用反射把驱动加载到drivermanager
	Class.forName(drivername);
	// 创建连接
	Connection con = DriverManager.getConnection(url, username, password);
	// 创建数据对象
	Statement sm = con.createStatement();
	String s = "select * from emp";
	String s1="update mybook set btype=2 where bid=1";
	String s2 ="delete from mybook where bid=1";
	String s3="insert into mybook values(sq1.nexval,'三体',1)";
	// 发送sql语句，返回结果集对象
	ResultSet rs = sm.executeQuery(s);
	//增删改返回的是影响的行数
	int i = sm.executeUpdate(s3);
	System.out.println("影响的行数是"+i);
	// 循环输出
	while (rs.next()) {
	//System.out.println(rs.getInt("empno") + "  ---" + rs.getString("ename"));
	System.out.println(rs.getObject(1) + "  ---" + rs.getString("ename"));		
	}
	// 关闭连接
	con.close();
	}
}