Procedure java

public static void testProc(int iParam1, String iParam2, int [] oParam)
        throws SQLException {
    String connectionURL = "jdbc:default:connection";
    Connection conn = DriverManager.getConnection(connectionURL);
    String DML = "UPDATE TEST_TABLE SET NAME = ? WHERE ID = ?";
    PreparedStatement pstmnt = conn.prepareStatement(DML);
    pstmnt.setString(1, iParam2);
    pstmnt.setInt(2, iParam1);
    int updateRowcount = pstmnt.executeUpdate();
    oParam [0] = updateRowcount;
} // testProc()

Source: javacodegeeks.com

Similar codes

5 votes368 views2 answers
Write file from a specific location in java
Java
32 votes380 views6 answers
Bootstrap alert
Java
3 votes338 views1 answer
Java load .json file
Java
4 votes373 views5 answers
How to use while loop in java
Java
0 vote392 views1 answer
Cosinus-1 java
Java
-1 vote464 views2 answers
Plugin with id 'com.android.application' not found.
Java
2 votes392 views2 answers
How to set spinner value in android
Java
0 vote443 views1 answer
Spring-boot java header appliacation/json constant
Java Spring
0 vote364 views1 answer
Teimpo en segundos java
Java
0 vote409 views1 answer
Sum of a list using for loop in dart
Java