最近在学习使用弹簧引导连接数据库,今天学习了使用jdbctemplate操作MYSQL数据库、下面就留个笔记
不废话,先来代码
pom文件:
& lt;项目xmlns=" http://maven.apache.org/POM/4.0.0 " xmlns: xsi=" http://www.w3.org/2001/XMLSchema-instance " xsi: schemaLocation=" http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd”比; & lt; modelVersion> 4.0.0 & lt; groupId> test & lt; artifactId> test & lt; version> 0.0.1-SNAPSHOT & lt; packaging> jar & lt; name> test & lt; url> http://maven.apache.org</url> & lt; properties> & lt; project.build.sourceEncoding> UTF-8 & lt;/properties> & lt; dependencies> & lt; dependency> & lt; groupId> org.springframework.boot & lt; artifactId> spring-boot-starter & lt; version> 1.4.2.RELEASE & lt;/dependency> & lt; dependency> & lt; groupId> org.springframework.boot & lt; artifactId> spring-boot-starter-jdbc & lt; version> 1.4.2.RELEASE & lt;/dependency> & lt; dependency> & lt; groupId> mysql & lt; artifactId> mysql-connector-java & lt; version> 5.1.21 & lt;/dependency> & lt;/dependencies> & lt;/project> >之前配置文件:application.properties (springboot框架默认使用这个名字,放在资源下面)
spring.datasource.url=jdbc: mysql://localhost: 3306/service_lucky_draw& # 63; autoReconnect=true& useUnicode=true& characterEncoding=utf - 8 spring.datasource.username=根 spring.datasource.password=1234 spring.datasource.driver-class-name=com.mysql.jdbc.Driver spring.application.name=@pom.artifactId@ server.port=33333 >之前启动类:
包versionUpdate; 进口并不知道; 进口java.util.Map; 进口org.apache.log4j.Logger; 进口org.springframework.beans.factory.annotation.Autowired; 进口org.springframework.boot.CommandLineRunner; 进口org.springframework.boot.SpringApplication; 进口org.springframework.boot.autoconfigure.SpringBootApplication; 进口org.springframework.jdbc.core.JdbcTemplate; @SpringBootApplication 公共类ApplicationMain实现CommandLineRunner { 私人日志记录器=Logger.getLogger (ApplicationMain.class); @ autowired 私人JdbcTemplate JdbcTemplate; 公共静态void main (String [] args) { SpringApplication SpringApplication=new SpringApplication (ApplicationMain.class); springApplication.run (args); } @Override 公共空间运行(字符串…args)抛出异常{ 字符串queryMerchandiseInfoSql="选择id,值得,channel_id template_id merchandise_info”; List