springDao的jdbctemplate

最新推荐文章于 2024-06-17 09:03:56 发布
最新推荐文章于 2024-06-17 09:03:56 发布
阅读量123 收藏
点赞数
文章标签： 数据库 java
原文链接：http://www.cnblogs.com/pursue339/p/10615090.html
版权

pom文件

 

<?xml version="1.0" encoding="UTF-8"?>
<project 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">
    <modelVersion>4.0.0</modelVersion>

    <groupId>com.yujian</groupId>
    <artifactId>spring-dao-demo1</artifactId>
    <version>1.0-SNAPSHOT</version>
    <dependencies>
        <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-core</artifactId>
        <version>5.1.3.RELEASE</version>
    </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>5.1.3.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-beans</artifactId>
            <version>5.1.3.RELEASE</version>
        </dependency>
        <!--spring连接jdbc-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.1.3.RELEASE</version>
        </dependency>
        <!--jdbc驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
        </dependency>
        <!--c3p0数据源，替代DBHelper的-->
        <dependency>
            <groupId>com.mchange</groupId>
            <artifactId>c3p0</artifactId>
            <version>0.9.5.2</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/org.projectlombok/lombok -->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.4</version>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-tx</artifactId>
            <version>5.1.3.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-aop</artifactId>
            <version>5.1.3.RELEASE</version>
        </dependency>

        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjweaver</artifactId>
            <version>1.9.2</version>
        </dependency>
    </dependencies>

</project>
配置文件applicationContext.xml
<?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"
       xmlns:aop="http://www.springframework.org/schema/tx" xmlns:tx="http://www.springframework.org/schema/tx"
       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 http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
<!--<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
    <property name="driverClass" value="com.mysql.jdbc.Driver"/>
    <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/school?useSSL=false"/>
    <property name="user" value="root"/>
    <property name="password" value="root"/>
</bean>-->
    <!--<context:property-placeholder location="db.properties"/>
    <context:component-scan base-package="com.yujian"/>-->
    <!--<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="${driverClass}"/>
        <property name="jdbcUrl" value="${driverUrl}"/>
        <property name="user" value="${dbName}"/>
        <property name="password" value="${dbPass}"/>
    </bean>-->
    <!--<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"/>
    </bean>-->
    <!--<bean id="studentDao" class="com.yujian.dao.StudentDao">
        <property name="jdbcTemplate" ref="jdbcTemplate"/>
    </bean>-->
    <!--<bean id="studentService" class="com.yujian.service.StudentService">
        <property name="studentDao" ref="studentDao"/>
    </bean>-->
    <!--<tx:annotation-driven/>-->
</beans>
db.properties文件
driverClass=com.mysql.jdbc.Driver
driverUrl=jdbc:mysql://localhost:3306/school?useSSL=false
dbName=root
dbPass=root
如果用全注解方式，总文件为
package com.yujian.config;

import com.mchange.v2.c3p0.ComboPooledDataSource;
import com.yujian.service.StudentService;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.PropertySource;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.transaction.annotation.EnableTransactionManagement;

import java.beans.PropertyVetoException;

@Configuration
@PropertySource("classpath:db.properties")
@ComponentScan("com.yujian")
@EnableTransactionManagement
/*必须加入上面的EnableTransactionManagement才可以使用事务全注解拦截
* 而且下面要有*/
public class MyConfig {
    @Value("${driverClass}")
    private String driverClass;
    @Value("${driverUrl}")
    private String driverUrl;
    @Value("${dbName}")
    private String dbName;
    @Value("${dbPass}")
    private String dbPass;
    @Bean
    public ComboPooledDataSource dataSource(){
        ComboPooledDataSource dataSource=new ComboPooledDataSource();
        try {
            dataSource.setPassword(dbPass);
            dataSource.setUser(dbName);
            dataSource.setJdbcUrl(driverUrl);
            dataSource.setDriverClass(driverClass);
        } catch (PropertyVetoException e) {
            e.printStackTrace();
        }
        return dataSource;
    }
    @Bean
    public JdbcTemplate jdbcTemplate(){
        JdbcTemplate jdbcTemplate=new JdbcTemplate();
        jdbcTemplate.setDataSource(dataSource());
        return jdbcTemplate;
    }
    @Bean
    public DataSourceTransactionManager getDataSourceTransactionManager(){
        DataSourceTransactionManager transactionManager=new DataSourceTransactionManager();
        transactionManager.setDataSource(dataSource());
        return transactionManager;
    }

}
Dao层的jdbc设置
package com.yujian.dao;

