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

35 votes183 views6 answers
Check java version
Java
0 vote290 views1 answer
UserRedirectRequiredException: A redirect is required to get the users approval spring boot 5 security
Java Spring
13 votes221 views2 answers
For loop in java example complete programs
Java
10 votes183 views5 answers
Java join list
Java
16 votes157 views2 answers
Java random usage
Java
1 vote301 views1 answer
Java ee check if session exists or is new
Java
0 vote175 views1 answer
Postfix operator in java
Java
0 vote237 views1 answer
Least significant bit java
Java
3 votes180 views1 answer
How to add cardview in android studio
Java
0 vote176 views1 answer
Multiple recyclerview not scrolling bottom sheet
Java