lab3.java

来自「这个适用于初学者,JDBC连接MYSQL,这些是JDBC一些测试程序」· Java 代码 · 共 49 行

package jdbc;
import java.sql.*;
public class Lab3 {
//做查询
//处理结果结集
//ResultSet
	
		public static void main(String[] args) {
			Connection con=null;
			Statement stmt=null;
			ResultSet rs=null;
			
			try{
				
				String driverName=
					"oracle.jdbc.driver.OracleDriver";
				Class.forName( driverName);
				
				String url=
					"jdbc:oracle:thin:@192.168.2.125:1521:stu";
				String username="openlab";
				String pwd="open123";
				con=DriverManager.getConnection( url,username,pwd);
				
				//3.创建statement对象
				stmt=con.createStatement() ;
				
				//4.查询数据库
				String sql="select * from wen7_23";
				rs=stmt.executeQuery( sql);
				System.out.println("rs->"+rs);
//				5.处理结果集
				StringBuffer sb=new StringBuffer();
				while(rs.next() ){
					sb.append( "id="+rs.getInt( 1)+"   ");
					sb.append( "name="+rs.getString( 2)+"\n");
				}
				System.out.println(sb.toString() ) ;
			}catch(Exception e){
				e.printStackTrace() ;
			}finally{
				if(rs!=null)try {rs.close() ;} catch (Exception e) {}
				if(stmt!=null)try {stmt.close() ;} catch (Exception e1) {}
				if(con!=null)try {con.close() ;} catch (Exception e2) {}
			}
			}
}