目录
查询操作
查询所有
查询单个
聚合查询
知识要点总结
查询操作
查询所有
查询操作需要放入字节码对象.class
@Test
public void testQueryAll(){
//后面括号中需要放入字节码对象
List accountList = jdbcTemplate.query("select * from account", new BeanPropertyRowMapper(Account.class));
System.out.println(accountList);
}
数据库中
Junit4.11版本导致错误一开始我使用了junit4.11的版本
C:java64jdk1.8.0_131binjava.exe -ea -Didea.test.cyclic.buffer.size=1048576 "-javaagent:D:Program FilesJetBrainsIntelliJ IDEA 2019.3.3libidea_rt.jar=4613:D:Program FilesJetBrainsIntelliJ IDEA 2019.3.3bin" -Dfile.encoding=UTF-8 -classpath "D:Program FilesJetBrainsIntelliJ IDEA 2019.3.3libidea_rt.jar;D:Program FilesJetBrainsIntelliJ IDEA 2019.3.3pluginsjunitlibjunit5-rt.jar;D:Program FilesJetBrainsIntelliJ IDEA 2019.3.3pluginsjunitlibjunit-rt.jar;C:java64jdk1.8.0_131jrelibcharsets.jar;C:java64jdk1.8.0_131jrelibdeploy.jar;C:java64jdk1.8.0_131jrelibextaccess-bridge-64.jar;C:java64jdk1.8.0_131jrelibextcldrdata.jar;C:java64jdk1.8.0_131jrelibextdnsns.jar;C:java64jdk1.8.0_131jrelibextjaccess.jar;C:java64jdk1.8.0_131jrelibextjfxrt.jar;C:java64jdk1.8.0_131jrelibextlocaledata.jar;C:java64jdk1.8.0_131jrelibextnashorn.jar;C:java64jdk1.8.0_131jrelibextsunec.jar;C:java64jdk1.8.0_131jrelibextsunjce_provider.jar;C:java64jdk1.8.0_131jrelibextsunmscapi.jar;C:java64jdk1.8.0_131jrelibextsunpkcs11.jar;C:java64jdk1.8.0_131jrelibextzipfs.jar;C:java64jdk1.8.0_131jrelibjavaws.jar;C:java64jdk1.8.0_131jrelibjce.jar;C:java64jdk1.8.0_131jrelibjfr.jar;C:java64jdk1.8.0_131jrelibjfxswt.jar;C:java64jdk1.8.0_131jrelibjsse.jar;C:java64jdk1.8.0_131jrelibmanagement-agent.jar;C:java64jdk1.8.0_131jrelibplugin.jar;C:java64jdk1.8.0_131jrelibresources.jar;C:java64jdk1.8.0_131jrelibrt.jar;D:小项目webTesttargettest-classes;D:小项目webTesttargetclasses;E:Maven_projectlibjavax.transaction.jar;E:Maven_projectlibjavax.annotation.jar;E:Maven_projectlibjavax.jms.jar;E:Maven_projectlibjavax.resource.jar;E:Maven_projectlibjavax.ejb.jar;E:Maven_projectlibjavax.persistence.jar;E:Maven_projectlibjavax.servlet.jar;E:Maven_projectlibjavax.servlet.jsp.jstl.jar;E:Maven_projectlibjavax.servlet.jsp.jar;C:Users执久.m2repositorymysqlmysql-connector-java5.1.32mysql-connector-java-5.1.32.jar;C:Users执久.m2repositoryc3p0c3p0 .9.1.2c3p0-0.9.1.2.jar;C:Users执久.m2repositorycomalibabadruid1.1.10druid-1.1.10.jar;C:Users执久.m2repositoryjunitjunit4.11junit-4.11.jar;C:Users执久.m2repositoryorghamcresthamcrest-core1.3hamcrest-core-1.3.jar;C:Users执久.m2repositoryorgspringframeworkspring-test5.0.5.RELEASEspring-test-5.0.5.RELEASE.jar;C:Users执久.m2repositoryorgspringframeworkspring-core5.0.5.RELEASEspring-core-5.0.5.RELEASE.jar;C:Users执久.m2repositoryorgspringframeworkspring-jcl5.0.5.RELEASEspring-jcl-5.0.5.RELEASE.jar;C:Users执久.m2repositoryorgspringframeworkspring-context5.0.5.RELEASEspring-context-5.0.5.RELEASE.jar;C:Users执久.m2repositoryorgspringframeworkspring-aop5.0.5.RELEASEspring-aop-5.0.5.RELEASE.jar;C:Users执久.m2repositoryorgspringframeworkspring-beans5.0.5.RELEASEspring-beans-5.0.5.RELEASE.jar;C:Users执久.m2repositoryorgspringframeworkspring-expression5.0.5.RELEASEspring-expression-5.0.5.RELEASE.jar;C:Users执久.m2repositoryorgspringframeworkspring-web5.0.5.RELEASEspring-web-5.0.5.RELEASE.jar;C:Users执久.m2repositoryorgspringframeworkspring-webmvc5.0.5.RELEASEspring-webmvc-5.0.5.RELEASE.jar;C:Users执久.m2repositorycomfasterxmljacksoncorejackson-core2.9.0jackson-core-2.9.0.jar;C:Users执久.m2repositorycomfasterxmljacksoncorejackson-databind2.9.0jackson-databind-2.9.0.jar;C:Users执久.m2repositorycomfasterxmljacksoncorejackson-annotations2.9.0jackson-annotations-2.9.0.jar;C:Users执久.m2repositoryorgspringframeworkspring-jdbc5.0.5.RELEASEspring-jdbc-5.0.5.RELEASE.jar;C:Users执久.m2repositoryorgspringframeworkspring-tx5.0.5.RELEASEspring-tx-5.0.5.RELEASE.jar" com.intellij.rt.junit.JUnitStarter -ideVersion5 -junit4 test.JdbcTemplateCRUDTest,testUpdate java.lang.ExceptionInInitializerError at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at org.junit.internal.builders.AnnotatedBuilder.buildRunner(AnnotatedBuilder.java:29) at org.junit.internal.builders.AnnotatedBuilder.runnerForClass(AnnotatedBuilder.java:21) at org.junit.runners.model.RunnerBuilder.safeRunnerForClass(RunnerBuilder.java:59) at org.junit.internal.builders.AllDefaultPossibilitiesBuilder.runnerForClass(AllDefaultPossibilitiesBuilder.java:26) at org.junit.runners.model.RunnerBuilder.safeRunnerForClass(RunnerBuilder.java:59) at org.junit.internal.requests.ClassRequest.getRunner(ClassRequest.java:26) at org.junit.internal.requests.FilterRequest.getRunner(FilterRequest.java:31) at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:49) at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:33) at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:230) at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:58) Caused by: java.lang.IllegalStateException: SpringJUnit4ClassRunner requires JUnit 4.12 or higher. at org.springframework.util.Assert.state(Assert.java:73) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.(SpringJUnit4ClassRunner.java:104) ... 15 more 进程已结束，退出代码 -1
将其改为Junit4.12就可以正确执行了
运行结果
运行结果
查询单个
@Test
public void testQueryOne(){
Account account = jdbcTemplate.queryForObject("select *from account where name=?", new BeanPropertyRowMapper(Account.class), "ZH");
System.out.println(account);
}
运行结果
聚合查询
@Test
public void testQueryCount(){
//查询数据条数
Long count = jdbcTemplate.queryForObject("select count(*) from account", Long.class);
System.out.println(count);
}
是一个实体就new一个对象，但是一个简单的数据，则创建一个普通的数据
