windows建立网站,南通高端网站建设咨询,长春微建站是哪个平台的,私人做的网站怎么挣钱概述
Spring JDBC Template 是 Spring Framework 提供的一个简化 JDBC 操作的模板类。它封装了一些常见的 JDBC 操作#xff0c;使得开发者在使用 JDBC 时能够更加便捷、简洁#xff0c;同时也提供了异常处理和资源管理等功能。
导入pom 使用C3P0作为数据源
project x…概述
Spring JDBC Template 是 Spring Framework 提供的一个简化 JDBC 操作的模板类。它封装了一些常见的 JDBC 操作使得开发者在使用 JDBC 时能够更加便捷、简洁同时也提供了异常处理和资源管理等功能。
导入pom 使用C3P0作为数据源
project xmlnshttp://maven.apache.org/POM/4.0.0 xmlns:xsihttp://www.w3.org/2001/XMLSchema-instancexsi:schemaLocationhttp://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsdmodelVersion4.0.0/modelVersion
groupIdorg.example/groupIdartifactIdspring-jdbc-demo1/artifactIdversion1.0-SNAPSHOT/versionpackagingjar/packaging
namespring-jdbc-demo1/nameurlhttp://maven.apache.org/url
propertiesproject.build.sourceEncodingUTF-8/project.build.sourceEncoding/properties
dependencies
dependencygroupIdorg.springframework/groupIdartifactIdspring-context/artifactIdversion6.0.13/version/dependencydependencygroupIdorg.springframework/groupIdartifactIdspring-beans/artifactIdversion6.0.13/version/dependencydependencygroupIdorg.springframework/groupIdartifactIdspring-core/artifactIdversion6.0.13/version/dependencydependencygroupIdjunit/groupIdartifactIdjunit/artifactIdversion3.8.1/versionscopetest/scope/dependency!-- https://mvnrepository.com/artifact/c3p0/c3p0 --dependencygroupIdc3p0/groupIdartifactIdc3p0/artifactIdversion0.9.1.2/version/dependency!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java --dependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactIdversion8.0.28/version/dependency!-- Spring JDBC --dependencygroupIdorg.springframework/groupIdartifactIdspring-jdbc/artifactIdversion5.3.5/version/dependency
!-- Spring Transaction (如果需要事务支持) --dependencygroupIdorg.springframework/groupIdartifactIdspring-tx/artifactIdversion5.3.10/version/dependencydependencygroupIdjunit/groupIdartifactIdjunit/artifactIdversion4.13.2/versionscopetest/scope/dependency/dependencies
/project
普通纯java代码 查询操作 ComboPooledDataSource dataSource new ComboPooledDataSource();dataSource.setDriverClass(com.mysql.jdbc.Driver);dataSource.setJdbcUrl(jdbc:mysql://localhost:3306/db2);dataSource.setUser(root);dataSource.setPassword(11111);JdbcTemplate jdbcTemplate new JdbcTemplate();jdbcTemplate.setDataSource(dataSource);int row jdbcTemplate.update(INSERT INTO user values (?,?,?), 110, xl11x, 105);System.out.println(row);
Xml配置 springJDBCTemplate简化纯java代码
?xml version1.0 encodingUTF-8?
beans xmlnshttp://www.springframework.org/schema/beansxmlns:xsihttp://www.w3.org/2001/XMLSchema-instancexmlns:contexthttp://www.springframework.org/schema/contextxsi:schemaLocationhttp://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans.xsdhttp://www.springframework.org/schema/contexthttp://www.springframework.org/schema/context/spring-context.xsdcontext:property-placeholder locationclasspath:mysql.properties/context:property-placeholderbean iddatasource classcom.mchange.v2.c3p0.ComboPooledDataSourceproperty namedriverClass value${jdbc.Driver}/propertyproperty namejdbcUrl value${jdbc.url}/propertyproperty nameuser value${jdbc.user}/propertyproperty namepassword value${jdbc.password}/property/beanbean idjdbcTemplate classorg.springframework.jdbc.core.JdbcTemplateproperty namedataSource refdatasource/property/bean
/beans
Properties文件配置
jdbc.Driver com.mysql.jdbc.Driver
jdbc.url jdbc:mysql://localhost:3306/db2
jdbc.user root
jdbc.password 111111
测试 插入
ApplicationContext context new ClassPathXmlApplicationContext(applicationContext.xml);JdbcTemplate jdbcTemplate context.getBean(JdbcTemplate.class);int row jdbcTemplate.update(INSERT INTO user values (?,?,?), 1110, llx, 1105);System.out.println(row);
测试 查询重要
ApplicationContext context new ClassPathXmlApplicationContext(applicationContext.xml);JdbcTemplate jdbcTemplate context.getBean(JdbcTemplate.class);ListUser query jdbcTemplate.query(select * from user, new BeanPropertyRowMapperUser(User.class));System.out.println(query);
new BeanPropertyRowMapperUser(User.class)
这个API里面的泛型填的是你要查询的封装而成的实体类 参数是实体类的字节码文件
返回的是一个list集合
实体类
package domain;
public class User {private String sno;private String name;private int point;
public User(String sno, String name, int point) {this.sno sno;this.name name;this.point point;}
public User() {}
public String getSno() {return sno;}
public void setSno(String sno) {this.sno sno;}
public String getName() {return name;}
public void setName(String name) {this.name name;}
public int getPoint() {return point;}
public void setPoint(int point) {this.point point;}
Overridepublic String toString() {return User{ sno sno \ , name name \ , point point };}
}
