1 21 package org.apache.derbyTesting.functionTests.util; 22 23 import java.sql.Date ; 24 import java.sql.Time ; 25 import java.sql.Timestamp ; 26 27 30 31 public class SimpleProcedureTest { 32 33 36 37 public static void pmap(short in, short[] inout, short[] out) { 38 39 inout[0] += 6; 40 out[0] = 77; 41 } 42 public static void pmap(int in, int[] inout, int[] out) { 43 inout[0] += 9; 44 out[0] = 88; 45 46 } 47 public static void pmap(long in, long[] inout, long[] out) { 48 inout[0] += 8; 49 out[0] = 99; 50 } 51 public static void pmap(float in, float[] inout, float[] out) { 52 inout[0] += 9.9f; 53 out[0] = 88.8f; 54 } 55 public static void pmap(double in, double[] inout, double[] out) { 56 inout[0] += 3.9; 57 out[0] = 66.8; 58 } 59 public static void pmap(byte[] in, byte[][] inout, byte[][] out) { 60 61 inout[0][2] = 0x56; 62 out[0] = new byte[4]; 63 out[0][0] = (byte) 0x09; 64 out[0][1] = (byte) 0xfe; 65 out[0][2] = (byte) 0xed; 66 out[0][3] = (byte) 0x02; 67 68 } 69 public static void pmap(Date in, Date [] inout, Date [] out) { 70 71 inout[0] = java.sql.Date.valueOf("2004-03-08"); 72 out[0] = java.sql.Date.valueOf("2005-03-08"); 73 74 } 75 public static void pmap(Time in, Time [] inout, Time [] out) { 76 inout[0] = java.sql.Time.valueOf("19:44:42"); 77 out[0] = java.sql.Time.valueOf("20:44:42"); 78 } 79 public static void pmap(Timestamp in, Timestamp [] inout, Timestamp [] out) { 80 81 inout[0] = java.sql.Timestamp.valueOf("2004-03-12 21:14:24.938222433"); 82 out[0] = java.sql.Timestamp.valueOf("2004-04-12 04:25:26.462983731"); 83 } 84 public static void pmap(String in, String [] inout, String [] out) { 85 inout[0] = inout[0].trim().concat("P2-PMAP"); 86 out[0] = "P3-PMAP"; 87 } 88 89 } 90 | Popular Tags |