oracl如果存在记录更新否则插入新纪录
//调用存储过程public static void main(String[] args) throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException {Class.forName("oracle.jdbc.driver.OracleDriver");// DriverManager.registerDriver(new net.sourceforge.jtds.jdbc.Driver());String dbUrl = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";Connection conn = java.sql.DriverManager.getConnection(dbUrl, "zhang", "password");String sql = "{call record_new_order(?)}";CallableStatement cs = conn.prepareCall(sql);cs.setInt(1,10);//cs.registerOutParameter(20, Types.INTEGER);cs.execute();// ResultSet rs = cs.executeQuery();// int k= rs.getMetaData().getColumnCount();// System.out.println(cs.getObject(2));// ResultSet rs = (ResultSet)cs.getObject(2);// while (rs.next()){// for (int i=1;i<k+1;i++){// System.out.print(rs.getObject(i)+"|");// }// System.out.println();// // }cs.close();conn.close();}