How to execute INSERT statement using JdbcTemplate class from Spring Framework

Question

In Spring  how can I insert data in table using JdbcTemplate  Can anyone please provide me a code sample for doing this

User · Answer

You ll need a datasource for working with JdbcTemplate   JdbcTemplate template   new JdbcTemplate yourDataSource    template update      new PreparedStatementCreator             public PreparedStatement createPreparedStatement Connection connection              throws SQLException                PreparedStatement statement   connection prepareStatement ourInsertQuery                 statement setLong 1  beginning   set parameters you need in your insert              return statement

User · Answer

we can use update for both insert and update delte

User · Answer

Use jdbcTemplate update String sql  Object    args  method     jdbcTemplate update       INSERT INTO schema tableName  column1  column2  VALUES              var1  var2      or jdbcTemplate update String sql  Object   args  int   argTypes   if you need to map arguments to SQL types manually   jdbcTemplate update       INSERT INTO schema tableName  column1  column2  VALUES              new Object   var1  var2   new Object   Types TYPE OF VAR1  Types TYPE OF VAR2

User · Answer

You can alternatively use NamedParameterJdbcTemplate  naming can be useful when you have many parameters   Map lt String  Object gt  params   new HashMap lt  gt     params put  var1  value1    params put  var2  value2    namedJdbcTemplate update       INSERT INTO schema tableName  column1  column2  VALUES   var1   var2        params

User · Answer

If you use spring-boot  you don t need to create a DataSource class  just specify the data url username password driver in application properties  then you can simply  Autowired it    Repository public class JdbcRepository        private final JdbcTemplate jdbcTemplate        Autowired     public DynamicRepository JdbcTemplate jdbcTemplate            this jdbcTemplate   jdbcTemplate             public void insert             jdbcTemplate update  INSERT INTO BOOK  name  description  VALUES   book name    book description                Example of application properties    Basic Spring Boot Config for Oracle spring datasource url jdbc oracle thin   DESCRIPTION  ADDRESS  PROTOCOL TCP  HOST YourHostIP  PORT YourPort   CONNECT DATA  SERVER dedicated  SERVICE NAME YourServiceName    spring datasource username username spring datasource password password spring datasource driver-class-name oracle jdbc OracleDriver   hibernate config spring jpa database-platform org hibernate dialect Oracle10gDialect   Then add the driver and connection pool dependencies in pom xml   lt dependency gt       lt groupId gt com oracle lt  groupId gt       lt artifactId gt ojdbc7 lt  artifactId gt       lt version gt 12 1 0 1 lt  version gt   lt  dependency gt    lt  -- HikariCP connection pool -- gt   lt dependency gt       lt groupId gt com zaxxer lt  groupId gt       lt artifactId gt HikariCP lt  artifactId gt       lt version gt 2 6 0 lt  version gt   lt  dependency gt    See the official doc for more details

User · Answer

If you are planning to use JdbcTemplate in multiple locations  it would be a good idea to create a Spring Bean for it   Using Java Config it would be    Configuration public class DBConfig        Bean    public DataSource dataSource             create a data source           Bean    public JdbcTemplate jdbcTemplate           return new JdbcTemplate dataSource               Bean    public TransactionManager transactionManager           return new DataSourceTransactionManager dataSource               Then a repository that uses that JdbcTemplate could be    Repository public class JdbcSomeRepository implements SomeRepository       private final JdbcTemplate jdbcTemplate        Autowired    public JdbcSomeRepository JdbcTemplate jdbcTemplate          this jdbcTemplate   jdbcTemplate             Override     Transactional     public int someUpdate SomeType someValue  SomeOtherType someOtherValue          return jdbcTemplate update  INSERT INTO SomeTable column1  column2  VALUES        someValue  someOtherValue           The update method from JdbcTemplate that I have used can be found here

[java] How to execute INSERT statement using JdbcTemplate class from Spring Framework

Examples related to java

Examples related to spring

Examples related to jdbctemplate