Examples of com.volantis.mcs.accessors.jdbc.PreparedStatementSetter

com.volantis.mcs.accessors.jdbc.PreparedStatementSetter
Callback interface used by the JdbcTemplate class.
This interface sets values on a PreparedStatement provided by the JdbcTemplate class. Implementations are responsible for setting any necessary parameters. SQL with placeholders will already have been supplied.
It's easier to use this interface than PreparedStatementCreator, as the JdbcTemplate will create the prepared statement.
Implementations do not need to concern themselves with SQLExceptions that may be thrown from operations they attempt. The JdbcTemplate class will catch and handle SQLExceptions appropriately.

                String deviceName = rs.getString(1);
                long tac = rs.getLong(2);
                return new DeviceTACPair(tac, deviceName);
            }
        };
        PreparedStatementSetter setter = new PreparedStatementSetter() {
            public void setValues(PreparedStatement ps)
                    throws SQLException {


                if (logger.isDebugEnabled()) {
                    logger.debug("Selecting from "

View Full Code Here

                + policyHelpField + " , "
                + languageField
                + " ) "
                + " values ( ? , ? , ? , ? , ? )",


                new PreparedStatementSetter() {
                    public void setValues(PreparedStatement ps)
                            throws SQLException {


                        final String projectName = getProjectName();
                        final String descriptiveName =

View Full Code Here

                + projectField + " , " + categoryIDField + " , "
                + categoryDescNameField + " , " + languageField
                + " ) "
                + " values ( ? , ? , ? , ? )",


                new PreparedStatementSetter() {
                    public void setValues(PreparedStatement ps)
                            throws SQLException {


                        String projectName = getProjectName();
                        final String descriptiveName =

View Full Code Here

                + categoryNameField + " , "
                + languageField
                + " ) "
                + " values ( ? , ? , ? , ? )",


                new PreparedStatementSetter() {
                    public void setValues(PreparedStatement ps)
                            throws SQLException {


                        String projectName = getProjectName();
                        if (logger.isDebugEnabled()) {

View Full Code Here

                + policyField + " , "
                + typeInstanceIDField + " , "
                + categoryIDField
                + " ) "
                + " values ( ? , ? , ? , ? )",
                new PreparedStatementSetter() {
                    public void setValues(PreparedStatement ps)
                            throws SQLException {


                        String projectName = getProjectName();
                        if (logger.isDebugEnabled()) {

View Full Code Here

                + projectField + " , "
                + typeInstanceIDField + " , "
                + typeIDField
                + " ) "
                + " values ( ? , ? , ? )",
                new PreparedStatementSetter() {
                    public void setValues(PreparedStatement ps)
                            throws SQLException {


                        String projectName = getProjectName();
                        if (logger.isDebugEnabled()) {

View Full Code Here

                + typeInstanceIDField + " , "
                + memberInstanceIDField + " , "
                + orderedField
                + " ) " +
                " values ( ? , ? , ? , ? )",
                new PreparedStatementSetter() {
                    public void setValues(PreparedStatement ps)
                            throws SQLException {


                        String projectName = getProjectName();
                        if (logger.isDebugEnabled()) {

View Full Code Here

                + typeInstanceIDField + " , "
                + fieldNameField + " , "
                + fieldInstanceIDField
                + " ) "
                + " values ( ? , ? , ?  , ? )",
                new PreparedStatementSetter() {
                    public void setValues(PreparedStatement ps)
                            throws SQLException {


                        String projectName = getProjectName();
                        if (logger.isDebugEnabled()) {

View Full Code Here

                + typeInstanceIDField + " , "
                + minValueField + " , "
                + maxValueField
                + " )"
                + " values ( ? , ? , ? , ? )",
                new PreparedStatementSetter() {
                    public void setValues(PreparedStatement ps)
                            throws SQLException {


                        String projectName = getProjectName();
                        if (logger.isDebugEnabled()) {

View Full Code Here

                    + projectField + " , "
                    + typeInstanceIDField + " , "
                    + keywordField
                    + " ) "
                    + " values ( ? , ? , ? )",
                    new PreparedStatementSetter() {
                        public void setValues(PreparedStatement ps)
                                throws SQLException {
                            String projectName = getProjectName();
                            if (logger.isDebugEnabled()) {
                                logger.debug("Inserting into "

View Full Code Here

0 1

TOP

Related Classes of com.volantis.mcs.accessors.jdbc.PreparedStatementSetter

com.volantis.devrep.repository.impl.accessors.jdbc.JDBCDeviceRepositoryAccessor

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.