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

0 vote397 views1 answer
Check authorities spring
Java Spring
0 vote349 views2 answers
Raspberry stackexchange how to install the java jdk
Java
0 vote321 views1 answer
Change fab image programatically
Java
1 vote337 views1 answer
Java classes and objects
Java
1 vote336 views1 answer
Time complexity of hashset java add
Java
1 vote341 views3 answers
Scroll
Java
-1 vote341 views1 answer
Convert Date to LocalDate via Instant
Java
1 vote332 views1 answer
String to bigdecimal
Java
0 vote344 views3 answers
HashMap to Pojo
Java
32 votes291 views6 answers
Loops in java
Java