文章目录

Jdbc 知识点
- Spring JDBC Template 增
- Spring JDBC Template 删
- Spring JDBC Template 改
- Spring JDBC Template 查
Spring Jdbc Template 使用 Spring 的注入功能,可以把 DataSource 注册到 JdbcTemplate 之中。JdbcTemplate 的全限定命名为 org.springframework.jdbc.core.JdbcTemplate。要使用 JdbcTemlate 还需一个 spring-tx 包,这个包包含了事务和异常控制。
JdbcTemplate 主要提供以下五类方法:
- execute 方法:可以用于执行任何 SQL 语句,一般用于执行 DDL 语句。
- update 方法:用于执行新增、修改、删除等语句。
- batchUpdate 方法:用于执行批处理相关语句。
- queryForXXX 方法:用于执行查询相关语句。
- call 方法:用于执行查询相关语句,执行存储过程、函数相关语句。
jdbcTemplate 实现增删改查
Spring 配置数据库
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
<?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:context = "http://www.springframework.org/schema/context" xsi:schemaLocation = "http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd"> <context:annotation-config/> <bean id = "dataSource" class = "org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name = "driverClassName" value = "com.mysql.jdbc.Driver"/> <property name = "url" value = "jdbc:mysql://localhost/jdbc"/> <property name = "username" value = "root"/> <property name = "password" value = ""/> </bean> <bean id = "jdbcTemplate" class = "org.springframework.jdbc.core.JdbcTemplate"> <property name = "dataSource" ref = "dataSource"/> </bean> </beans> |
App.java 实现增删改查
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 |
public class App { private static ApplicationContext context; public static void main(String[] args) { context = new ClassPathXmlApplicationContext("SpringBeans.xml"); JdbcTemplate jdbcTemplate= context.getBean("jdbcTemplate",JdbcTemplate.class); /** * insert into * 增加 * * String insertSql = "insert into student values(?,?,?)"; * * int updateOrNo = jdbcTemplate.update(insertSql, new Object[]{3, "shiyanlou3", 20}); * * System.out.println(updateOrNo); */ /** * 删除 * delete from student where id =? * int deleteOrNo = jdbcTemplate.update("delete from student where id =?", 3); * System.out.println(deleteOrNo); * */ /** * 更新 * update student set name=?,name=? where id =?; * int update = jdbcTemplate.update("update student set name = ?,age=? where id =?", new Object[]{"songhao", 18, 2}); * System.out.println(update); */ /** * 查询 * select * from student where id =? * */ BeanPropertyRowMapper<Student> studentBeanPropertyRowMapper = new BeanPropertyRowMapper<>(Student.class); List<Student> studentList = jdbcTemplate.query("select * from student", studentBeanPropertyRowMapper); for (Student student : studentList) { System.out.println(student); } } } |