import com.yujian.model.ClassInfo;
import com.yujian.model.Student;
import com.yujian.util.Page;
import lombok.Data;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.stereotype.Component;
import org.springframework.stereotype.Repository;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;


@Component
public class StudentDao {
    //分组，列的子查询，临时表子查询没办法用orm（hibernate）做映射
    /*public JdbcTemplate getJdbcTemplate() {
        return jdbcTemplate;
    }

    public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
        @Data这个需要在setting里的plugins搜索lombok补丁下载才可以不用写getset
    }*/

    //匿名内部类
    @Autowired
private JdbcTemplate jdbcTemplate;
    public List<Student> findListStudent(){
        String sql="select * from student s,classinfo c where c.classId=s.classId";
        List<Student> list=jdbcTemplate.query(sql,rowMapper);
        //可以这样写，下面代码可以多个用
        List<Student> students1=jdbcTemplate.query(sql,new BeanPropertyRowMapper(Student.class));
        List<Student> students=new ArrayList<Student>();
        List<Map<String,Object>> rows=jdbcTemplate.queryForList(sql);
        for (Map row:rows){
            Student student=new Student();
            student.setStuId((Integer) row.get("stuId"));
            student.setStuNmae((String) row.get("stuName"));
            student.setStuBirth((Date) row.get("stuBirth"));
            student.setStuSex((Integer) row.get("stuSex"));
            ClassInfo classInfo=new ClassInfo();
            classInfo.setClassId((Integer) row.get("classId"));
            classInfo.setClassName((String )row.get("className"));
            student.setClassInfo(classInfo);
            students.add(student);

        }
        return students;
    }
 private RowMapper<Student> rowMapper=new RowMapper<Student>() {
        public Student mapRow(ResultSet rs, int i) throws SQLException {
            Student student=new Student();
            student.setStuId(rs.getInt("stuId"));
            student.setStuNmae(rs.getString("stuName"));
            student.setStuBirth(rs.getDate("stuBirth"));
            student.setStuSex(rs.getInt("stuSex"));
            ClassInfo classInfo=new ClassInfo();
            classInfo.setClassId(rs.getInt("classId"));
            classInfo.setClassName(rs.getString("className"));
            student.setClassInfo(classInfo);
            return student;
        }
    };
    public Student findStudentById(int stuId){
        String sql="select * from student s,classinfo c where c.classId=s.classId and s.stuId=? ";
        /*Student student=jdbcTemplate.queryForObject(sql, new RowMapper<Student>() {
            public Student mapRow(ResultSet rs, int i) throws SQLException {
                Student student=new Student();
                student.setStuId(rs.getInt("stuId"));
                student.setStuNmae(rs.getString("stuName"));
                student.setStuBirth(rs.getDate("stuBirth"));
                student.setStuSex(rs.getInt("stuSex"));
                ClassInfo classInfo=new ClassInfo();
                classInfo.setClassId(rs.getInt("classId"));
                classInfo.setClassName(rs.getString("className"));
                student.setClassInfo(classInfo);
                return student;
            }
        },stuId);*/
        Object[]obj={stuId};
        Student student=jdbcTemplate.queryForObject(sql,obj, new RowMapper<Student>() {
            public Student mapRow(ResultSet rs, int i) throws SQLException {
                Student student=new Student();
                student.setStuId(rs.getInt("stuId"));
                student.setStuNmae(rs.getString("stuName"));
                student.setStuBirth(rs.getDate("stuBirth"));
                student.setStuSex(rs.getInt("stuSex"));
                ClassInfo classInfo=new ClassInfo();
                classInfo.setClassId(rs.getInt("classId"));
                classInfo.setClassName(rs.getString("className"));
                student.setClassInfo(classInfo);
                return student;
            }
        });

        return student;
    }

