JAVA Mybatic Access MSSQL

3980 ワード
JAVA Mybatis
jar依存org.mybatismybatis 3.5.0 log 4 jlog 4 j 1.2.17 com.microsoft.sqlservermssql-jdbc 7.0.0.jre 8のインポート

プロジェクトルートディレクトリの下にSource Folder(resources)フォルダを作成resourcesディレクトリの下にdb.properties log 4 j.properties mybatis-config.xmldb.propertiesの内容は以下のdriver=com.microsoft.sqlserver.jdbc.SQLServerDriverrurl=jdbc:sqlserver://172.26.205.1:1433;DatabaseName=EGSS_TESTusername=sapassword=1111111
log 4 j.propertiesの内容は以下の通りです.
Global logging configuration
log4j.rootLogger=DEBUG, stdout,dailyRollingFile
MyBatis logging configuration...
log4j.logger.com.skcc.egss.dao.*=DEBUG
Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppenderlog4j.appender.stdout.layout=org.apache.log4j.PatternLayoutlog4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n
File
log4j.appender.dailyRollingFile = org.apache.log4j.DailyRollingFileAppenderlog4j.appender.dailyRollingFile.File = F:\javalog\logredis.loglog4j.appender.dailyRollingFile.Append = truelog4j.appender.dailyRollingFile.Threshold = DEBUGlog4j.appender.dailyRollingFile.layout = org.apache.log4j.PatternLayoutlog4j.appender.dailyRollingFile.layout.ConversionPattern = %-d{yyyy-MM-dd HH:mm:ss} [ %t:%r ] - [ %p ] %c.%M:%L %m%n
mybatis-config.xmlの内容は、br>PUBLIC"-//mybatis.org//TD Config 3.0//EN"http://mybatis.org/dtd/mybatis-3-config.dtd">;

com.skcc.egss.daoパッケージを作成し、そのパッケージの下にSqlSessionFactoryUtil.java EmpMaper.xml EmpDao.javaSqlSessionFactoryUtil.javaの内容は次のとおりです.SqlSessionFactoryUtil{
public static SqlSessionFactory getSqlSessionFactory() throws IOException {

    SqlSessionFactory sqlSessionFactory = null;
    try {
        InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");
         sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
    } catch (IOException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
    return sqlSessionFactory;
}

}EmpMapper.xml内容は、br>PUBLIC"-//mybatis.org//TD Mapper 3.0//EN"http://mybatis.org/dtd/mybatis-3-mapper.dtd">;select top 5*from BASEUSERINFOEmpDao.java内容は以下の通りpublic class EmpDao{
public Logger logger = Logger.getLogger(EmpDao.class);

public List> selectEmpList(Map map){
    logger.info("selectEmpList");
    try (SqlSession session=SqlSessionFactoryUtil.getSqlSessionFactory().openSession()){
        return session.selectList("egss.empinfo.selectEmpList", map);

    } catch (Exception e) {
        // TODO: handle exception
        System.out.println(e);
    }
    return null;

}

}br/>>JUnit 5でテスト@Testpublic void selectEmpList()throws Exception{List>maps=new EmpDao().selectEmpList(null);if(maps!=null){System.out.println("maps.size()++maps.size();System.out.println(maps);}else{System.System.err.println("no data");}テスト結果maps.size(}テスト結果maps.size(}maps.size(}テスト結果maps.size(}():1
TestReference javaパラメータ値
Springでの注記@Profileの使用方法の説明