Java完成mybatis批量拔出數據到Oracle。本站提示廣大學習愛好者:(Java完成mybatis批量拔出數據到Oracle)文章只能為提供參考,不一定能成為您想要的結果。以下是Java完成mybatis批量拔出數據到Oracle正文
比來項目中碰到一個成績:導入數據到後台並將數據拔出到數據庫中,導入的數據量有上萬條數據,斟酌采取批量拔出數據的方法;
聯合網上材料,寫了個小demo,文章末尾附上demo下載地址
1、新建項目:項目目次構造以下圖所示,添加響應的jar包
2、新建數據庫表:ACCOUNT_INFO
CREATE TABLE ACCOUNT_INFO ( "ID" NUMBER(12) NOT NULL , "USERNAME" VARCHAR2(64 BYTE) NULL , "PASSWORD" VARCHAR2(64 BYTE) NULL , "GENDER" CHAR(1 BYTE) NULL , "EMAIL" VARCHAR2(64 BYTE) NULL , "CREATE_DATE" DATE NULL )
3、創立AccountInfo實體類:
package com.oracle.entity; import java.sql.Date; public class AccountInfo { private Long id; private String userName; private String password; private String gender; private String email; private Date createDate; public Long getId() { return id; } public void setId(Long id) { this.id = id; } public String getUserName() { return userName; } public void setUserName(String userName) { this.userName = userName; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public String getGender() { return gender; } public void setGender(String gender) { this.gender = gender; } public String getEmail() { return email; } public void setEmail(String email) { this.email = email; } public Date getCreateDate() { return createDate; } public void setCreateDate(Date createDate) { this.createDate = createDate; } @Override public String toString() { return "AccountInfo [id=" + id + ", userName=" + userName + ", password=" + password + ", gender=" + gender + ", email=" + email + ", createDate=" + createDate + "]"; } }
4、新建接口映照類:AccountInfoMapper.java
package com.oracle.mapper; import java.util.List; import com.oracle.entity.AccountInfo; public interface AccountInfoMapper { /** * 查詢一切的數據 * @return */ List<AccountInfo> queryAllAccountInfo(); /** * 批量拔出數據 * * @param accountInfoList * @return */ int batchInsertAccountInfo(List<AccountInfo> accountInfoList); }
5、創立mybatis設置裝備擺設文件:mybatis-configuration.xml
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration> <environments default="development"> <environment id="development"> <transactionManager type="JDBC" /> <dataSource type="POOLED"> <property name="driver" value="oracle.jdbc.driver.OracleDriver" /> <property name="url" value="jdbc:oracle:thin:@localhost:1521:orcl" /> <property name="username" value="xxx" /> <property name="password" value="xxx" /> </dataSource> </environment> </environments> <mappers> <mapper resource="config/AccountInfoMapper.xml" /> </mappers> </configuration>
6、創立接口映照設置裝備擺設文件:AccountInfoMapper.xml
Oracle的批量拔出數據庫跟MySQL紛歧樣,
MySQL:
INSERT INTO ACCOUNT_INFO(ID, USERNAME,PASSWORD,GENDER, EMAIL,CREATE_DATE)values(,,,,,,)(,,,,,,,)
Oracle:
INSERT INTO ACCOUNT_INFO(ID, USERNAME,PASSWORD,GENDER, EMAIL,CREATE_DATE) (select 1,,,,,, from dual union all select 1,,,,,, from dual)
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.oracle.mapper.AccountInfoMapper"><!-- 接口的全類名 --> <!-- type:實體類的全類名 --> <resultMap id="BaseResultMap" type="com.oracle.entity.AccountInfo"> <id column="ID" property="id" jdbcType="DECIMAL" /> <result column="USERNAME" property="userName" jdbcType="VARCHAR" /> <result column="PASSWORD" property="password" jdbcType="VARCHAR" /> <result column="GENDER" property="gender" jdbcType="CHAR" /> <result column="EMAIL" property="email" jdbcType="VARCHAR" /> <result column="CREATE_DATE" property="createDate" jdbcType="DATE" /> </resultMap> <!-- id 跟接口中的辦法稱號堅持分歧 --> <select id="queryAllAccountInfo" resultMap="BaseResultMap"> select ID, USERNAME,PASSWORD, GENDER, EMAIL, CREATE_DATE from ACCOUNT_INFO </select> <insert id="batchInsertAccountInfo" parameterType="java.util.List"> INSERT INTO ACCOUNT_INFO(ID, USERNAME,PASSWORD,GENDER, EMAIL,CREATE_DATE) ( <foreach collection="list" index="" item="accountInfo" separator="union all"> select #{accountInfo.id}, #{accountInfo.userName}, #{accountInfo.password}, #{accountInfo.gender}, #{accountInfo.email}, #{accountInfo.createDate} from dual </foreach> ) </insert> </mapper>
7、編寫測試類:
package com.oracle.test; import java.io.InputStream; import java.sql.Date; import java.util.ArrayList; import java.util.List; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; import com.oracle.entity.AccountInfo; import com.oracle.mapper.AccountInfoMapper; public class MybatisTest { public static void main(String[] args) throws Exception { String resource = "config/mybatis-configuration.xml"; InputStream inputStream = Resources.getResourceAsStream(resource); SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder() .build(inputStream); SqlSession session = sessionFactory.openSession(); AccountInfoMapper mapper = session.getMapper(AccountInfoMapper.class); List<AccountInfo> accountInfoList = mapper.queryAllAccountInfo(); if (accountInfoList == null) { System.out.println("The result is null."); } else { for (AccountInfo personInfo : accountInfoList) { System.out.println(personInfo); } } mapper.batchInsertAccountInfo(generateData()); session.commit(); } static List<AccountInfo> generateData(){ List<AccountInfo> result = new ArrayList<AccountInfo>(); AccountInfo account = new AccountInfo(); account.setId(3L); account.setUserName("zhangsanfeng"); account.setPassword("123456"); account.setGender("1"); account.setEmail("[email protected]"); account.setCreateDate(new Date(System.currentTimeMillis())); result.add(account); account = new AccountInfo(); account.setId(4L); account.setUserName("zhouzhiruo"); account.setPassword("zhangwuji"); account.setGender("0"); account.setEmail("[email protected]"); account.setCreateDate(new Date(System.currentTimeMillis())); result.add(account); account = new AccountInfo(); account.setId(5L); account.setUserName("zhaomin"); account.setPassword("zhangwuji"); account.setGender("0"); account.setEmail("[email protected]"); account.setCreateDate(new Date(System.currentTimeMillis())); result.add(account); return result; } }
源碼下載:http://xiazai.jb51.net/201606/yuanma/java-oracle(jb51.net).rar
以上就是本文的全體內容,願望對年夜家的進修有所贊助,也願望年夜家多多支撐。