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

481 votes412 views10 answers
December global holidays
Java
0 vote265 views1 answer
The Google Mobile Ads SDK was initialized incorrectly. AdMob publishers
Java
1 vote242 views1 answer
How to download java on mint
Java
0 vote250 views1 answer
Location.href webview android studio
Java
3 votes319 views1 answer
How to make int array java android
Java
0 vote274 views1 answer
Java exception override message
Java
1 vote245 views1 answer
Java pointer
Java
1 vote278 views2 answers
Games
Java
-1 vote261 views1 answer
Gson parse json
Java
1 vote263 views1 answer
Load a file from classpath spring boot
Java