UpdateStatement With Two Parameters : Query Parameters « Spring « Java Tutorial

Java Tutorial 1.  Language 2.  Data Type 3.  Operators 4.  Statement Control 5.  Class Definition 6.  Development 7.  Reflection 8.  Regular Expressions 9.  Collections 10.  Thread 11.  File 12.  Generics 13.  I18N 14.  Swing 15.  Swing Event 16.  2D Graphics 17.  SWT 18.  SWT 2D Graphics 19.  Network 20.  Database 21.  Hibernate 22.  JPA 23.  JSP 24.  JSTL 25.  Servlet 26.  Web Services SOA 27.  EJB3 28.  Spring 29.  PDF 30.  Email 31.  J2ME 32.  J2EE Application 33.  XML 34.  Design Pattern 35.  Log 36.  Security 37.  Apache Common 38.  Ant 39.  JUnit Java Java Source Code / Java Documentation Java Open Source Jar File Download Java Articles Java Products Java by API Photoshop Tutorials Maya Tutorials Flash Tutorials 3ds-Max Tutorials Illustrator Tutorials GIMP Tutorials C# / C Sharp C# / CSharp Tutorial C# / CSharp Open Source ASP.Net ASP.NET Tutorial JavaScript DHTML JavaScript Tutorial JavaScript Reference HTML / CSS HTML CSS Reference C / ANSI-C C Tutorial C++ C++ Tutorial Ruby PHP Python Python Tutorial Python Open Source SQL Server / T-SQL SQL Server / T-SQL Tutorial Oracle PL / SQL Oracle PL/SQL Tutorial PostgreSQL SQL / MySQL MySQL Tutorial VB.Net VB.Net Tutorial Flash / Flex / ActionScript VBA / Excel / Access / Word XML XML Tutorial Microsoft Office PowerPoint 2007 Tutorial Microsoft Office Excel 2007 Tutorial Microsoft Office Word 2007 Tutorial

Java Tutorial » Spring » Query Parameters   28. 23. 3. UpdateStatement With Two Parameters File: context.xml <?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans"        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"        xmlns:util="http://www.springframework.org/schema/util"        xmlns:tx="http://www.springframework.org/schema/tx"        xmlns:aop="http://www.springframework.org/schema/aop"        xmlns:lang="http://www.springframework.org/schema/lang"        xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd                            http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-2.0.xsd                            http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd                            http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd                            http://www.springframework.org/schema/lang http://www.springframework.org/schema/lang/spring-lang-2.0.xsd"> <!--     <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">         <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>         <property name="url" value="jdbc:oracle:thin:@oracle.devcake.co.uk:1521:INTL"/>         <property name="username" value="sa"/>         <property name="password" value=""/>     </bean> -->     <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">     <property name="driverClassName" value="org.hsqldb.jdbcDriver"/>     <property name="url" value="jdbc:hsqldb:mem:."/>     <property name="username" value="sa"/>     <property name="password" value=""/>     </bean> <!--     <bean id="mysqlDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">         <property name="driverClassName" value="com.mysql.jdbc.Driver"/>         <property name="url" value="jdbc:mysql://dbhost-prospring-psql/prospring"/>         <property name="username" value="sa"/>         <property name="password" value=""/>     </bean> -->     <bean id="lobHandler" class="org.springframework.jdbc.support.lob.OracleLobHandler">         <property name="nativeJdbcExtractor" ref="nativeJdbcExtractor"/>     </bean>     <bean id="nativeJdbcExtractor" class="org.springframework.jdbc.support.nativejdbc.CommonsDbcpNativeJdbcExtractor"/>     <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">         <property name="dataSource" ref="dataSource"/>     </bean> </beans> File: Main.java import java.sql.Types; import javax.sql.DataSource; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; import org.springframework.jdbc.core.JdbcTemplate; class Main {   public static void main(String args[]) throws Exception {     ApplicationContext ac = new ClassPathXmlApplicationContext("context.xml", Main.class);     DataSource dataSource = (DataSource) ac.getBean("dataSource");     // DataSource mysqlDataSource = (DataSource) ac.getBean("mysqlDataSource");     JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);     jdbcTemplate.update("update customer set first_name=? where id=?",         new Object[] { "A", 1L }, new int[] { Types.VARCHAR, Types.INTEGER });   } }   Download:  Spring-UpdateStatementWithTwoParameters.zip( 3,655 k) 28. 23. Query Parameters 28. 23. 1.  Use JdbcTemplate To Pass In Different Type Of Parameters 28. 23. 2.  Use JdbcTemplate To Execute Delete Statement With Parameter 28. 23. 3.  UpdateStatement With Two Parameters 28. 23. 4.  Deal With TimeStamp 28. 23. 5.  Control Parameter Type In JdbcTemplate Query 28. 23. 6.  StoredProcedure with parameters 28. 23. 7.  Object array as parameter