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

4 votes142 views1 answer
How to check if recyclerview is empty
Java
1 vote128 views1 answer
Java get bigger int
Java
-1 vote141 views1 answer
Load contents of file into string java
Java
0 vote153 views1 answer
Get host from request object java
Java
2 votes198 views2 answers
Get year month day from date string java
Java
10 votes149 views3 answers
How to change default port in spring boot
Java
0 vote138 views1 answer
Does not have a NavController set on 2131231008
Java
6 votes140 views2 answers
RecyclerView OnClickListener
Java
1 vote177 views1 answer
Spring boot jpa in clause
Java Spring
0 vote144 views1 answer
Jlabel icon
Java