main.java

iBatis-在SQL里硬编码的例子-Java源码

import java.util.List;

import com.ibatis.sqlmap.client.SqlMapClient;

public class Main {

  public static void main(String[] a) throws Exception {
    Util util = new Util();
    util
        .executeSQLCommand("create table ACCOUNT(ACC_ID int, ACC_FIRST_NAME varchar,ACC_LAST_NAME varchar,ACC_EMAIL varchar);");
    util.executeSQLCommand("create table Message(Message_ID int, content varchar);");

    SqlMapClient sqlMapper = util.getSqlMapClient();

    Account account = new Account();
    account.setId(1);
    account.setEmailAddress("e");
    account.setFirstName("first");
    account.setLastName("last");

    sqlMapper.insert("insertAccount", account);
    util.checkData("select * from account");

    List list = sqlMapper.queryForList("getByLike", "e");
    
    System.out.println(((Account)list.get(0)).getLastName());

  }

}