Java SQL PreparedStatement createProjectInfo(PreparedStatement ps, long projectId, long projectInfoTypeId, String value, long modUserId)

Description

Create project info.

License

Open Source License

Parameter

Parameter	Description
ps	the preparedstatement
projectInfoTypeId	the info type id
value	the value

Exception

Parameter	Description
SQLException	if error occurs

Declaration

private static void createProjectInfo(PreparedStatement ps, long projectId, long projectInfoTypeId,
        String value, long modUserId) throws SQLException 

Method Source Code

//package com.java2s;

import java.sql.PreparedStatement;

import java.sql.SQLException;

public class Main {
    /**/*from  www.j  av  a 2 s .  c  o  m*/
     * Create project info.
     *
     * @param ps                the preparedstatement
     * @param projectInfoTypeId the info type id
     * @param value             the value
     * @throws SQLException if error occurs
     */
    private static void createProjectInfo(PreparedStatement ps, long projectId, long projectInfoTypeId,
            String value, long modUserId) throws SQLException {
        int index = 1;
        ps.setLong(index++, projectId);
        ps.setLong(index++, projectInfoTypeId);
        ps.setString(index++, value);
        ps.setString(index++, String.valueOf(modUserId));
        ps.setString(index++, String.valueOf(modUserId));
        ps.executeUpdate();
    }
}

Related

1. closeStatement(PreparedStatement preparedStatement)
2. closeStatement(PreparedStatement ps)
3. closeStatement(PreparedStatement theStatement)
4. createInsertPrepareStatement(Connection conn, String tableName, String[] dataColumnNames)
5. createPreparedStatement(Connection conn, String sql, String[] args)
6. deleteOldData(Connection connection, PreparedStatement stmt, String funcId)
7. fillArgs(Object[][] args, PreparedStatement pstmt, int i)
8. fillInClause(PreparedStatement ps, int startIndex, Collection clauses, int sqlType)
9. fillParameters(PreparedStatement stmt, List