久久亚洲国产成人精品无码区,亚洲无线码一区二区三区,亚洲三级电影网址

初次接觸iBatis

廢話少說。開始了。。。。。

1.首先是JAVA類，如下：

package test2;
2

import java.util.Date;
4

public class User {
6

private Long id;
8

private String userName;
10

private int userAge;
12

private Date brithday;
14

// getter and setter
16

}
17

2.和hibernate一樣映射文件：

<?xml version="1.0" encoding="UTF-8" ?>
2

<!DOCTYPE sqlMap
4

PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
5

"http://ibatis.apache.org/dtd/sql-map-2.dtd">
6

<sqlMap namespace="User">
7

<typeAlias alias="User" type="test2.User"/>
8

<resultMap class="User" id="AccountResult">
9

<result property="id" column="ID"/>
10

<result property="userName" column="USER_NAME" />
11

<result property="userAge" column="USER_AGE"/>
12

<result property="brithday" column="USER_BRITHDAY"/>
13

</resultMap>
14

<select id="selectAllUsers" resultMap="AccountResult">
15

select * from USERS
16

</select>
17

<insert id="insertAccount" parameterClass="User">
18

insert into USERS (
19

ID,
20

USER_NAME,
21

USER_AGE,
22

USER_BRITHDAY )
23

values (
24

#id#,#userName#, #userAge#, #brithday#
25

)
26

</insert>
27

</sqlMap>

3.一個測試類：

public class Client {
2

private static SqlMapClient sqlMapper;
4

static {
6

try {
7

Reader reader = Resources.getResourceAsReader("test/SqlMapConfig.xml");
8

sqlMapper = SqlMapClientBuilder.buildSqlMapClient(reader);
9

reader.close();
10

} catch (IOException e) {
11

// Fail fast.
12

throw new RuntimeException("Something bad happened while building the SqlMapClient instance." + e, e);
13

}
14

}
15

public static List<User> selectAllAccounts () throws SQLException {
17

return sqlMapper.queryForList("selectAllUsers");
18

}
19

public static void insert(User user) throws SQLException{
21

sqlMapper.insert("insertAccount", user);
22

}
23

public static void main(String[] args) {
24

User user = new User();
25

user.setUserName("Gordon");
26

user.setUserAge(24);
27

user.setBrithday(new Date());
28

try {
29

Client.insert(user);
30

} catch (SQLException e1) {
31

// TODO Auto-generated catch block
32

e1.printStackTrace();
33

}
34

List<User> list = null;
35

try {
36

list = Client.selectAllAccounts();
37

for(Iterator<User> i = list.iterator();i.hasNext();){
38

System.out.println(i.next().getUserName());
39

}
40

} catch (SQLException e) {
41

e.printStackTrace();
42

}
43

}
45

}

第一個例子完成，還有ibatis.jar mysql.jar

posted on 2008-09-24 23:44 Gordon 閱讀(129) 評論(0) 編輯收藏所屬分類: ibatis

常用鏈接

留言簿(1)

隨筆分類(4)

隨筆檔案(4)

搜索

最新評論

閱讀排行榜

評論排行榜


只有注冊用戶登錄后才能發表評論。




網站導航: 博客園 IT新聞 Chat2DB C++博客博問管理