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

10 votes209 views2 answers
Card view implement
Java
0 vote189 views1 answer
Pythagoras method in java
Java
4 votes199 views2 answers
Recycler view implementation
Java
1 vote186 views2 answers
Java template string
Java
0 vote221 views1 answer
Configuration spring boot dependency for freemarker configuration
Java Spring
1 vote226 views1 answer
Can we create an object of interface in java
Java
3 votes186 views1 answer
Java arraylist integer min value
Java
2 votes202 views2 answers
Changer version java terminal
Java
8 votes283 views3 answers
Printing arraylist
Java
0 vote205 views1 answer
Convert jwt claim to string java
Java