ibatis瀛︿範绗旇�� - 鐧惧害鏂囧簱

棣栭〉

搴撳簱AI

骞垮満

鍘嗗彶

鏀惰棌

浜戠洏

鐭ヨ瘑搴?/div>

ibatis

瀛︿範绗旇��

 

1

銆?/p>

 

鎼�寤虹幆澧冿�?/p>

 

锛?/p>

1

锛?/p>

銆佸垱寤?/p>

ibatis_test

椤圭洰銆?/p>

 

锛?/p>

2

锛?/p>

銆佹坊鍔?/p>

SQL2000

椹卞姩鍖?/p>

msbase.jar

銆?/p>

mssqlserver.jar

銆?/p>

msutil.jar

鍜?/p>

ibatis-2.3.3.720.jar

鍖呫�?/p>

 

2

銆侀厤缃�鏂囦欢锛�

 

锛?/p>

1

锛?/p>

銆?/p>

JDBC

杩炴帴灞炴�ф枃浠讹細鍦?/p>

src

鐩�褰曚笅娣诲�?/p>

SqlMap.properties

灞炴�ф枃浠讹紝涓昏�佸寘鎷�

JDBC

杩?

鎺ョ殑涓昏�佷俊鎭�锛?/p>

driver=

锛?/p>

url=

锛?/p>

username=

锛?/p>

password=,

涔熷彲浠ヨ��

JDBC

杩炴帴鐨?/p>

淇℃伅鐩存帴鍐欏埌鎬婚厤缃�鏂囦欢涓�銆?/p>

 

锛?/p>

2

锛?/p>

銆侀厤缃�姣忎釜瀹炰綋鐨勬槧灏勬枃浠讹�?/p>

map

鏂囦欢锛?/p>

锛?/p>

 

濡?/p>

Student.xml

鏂囦欢锛屽叾涓昏�佹槸鍖呮嫭瀵瑰疄浣撹繘琛�

CURD

鎿嶄綔鐨?/p>

SQL

璇�鍙ョ殑鏄犲皠銆?/p>

 

锛?/p>

3

锛?/p>

銆佹坊鍔犳�婚厤缃�鏂囦欢锛�

锛堝弬瑙?/p>

SqlMapConfig.xml

鏂囦欢锛?/p>

 

 

 

 

鍏朵富瑕佸姛鑳芥槸瀵煎叆

SqlMap.properties

鍜?/p>

Student.xml

鏂囦欢锛岃繘琛岀粺涓�绠＄悊

 

3

銆佸垱寤虹浉搴旂殑绫伙細

 

锛?/p>

1

锛?/p>

銆佸缓绔嬪疄浣撶被

Student.java

绫汇�?/p>

 

锛?/p>

2

锛?/p>

銆佸缓绔嬬�＄悊绫绘帴鍙�

StudentDao

锛屽拰瀹炵幇绫?/p>

StudentDaoImpl 

4

銆佹祴璇?/p>

CRUD

鎿嶄綔锛?/p>

 

锛?/p>

1

锛夈�佸湪

StudentDaoImpl

绫讳腑娣诲姞璇诲彇閰嶇疆

 

 

锛?/p>

2

锛?/p>

銆佹祴璇曟煡璇㈡墍鏈変俊鎭�鐨勬柟娉�

queryAllStudent

锛堬級锛屽湪

Student.xml

鏂囦欢涓�閰嶇�?/p>

SQL

璇�鍙ユ槧灏勪俊鎭�銆備緥濡傦細

 

 

<

鈥?/p>

-- 

鏌ユ壘鎵�鏈夌敤鎴?/p>

 -->

 

 

<

select 

id

=

"selectAllStudents" 

resultClass

=

"Student" 

>

 

 

 

select * from t_student; 

 

 

</

select

>

 

鍦?/p>

queryAllStudent

锛堬級鏂规硶涓�浣跨�?/p>

sqlMapClient

鐨?/p>

queryForList

锛堬級鏂规硶杩涜�岃皟鐢�锛?/p>

 

 

public

 List<Student> queryAllStudent() { 

 

 

List<Student> studntList = 

null

; 

 

 

try

 { 

 

 

 

studntList=

sqlMapClient

.queryForList(

"selectAllStudents"

); 

 

 

} 

catch

 (SQLException e) {