连接oracle11g数据库的jdbc的查询操作



import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JdbcQuery {

	public static void main(String[] args) {
		ResultSet resul=null;
		Statement state=null;
		Connection conn=null;
		String url="jdbc:oracle:thin:@localhost:1521:orcl";
		String dirver="oracle.jdbc.driver.OracleDriver";
		String uname="scott";
		String pwd="tiger";
		//导入jar包
		try {
			//2加载驱动
			Class.forName(dirver);
			//3创建连接
			conn= DriverManager.getConnection(url,uname,pwd);
			conn.setAutoCommit(false);
			//4创建命令发送器（执行sql语句）
			state=conn.createStatement();
			//5根据命令发送器执行sql语句并接受结果集
			String str="SELECT * FROM EMP";
			resul=state.executeQuery(str);
			//6遍历结果
			while(resul.next()){
				System.out.println(