Ibatis搭建配置.docVIP

Ibatis搭建配置 版本1.0 在新建项目lib中添加扎包 创建包 创建DAO接口 package com.cstp.ibatis; import java.util.List; public interface UserDAO { public ListUserName quereyAll(); public UserName quereyById(int id); } 创建VO实现类 public class UserName { private int id; private String name; private int age; public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { = name; } public int getAge() { return age; } public void setAge(int age) { this.age = age; } public String toString() { String ppt = 主键： + id + 姓名： + name + 年龄： + age; return ppt; } } 写DAO 实现类 public class UserDAOImpl implements UserDAO { private static SqlMapClient sqlMapClient = null; static { try { Reader reader = mon.resources.Resources .getResourceAsReader(com/cstp/ibatis/SqlMapConfig.xml); sqlMapClient = com.ibatis.sqlmap.client.SqlMapClientBuilder .buildSqlMapClient(reader); reader.close(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public UserName quereyById(int id) { // TODO Auto-generated method stub UserName user = null; try { user = (UserName) sqlMapClient.queryForObject(queryById, id); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return user; } public ListUserName quereyAll() { // TODO Auto-generated method stub ListUserName list = null; try { list = sqlMapClient.queryForList(queryAll); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return list; } } 配置XML 文件链接Oracle数据库 ?xml version=1.0 encoding=UTF-8 ? !DOCTYPE sqlMapConfig PUBLIC -//iBATIS.com//DTD SQL MAP Config 2.0//EN /dtd/sql-map-config-2.dtd sqlMapConfig properties resource=com/cstp/ibatis/SqlMperties / transactionManager type=JDBC dataSource type=SIMPLE property name=JDBC.Driver value=${driver} / property name=JDBC.Connect