1 ibatis配置文件
2 实体类
3 map配置
4 测试类
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMapConfig
PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
<transactionManager type="JDBC" commitRequired="false">
<dataSource type="SIMPLE">
<property name="JDBC.Driver" value="com.mysql.jdbc.Driver" />
<property name="JDBC.ConnectionURL" value="jdbc:mysql://localhost/jprojector"/>
<property name="JDBC.Username" value="root"/>
<property name="JDBC.Password" value="123456"/>
</dataSource>
</transactionManager>
<sqlMap resource="domain/Login.xml" />
<!-- <sqlMap resource="domain/LoginGroup.xml" /> -->
</sqlMapConfig>
2 实体类
package domain;
public class Login {
private Integer loginId;
private String login;
private String password;
private Integer groupId;
public Login(){}
public Login(String login, String password){
this.login=login;
this.password=password;
}
public int getLoginId() {
return loginId;
}
public void setLoginId(int loginId) {
this.loginId = loginId;
}
public String getLogin() {
return login;
}
public void setLogin(String login) {
this.login = login;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public Integer getGroupId() {
return groupId;
}
public void setGroupId(int groupId) {
this.groupId = groupId;
}
}
3 map配置
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap
PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap namespace="Login">
<typeAlias alias="Login" type="domain.Login" />
<resultMap class="Login" id="LoginResult">
<result property="loginId" column="loginid" />
<result property="login" column="login" />
<result property="password" column="password" />
<result property="groupId" column="login_groupid" />
</resultMap>
<!-- select Login by id -->
<select id="selectLoginById" parameterClass="int" resultClass="Login">
select loginid as loginId, login, password, login_groupid as groupId from Login where loginid=#loginid#
</select>
<!-- select all -->
<select id="selectAllLogin" resultMap="LoginResult">
select * from login
</select>
<!-- insert -->
<insert id="insertLogin" parameterClass="Login">
insert into login (login, password
<dynamic prepend=",">
<isNotNull property="groupId">
login_groupid
</isNotNull>
</dynamic>
) values(#login#, #password#
<dynamic prepend=",">
<isNotNull property="groupId">
#groupId#
</isNotNull>
</dynamic>
)
</insert>
</sqlMap>
4 测试类
package util;
import java.io.IOException;
import java.io.Reader;
import java.sql.SQLException;
import java.util.List;
import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;
import domain.Login;
public class Test {
private static SqlMapClient sqlMapper;
static{
try {
Reader reader=Resources.getResourceAsReader("config.xml");
sqlMapper=SqlMapClientBuilder.buildSqlMapClient(reader);
reader.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
throw new RuntimeException("Something bad happened while building the SqlMapClient instance." + e, e);
}
}
public static Login selectLoginById (int loginid) throws SQLException {
return (Login)sqlMapper.queryForObject("selectLoginById", loginid);
}
public static List selectAllLogin() throws SQLException{
return sqlMapper.queryForList("selectAllLogin");
}
public static void insertLogin(Login login) throws SQLException{
sqlMapper.insert("insertLogin", login);
}
public static void main(String[] args) {
// TODO Auto-generated method stub
try {
Login login=new Login("aaa@bbb.com","123456");
login.setGroupId(1);
insertLogin(login);
//Login login=selectLoginById(1);
//System.out.println(login.getLogin());
//List<Login> all=selectAllLogin();
//for(Login u:all){
//System.out.println(u.getLoginId()+"|"+u.getLogin()+"|"+u.getPassword());
//}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}