    public void updateStudent(Student student){
        String sql="update student set stuName=?,stuSex=?,stuBirth=?,classId=? where stuId=?";
        Object[]obj={student.getStuNmae(),student.getStuSex(),student.getStuBirth(),student.getClassInfo().getClassId(),student.getStuId()};
jdbcTemplate.update(sql,obj);

    }
    public void insertStudent(Student student){
        String sql="insert into student(stuName, stuSex, stuBirth, classId) values " +
                "(?,?,?,?)";
        Object[] obj={student.getStuNmae(),student.getStuSex(),student.getStuBirth(),student.getClassInfo().getClassId()};
jdbcTemplate.update(sql,obj);
    }
    public void deleteStudent(int stuId){
        String sql="delete from student where stuId=?";
jdbcTemplate.update(sql,stuId);

    }
    public List<Student> listStudentBy(Student student){
        String sql="select * from student,classinfo where student.classId=classinfo.classId  ";
        List<Object> obj=new ArrayList<Object>();
            if(null!=student.getStuNmae()&&!"".equals(student.getStuNmae())){
                sql+=" and stuName=? ";
                obj.add(student.getStuNmae());
            }
            /*if(null!=student.getStuNmae()&&!"".equals(student.getStuNmae())){
                sql+=" and stuName=? ";
                obj.add(student.getStuNmae());
            }*/
            if(null!=student.getStuBirth()&&!"".equals(student.getStuBirth())){
                sql+=" and stuBirth=? ";
                obj.add(student.getStuBirth());
            }
            if(student.getStuSex()!=-1){
                sql+=" and stuSex=? ";
                obj.add(student.getStuSex());
            }
        List<Student>list=jdbcTemplate.query(sql,obj.toArray(),rowMapper);
        return list;
    }
    public List<Student> findStuentByParam(Map<String,String> param, Page page){
        String sql="select * from student ,classinfo where student.classId=classinfo.classId  ";
        List paramValue=new ArrayList();
        //条件子句
        if(null!=param&&param.size()>0) {
            sql += getParamValue(param, paramValue);
        }
        /*String stuName=param.get("stuName");
        if(stuName!=null&&!stuName.equals("")){
            sql+=" and stuName like ?";
            paramValue.add("%"+stuName+"%");
        }
        String stuSex=param.get("stuSex");
        if(stuSex!=null&&!stuSex.equals("")){
            sql+=" and stuSex like ?";
            paramValue.add("%"+stuSex+"%");
        }
        String stuBirth=param.get("stuBirth");
        if(stuBirth!=null&&!stuBirth.equals("")){
            sql+=" and stuBith like ?";
            paramValue.add("%"+stuName+"%");
        }*/
        //排序子句
        sql+=" order by stuId ";
        if(page!=null){
            sql+=" limit "+(page.getPageNo()-1)*page.getPageSize()+","+page.getPageSize();
        }
        System.out.println("sql:"+sql+"param:->"+paramValue);
        List<Student>list=jdbcTemplate.query(sql,paramValue.toArray(),rowMapper);
        return list;
    }
    private String getParamValue(Map<String,String> param,List paramValue){
        String sql="";
        String stuName=param.get("stuName");
        if(null!=stuName&&!"".equals(stuName)){
            sql+=" and stuname like ?";
            paramValue.add("%"+stuName+"%");
        }
        String stuSex=param.get("stuSex");
        if(null!=stuSex&&!"".equals(stuSex)){
            sql+=" and stusex=? ";
            paramValue.add(stuSex);
        }
        String stuBirth=param.get("stuBirth");
        if(null!=stuBirth&&!"".equals(stuBirth)){
            sql+=" and stubirth like ?";
            paramValue.add("%"+stuBirth+"%");
        }
        return sql;
    }
    public int findStudentRowCnt(Map<String,String> param){
        String sql="select count(*)  from student where 1=1";
        List paramValue=new ArrayList();
        if(null!=param&&param.size()>0) {
            sql += getParamValue(param, paramValue);
        }
        return jdbcTemplate.queryForObject(sql,paramValue.toArray(),Integer.class);
    }

}
测试文件
package com.yujian.test;

