JDBC Template - 入门篇-白红宇的个人博客

JDBC Template - 入门篇

发布日期：2021-06-30 23:47:24 浏览次数：2 分类：技术文章

本文共 3090 字，大约阅读时间需要 10 分钟。

import com.imooc.sc.entity.Student;import org.springframework.context.ApplicationContext;import org.springframework.context.support.ClassPathXmlApplicationContext;import org.springframework.jdbc.core.JdbcTemplate;import org.springframework.jdbc.core.RowMapper;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import java.util.Date;import java.util.List;import java.util.Map;public class Test {    private JdbcTemplate jdbcTemplate;    {        ApplicationContext context = new ClassPathXmlApplicationContext("spring.xml");        jdbcTemplate = (JdbcTemplate)context.getBean("jdbcTemplate");    }    public void testExecute(){        jdbcTemplate.execute("create table user1(id int,name varchar(20))");    }    public void testUpdate(){        String sql = "insert into student(name,sex) values(?,?)";        jdbcTemplate.update(sql,new Object[]{"张飞","男"});    }    public void testUpdate2(){        String sql = "update student set sex=? where id=?";        jdbcTemplate.update(sql,"女",1003);    }    public void testBatchUpdate(){        String[] sqls={                "insert into student(name,sex) values('关羽','女')",                "insert into student(name,sex) values('刘备','男')",                "update student set sex='女' where id=2001"        };        jdbcTemplate.batchUpdate(sqls);    }    public void testBatchUpdate2(){        String sql = "insert into selection(student,course) values(?,?)";        List
   
     list = new ArrayList
    
     ();        list.add(new Object[]{1005,1001});        list.add(new Object[]{1005,1003});        jdbcTemplate.batchUpdate(sql,list);    }    public void testQuerySimple1(){        String sql = "select count(*) from student";        int count = jdbcTemplate.queryForObject(sql,Integer.class);        System.out.println(count);    }    public void testQuerySimple2(){        String sql = "select name from student where sex=?";        List
     
       names = jdbcTemplate.queryForList(sql,String.class,"女");        System.out.println(names);    }    public void testQueryMap1(){        String sql = "select * from student where id = ?";        Map
      
        stu = jdbcTemplate.queryForMap(sql,1003);        System.out.println(stu);    }    public void testQueryMap2(){        String sql = "select * from student";        List
       
        
         > stus = jdbcTemplate.queryForList(sql); System.out.println(stus); } public void testQueryEntity1(){ String sql = "select * from student where id = ?"; Student stu = jdbcTemplate.queryForObject(sql, new StudentRowMapper(), 1004); System.out.println(stu); } @org.junit.Test public void testQueryEntity2(){ String sql = "select * from student"; List
         
           stus = jdbcTemplate.query(sql,new StudentRowMapper()); System.out.println(stus); } private class StudentRowMapper implements RowMapper
          
           { public Student mapRow(ResultSet resultSet, int i) throws SQLException { Student stu = new Student(); stu.setId(resultSet.getInt("id")); stu.setName(resultSet.getString("name")); stu.setSex(resultSet.getString("sex")); stu.setBorn(resultSet.getDate("born")); return stu; } }}

转载地址：https://lux-sun.blog.csdn.net/article/details/84346863 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！

上一篇：JDBC Template - 基础篇

下一篇：Spring - AOP之AspectJ（XML）

发表评论

关于作者

喝酒易醉，品茶养心，人生如梦，品茶悟道，何以解忧？唯有杜康！

-- 愿君每日到此一游！

发表评论

最新留言

关于作者

推荐文章