使用JDBC连接Oracle数据库

importjava.sql.*;publicclassJDBCConn{privateStringurl=;privateStringusername=;privateStringpassword=;/***br方法说明：获得数据连接*br输入参数：*br返回类型：Connection连接对象*/publicConnectionconn(){try{//加载JDBC驱动Class.forName(oracle.jdbc.driver.OracleDriver);//创建数据库连接Connectioncon=DriverManager.getConnection(jdbc:oracle:thin:@127.0.0.1:1521:ORCL,test,test);returncon;}catch(ClassNotFoundExceptioncnf){System.out.println(drivernotfind:+cnf);returnnull;}catch(SQLExceptionsqle){System.out.println(can'tconnectiondb:+sqle);returnnull;}catch(Exceptione){System.out.println(FailedtoloadJDBC/ODBCdriver.);returnnull;}}/***br方法说明：执行查询SQL语句*br输入参数：Connectioncon数据库连接*br输入参数：Stringsql要执行的SQL语句*br返回类型：*/publicvoidquery(Connectioncon,Stringsql){try{if(con==null){thrownewException(databaseconnectioncan'tuse!);}if(sql==null)thrownewException(checkyourparameter:'sql'!don'tinputnull!);//声明语句Statementstmt=con.createStatement();//执行查询ResultSetrs=stmt.executeQuery(sql);ResultSetMetaDatarmeta=rs.getMetaData();//获得数据字段个数intnumColumns=rmeta.getColumnCount();while(rs.next()){for(inti=0;inumColumns;i++){StringsTemp=rs.getString(i+1);System.out.print(sTemp+);}System.out.println();}}catch(Exceptione){System.out.println(queryerror:+e);}}/***br方法说明：执行插入、更新、删除等没有返回结果集的SQL语句*br输入参数：Connectioncon数据库连接*br输入参数：Stringsql要执行的SQL语句*br返回类型：*/publicvoidexecute(Connectioncon,Stringsql){try{if(con==null)return;Statementstmt=con.createStatement();stmt.executeUpdate(sql);}catch(Exceptione){System.out.println(executeerror:sql=+sql);System.out.println(e);}}/***br方法说明：实例演示*br输入参数：*br返回类型：*/publicvoiddemo(){try{JDBCConnoc=newJDBCConn();Connectionconn=oc.conn();Stringsql=insertintoTBL_USER(id,name,password)values(seq_user.nextval,'switch','haorenpingan');oc.execute(conn,sql);sql=select*fromTBL_USER;oc.query(conn,sql);conn.close();}catch(SQLExceptionse){System.out.println(se);}catch(Exceptione){System.out.println(e);}}/***br方法说明：主方法*br输入参数：*br返回类型：*/publicstaticvoidmain(String[]arg){if(arg.length!=3){System.out.println(use:javaJDBCConnurlusernamepassword);return;}JDBCConnoc=newJDBCConn();oc.url=arg[0];oc.username=arg[1];oc.password=arg[2];oc.demo();}}