如何使用java对mysql数据库中的一行数据查询

1、以SYS用户登录，执行以下代码BeginDbms_Java.Grant_Permission('PSIID','java.io.FilePermission','<>','read,write,execute,delete');Dbms_java.grant_permission('PSIID','SYS:java.io.FilePermission','<>','读、写、执行、删除');Dbms_Java.Grant_Permission('PSIID','java.io.FilePermission','d:a.bat','读、写、执行考试,删除');dbms_java.grant_permission('PSIID','java.lang.RuntimePermission','*','writeFileDescriptor');end;2.登录用户psiid创建java程序资源createorreplaceandcompilejavasourcenamed"Util"asimportjava.io.*;importjava.lang.*;publicclassUtilextendedObject{publicstaticintRunThis(Stringargs){Runtimert=Runtime.getRuntime();intrc=-1;try{Processp=rt.exec(args);intbufSize=4096;BufferedInputStreambis=newBufferedInputStream(p.getInputStream(),bufSize);intlen;bytebuffer[]=newbyte[bufSize];//回显程序吐出的内容while((len=bis.read(buffer,0,bufSize))!=-1)System.out.write(buffer,0,len);rc=p.waitFor();}catch(Exceptione){e.printStackTrace();rc=-1;}finally{returnrc;}}}3.创建Java资源调用函数createorreplacefunctionRUN_CMD(p_cmdinvarchar2)returnnumberaslingujavaname'Util.RunThis(java.lang.String)returninteger';创建或替换procedureRUN(p_cmdinvarchar2)asxnumber;beginx:=run_cmd(p_cmd);end;------------------------------------执行示例--------------------------------d:a.bat文件cdd:rename%1%2SQL>execrc('d:a.batmytest.sqlb.sql');D:oracleora92DATABASE>cdd:D:>renamemytest.sqlb.sqlexec:x:=RUN_CMD('ipconfig');变量xnumber;execdbms_java.set_output(100000);exec:x:=RUN_CMD('ipconfig'))');exec:x:=RUN_CMD('d:a.bat');