<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                企業??AI智能體構建引擎,智能編排和調試,一鍵部署,支持知識庫和私有化部署方案 廣告
                # 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" /> <!-- 配置 C3P0 數據源 --> <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> <!-- 配置 Spirng 的 JdbcTemplate --> <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); }
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看