产品展示 Dynamic News
上海莫尔丽信息科技有限公司 > 产品展示 >

JDBC链接Oracle参考代码
发布于2025-02-19 17:38 文章作者:尔晴
packagecom.gr.util;importjava.sql.CallableStatement;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.Types;publicclassConnectionManager{publicstaticvoidmain(String[]args){try{Class.forName("oracle.jdbc.driver.OracleDriver");Stringurl="jdbc:oracle:thin:@localhost:1521:cui";Connectionconn=DriverManager.getConnection(url,"cui","cui");System.out.println("链交乐成:"+conn.toString());conn.setAutoCommit(true);//建立主动提接//挪用带参数有前往值的保存进程//注重那里参数的地位战类别必需战保存进程里界说的分歧,输入参数停止立案,而输出参数停止赋值CallableStatementcstmp=conn.prepareCall("{callinsert_class(?,?)}");cstmp.registerOutParameter(1,Types.INTEGER);cstmp.setString(2,"保存进程组");cstmp.execute();//不前往值//cstmp.executeUpdate();intnewId=cstmp.getInt(1);System.out.println(newId);//查问,带有分页语句Stringsql_select="SELECT*FROM(SELECTA.*,ROWNUMRNFROM(SELECT*FROMclasses)AWHEREROWNUM<=?)WHERERN>=?";PreparedStatementpstmt_sel=conn.prepareStatement(sql_select);pstmt_sel.setInt(1,4);pstmt_sel.setInt(2,3);ResultSetrs=pstmt_sel.executeQuery();while(rs.next()){System.out.println(rs.getInt("id")+""+rs.getString("classname"));}//填补Stringsql_insert="insertintoclassesvalues(class_seq.nextval,?)";PreparedStatementpstmt_add=conn.prepareStatement(sql_insert);pstmt_add.setString(1,"JDBC尝试");intresult_insert=pstmt_add.executeUpdate();System.out.println(result_insert);//节减Stringsql_delete="deletefromclasseswhereid=?";PreparedStatementpstmt_del=conn.prepareStatement(sql_delete);pstmt_del.setInt(1,6);intresult_delete=pstmt_del.executeUpdate();System.out.println(result_delete);//修正Stringsql_update="updateclassessetclassname=?whereid=?";PreparedStatementpstmt_mod=conn.prepareStatement(sql_update);pstmt_mod.setString(1,"FBI组");pstmt_mod.setInt(2,7);intresult_update=pstmt_mod.executeUpdate();System.out.println(result_update);}catch(Exceptione){e.printStackTrace();}}}
以上代码仅供参照
推举您浏览更多相关于“ jdbcoraclesql拜候保存进程 ”的著作