import com.yujian.config.MyConfig;
import com.yujian.dao.StudentDao;
import com.yujian.model.ClassInfo;
import com.yujian.model.Student;
import com.yujian.service.StudentService;
import com.yujian.util.DateFormat;
import com.yujian.util.Page;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.annotation.AnnotationConfigApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class StudentTest {
    @Test
    public void testFindfListStudent(){
ApplicationContext ctx=new AnnotationConfigApplicationContext(MyConfig.class);
        StudentDao studentDao=(StudentDao) ctx.getBean("studentDao");
　　　　 //上面用的全注解方式，若是用配置文件用下面的
　　　　//ApplicationContext ctx=new ClassPathXmlApplicationContext("app*.xml");
　　　　//StudentDao studentDao=(StudentDao) ctx.getBean("studentDao");
 
        List<Student>list=studentDao.findListStudent();
        System.out.println(list);
        System.out.println(3+3.5);
    }
    @Test
    public void testFindfStudentById(){
        ApplicationContext ctx=new AnnotationConfigApplicationContext(MyConfig.class);
        StudentDao studentDao=(StudentDao) ctx.getBean("studentDao");
        Student student=studentDao.findStudentById(1);
        System.out.println(student);
    }
    @Test
    public void testInsertfStudentById(){
        ApplicationContext ctx=new AnnotationConfigApplicationContext(MyConfig.class);
        StudentDao studentDao=(StudentDao) ctx.getBean("studentDao");
        Student student=new Student();
        student.setStuNmae("赵四");
        student.setStuSex(1);
        DateFormat format=new DateFormat();
        String date="1997-03-30";
        student.setStuBirth(format.format(date));
        ClassInfo classInfo=new ClassInfo();
        classInfo.setClassId(1);
        student.setClassInfo(classInfo);
        studentDao.insertStudent(student);
    }
    @Test
    public void testUpdatefStudentById(){
        ApplicationContext ctx=new AnnotationConfigApplicationContext(MyConfig.class);
        StudentDao studentDao=(StudentDao) ctx.getBean("studentDao");
        Student student=new Student();
        student.setStuNmae("刘能");
        student.setStuSex(0);
        DateFormat format=new DateFormat();
        String date="1997-12-30";
        student.setStuBirth(format.format(date));
        ClassInfo classInfo=new ClassInfo();
        classInfo.setClassId(2);
        student.setClassInfo(classInfo);
        student.setStuId(6);
        studentDao.updateStudent(student);
    }
    @Test
    public void testDeleteStudent(){
        ApplicationContext ctx=new AnnotationConfigApplicationContext(MyConfig.class);
        StudentDao studentDao=(StudentDao) ctx.getBean("studentDao");
        studentDao.deleteStudent(7);
    }
    @Test
    public void testListStudentBy(){
        ApplicationContext ctx=new AnnotationConfigApplicationContext(MyConfig.class);
        StudentDao studentDao=(StudentDao) ctx.getBean("studentDao");
        Student student=new Student();
        /*student.setStuNmae("刘能");
        student.setStuSex(0);
        DateFormat format=new DateFormat();
        String date="1997-12-30";
        student.setStuBirth(format.format(date));
        ClassInfo classInfo=new ClassInfo();
        classInfo.setClassId(2);
        student.setClassInfo(classInfo);
        student.setStuId(6);*/
//        student.setStuNmae("李四");
//        student.setStuSex(-1);
        List<Student> students=studentDao.listStudentBy(student);
        System.out.println(students);
    }
    @Test
    public void testListStudent(){
        ApplicationContext ctx=new AnnotationConfigApplicationContext(MyConfig.class);
        StudentDao studentDao=(StudentDao) ctx.getBean("studentDao");
        Map<String,String> map=new HashMap<String, String>();

        /*student.setStuNmae("刘能");
        student.setStuSex(0);
        DateFormat format=new DateFormat();
        String date="1997-12-30";
        student.setStuBirth(format.format(date));
        ClassInfo classInfo=new ClassInfo();
        classInfo.setClassId(2);
        student.setClassInfo(classInfo);
        student.setStuId(6);*/
//        map.put("stuName","李");
        /*List<Student> students=studentDao.findStuentByParam(map,null);
        System.out.println(students);*/
        int row=studentDao.findStudentRowCnt(map);

        System.out.println("row:"+row);
        Page page=new Page();
        page.setRow(row);
        page.setPageSize(3);
        System.out.println("pageCnt:"+page.getPageCnt());
        System.out.println("pageNo1:"+page.getPageNo());
        page.setPageNo(3);
        System.out.println("pageNo2:"+page.getPageNo());
        List<Student> list=studentDao.findStuentByParam(map,page);
        System.out.println(list);
    }
    @Test
    public void testInsertfStudentService(){
        ApplicationContext ctx=new AnnotationConfigApplicationContext(MyConfig.class);
        StudentService studentService=(StudentService) ctx.getBean("studentService");
        Student student=new Student();
        student.setStuNmae("刘芮玲34");
        student.setStuSex(1);
        DateFormat format=new DateFormat();
        String date="1997-03-30";
        student.setStuBirth(format.format(date));
        ClassInfo classInfo=new ClassInfo();
        classInfo.setClassId(1);
        student.setClassInfo(classInfo);
        studentService.insertStudent(student);
    }
}






 

