不懂關(guān)于JDBC Template基本使用？其實想解決這個問題也不難，下面讓小編帶著大家一起學習，希望大家閱讀完這篇文章后大所收獲。
在營山等地區(qū)，都構(gòu)建了全面的區(qū)域性戰(zhàn)略布局，加強發(fā)展的系統(tǒng)性、市場前瞻性、產(chǎn)品創(chuàng)新能力，以專注、極致的服務理念，為客戶提供成都網(wǎng)站設(shè)計、網(wǎng)站建設(shè) 網(wǎng)站設(shè)計制作按需求定制設(shè)計,公司網(wǎng)站建設(shè),企業(yè)網(wǎng)站建設(shè),品牌網(wǎng)站設(shè)計,成都全網(wǎng)營銷推廣,成都外貿(mào)網(wǎng)站制作,營山網(wǎng)站建設(shè)費用合理。
1.使用maven引用依賴
junit junit 4.11 org.springframework spring-context 5.2.5.RELEASE org.springframework spring-core 5.2.5.RELEASE org.springframework spring-beans 5.2.5.RELEASE org.springframework spring-aop 5.2.5.RELEASE org.springframework spring-jdbc 5.2.5.RELEASE org.springframework spring-tx 5.2.5.RELEASE mysql mysql-connector-java 8.0.19
2.編寫spring的xml文件
<?xml version="1.0" encoding="UTF-8"?>
3.ddl操作（建表之類）
重慶分公司
重慶分公司
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.jdbc.core.JdbcTemplate;
public class test {
@Test
public void test(){
ApplicationContext applicationContext=new ClassPathXmlApplicationContext("myApplication.xml");
JdbcTemplate springTemplate = (JdbcTemplate) applicationContext.getBean("jdbcTemplate");
springTemplate.execute("create table test(id int,username varchar(10))");
}
}4.增刪改：
對應的使用例子
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('關(guān)羽','女')",
"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);
} 5.查詢
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;
}
} 
感謝你能夠認真閱讀完這篇文章，希望小編分享關(guān)于JDBC Template基本使用介紹內(nèi)容對大家有幫助，同時也希望大家多多支持創(chuàng)新互聯(lián)，關(guān)注創(chuàng)新互聯(lián)行業(yè)資訊頻道，遇到問題就找創(chuàng)新互聯(lián)，詳細的解決方法等著你來學習!
