3.3 Spring Jdbc · java

# Jdbc Spring使用相關jar包： jdbc spring jdbc pool(c3p0為例子) c3p0配置文件db.properties jdbc.user=root //數據庫用戶名 jdbc.password=root123 //數據庫密碼 jdbc.driverClass=com.mysql.jdbc.Driver jdbc.jdbcUrl=jdbc:mysql:///goods //連接的數據庫 jdbc.initPoolSize=5 jdbc.maxPoolSize=10 spring Bean配置文件  <context:property-placeholder location="classpath:db.properties" />  <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> <property name="user" value="${jdbc.user}"></property> <property name="password" value="${jdbc.password}"></property> <property name="jdbcUrl" value="${jdbc.jdbcUrl}"></property> <property name="driverClass" value="${jdbc.driverClass}"></property> <property name="initialPoolSize" value="${jdbc.initPoolSize}"></property> <property name="maxPoolSize" value="${jdbc.maxPoolSize}"></property> </bean>  <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"> <property name="dataSource" ref="dataSource"></property> </bean> > ## JdbcTemplate jt:為上面配置的JdbcTemplate對象實例； - 更新 ``` public void testUpdate(){ String sql = "update user set u_name =? where u_id=?"; jt.update(sql,"王尼瑪","3"); } - 插入單獨插入操作 ``` public void test2_1(){ String sql = "insert into user(u_name,u_jifen) values (?,?)"; int update = jt.update(sql,"妲己","233"); } ``` 批量插入操作 ``` public void test2(){ String sql = "insert into user (u_name,u_jifen) values (?,?)"; List<Object []> list = new ArrayList<Object []>(); list.add(new Object []{"劉茶幾1","100"}); list.add(new Object []{"劉茶幾2","100"}); list.add(new Object []{"劉茶幾3","100"}); list.add(new Object []{"劉茶幾4","100"}); jt.batchUpdate(sql,list); } ``` - 查詢查詢多條數據 ``` //需要創建一個RowMapper對象。然后指定泛型。接口常用的實現類。BeanPropertyRowMapper ...可以在構造器中指定， //你要把查詢到的數據對應到那個類的屬性當中 public void Test4(){ String sql = "select * from user"; RowMapper<User> rowMapper = new BeanPropertyRowMapper<>(User.class); List<User> result = jt.query(sql, rowMapper); for (User user : result) { System.out.println(user); } } public void Test6(){ String sql = "select u_name from user where u_jifen=?"; List<String> queryForList = jt.queryForList(sql, String.class,"100"); System.out.println(queryForList); } ``` 查詢單獨數據 ``` public void Test5(){ String sql = "select u_jifen from user where u_name=?"; Integer jifen = jt.queryForObject(sql, Integer.class, "張全蛋"); System.out.println(jifen); }