转载于:https://www.cnblogs.com/pursue339/p/10615090.html

dci75702
关注
（十五）JdbcTemplate--update
FixedStar 的博客
03-28 1373
public int update(java.lang.String sql, //sql语句 @Nullable java.lang.Object... args //sql中参数列表 ) throws DataAccessException //返回值是影响的数据...
Spring详解之jdbcTemplate
weixin_46533524的博客
11-16 1103
Spring框架对JDBC进行封装，使用jdbcTemplate方便实现对数据库操作。
11 Spring框架 SpringDAO的JdbcTemplate
m0_37109682的博客
10-12 189
&#13; 上几个章节我们探讨了Spring的IoC和AOP，这是Spring的重点，但是Spring对jdbc的支持同样我们也不能忘记，毕竟我们还要通过Spring来管理DAO框架（例如Hibernate或者MyBatis等）。  Spring对DAO的支持分为大体可以分为以下两个点： Spring与jdbc模板 Spring对事务的管理 本节我们就来看看第一个知识点：...
Spring JdbcTemplate2-update和query
xuwenjingrenca的博客
09-11 379
Spring JdbcTemplate
java jdbctemplate update_Java Spring-JdbcTemplate增删改查
weixin_42486083的博客
02-25 306
2017-11-11 21:13:13Spring 框架中提供了对持久层技术支持的类 :JDBC : org.springframework.jdbc.core.support.JdbcDaoSupportHibernate 3.0 : org.springframework.orm.hibernate3.support.HibernateDaoSupportiBatis : org.spring...
Java jdbctemplate赋值_关于 Spring JdbcTemplate 的一些总结
weixin_29806483的博客
02-16 383
关于 Spring JdbcTemplate 的一些总结一个小问题的思考起因当前项目中一直使用的都是 SpringData JPA ，即 public interface UserRepository extends JpaRepository<User, Serializable> 这种用法；考虑到 SpringData JPA 确实有一定的局限性，在部分查询中使用到了 JdbcTe...
spring的jdbctemplate的crud的基类dao
09-04
总结来说，`Spring`的`JdbcTemplate`和基于它的基类DAO设计是面向数据库操作的一种良好实践。它简化了与数据库的交互，提供了易于理解和使用的API，使得开发者能够更加专注于业务逻辑，而不是底层的数据库操作。通过...
基于Spring MVC, Spring, JdbcTemplate的学生信息管理系统.zip
03-06
同时，JdbcTemplate可以帮助我们编写DAO（Data Access Object）层的代码，方便地进行数据库的CRUD（Create、Read、Update、Delete）操作。 在系统分析与设计阶段，我们需要对需求进行深入理解，定义系统边界，识别...
Spring boot jdbcTemplate
xiao/du的博客
05-07 4052
文章目录上一节 Spring boot lombok源码下一节 Spring boot 数据库连接池Spring boot jdbcTemplate 上一节 Spring boot lombok Spring boot lombok 源码 springboot学习指南 下一节 Spring boot 数据库连接池 Spring boot 数据库连接池 Spring boot jdbcTemplate ...
spring内置jdbctemplate使用demo
06-12
例如，创建一个 Dao 类，该类包含一个使用 `JdbcTemplate` 执行 SQL 查询的方法。 ```java public class UserDao { private JdbcTemplate jdbcTemplate; public void setJdbcTemplate(JdbcTemplate jdbcTemplate...
Spring JdbcTemplate.batchUpdate 例子
08-12
NULL 博文链接：https://rayfuxk.iteye.com/blog/2286519
Jdbctemplate的update方法地简单底层实现与BeanPropertyRowMapper的用法和注意事项
weixin_44108272的博客
02-21 1743
Jdbctemplate update BeanPropertyRowMapper的用法和注意事项
jdbcTemplate 的update 和batchUpdate 方法的使用
datouniao1的博客
03-16 7415
update方法 首先来看update方法 1. sql的生成： 这个方法有三个实现，每一个方法都包含一个sql和另外的一个参数 我们就拿第一个方法为例子：第一个sql应该怎么写 比如插入：insertintotable_name(column1,column2)values(?,?) 更新：updatetable_name set column1=?,column2=?where column3=? and .. 其实我们可以看出来的...
JdbcTmplate中的update方法(代码)基础操作
weixin_45151960的博客
03-03 956
User.java实体类： package com.liu.jdbc.update; public class User { private Integer id; private String username; private String password; public Integer getId() { return id; } public void setId(...
Spring JdbcTemplate的常用方法--update()
weixin_61144851的博客
03-31 1994
一、在com.itheima.jdbc包下创建Account类，在该类中定义id，username和balanca属性，以及对应的setter、getter和tostring方法。三、在com.itheima.jdbc包下创建接口的实现类AccountDaoImpl,并在类中实现添加、更新、删除账户的方法。二、在com.itheima.jdbc包下创建接口AccountDao，并在接口中定义添加、更新和删除账户的方法。update()方法可以完成插入、更新、删除数据的操作。五、在测试类中，添加测试方法。
Spring 框架 执行SQL getJdbcTemplate().query update 用法
技术百宝箱
03-01 4587
<br /><br />Spring JdbcDaoSupport 执行SQL<br />return int: getJdbcTemplate().queryForInt(sql)    select count(*)...<br />return List:getJdbcTemplate().query(sql, rowMapper)   select ... from ...<br />return null:getJdbcTemplate().update(sql)     insert into
Day36——JdbcTemplate的update方法、batchUpdate方法、queryForObject方法、query方法
Android_la的博客
02-01 1039
一. 知识储备 前面Day35——搭建JdbcTemplate环境搭建好JdbcTemplate的环境后，今天开始讲述它们的对数据库操作的方法。 1.1 update方法 /** * update方法：完成增删改 */ @Test public void test() { String sql = "insert into bs_user(username, password, e...
2021-09-08 Spring JdbcTemplate的常用方法之update()
热门推荐
m0_60769905的博客
09-10 1万+
update()方法可以完成插入、更新和删除数据的操作，在Jdbc Template类中，提供了一系列的update()方法。 JdbcTemplate类中常用的update()方法 方法 说明 int update(String sql) 直接传入SQL语句，并返回受影响的行数 int update(PreparedStatementCreator psc) 执行从PreparedStatementCreator返回的语句，然后返回受影响的行数 int update(St
9.2JavaEE——JDBCTemplate的常用方法（二）update()方法
最新发布
PAP
06-17 536
9.2JavaEE——JDBCTemplate的常用方法（二）update()方法
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值