ssi集成，内有简单的增删查改等等，还附有数据库的代码详情-代码-最代码

首页>代码>ssi集成，内有简单的增删查改等等，还附有数据库>/SSIbatise/SSITest/src/com/dao/UserDao.java

01package com.dao;
02 
03import java.util.List;
04import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
05 
06import com.pojo.UserInfos;
07@SuppressWarnings("unchecked")
08public class UserDao extends SqlMapClientDaoSupport implements IUserDao {
09 
10     
11    public List<UserInfos> findAll() {
12        // TODO Auto-generated method stub
13         
14        return this.getSqlMapClientTemplate().queryForList("find_all");
15    }
16 
17    public int delete(int id) {
18        // TODO Auto-generated method stub
19         
20         return this.getSqlMapClientTemplate().delete("delete_userbyId", id);
21    }
22 
23    public int insert(UserInfos user) {
24        // TODO Auto-generated method stub
25        int a=0;
26        this.getSqlMapClientTemplate().insert("insert", user);
27        a=1;
28        return a;
29    }
30 
31    public int update(UserInfos user) {
32        // TODO Auto-generated method stub
33        return this.getSqlMapClientTemplate().update("update", user);
34    }
35 
36    public UserInfos query(int id) {
37        // TODO Auto-generated method stub
38        UserInfos user=null;
39        user=(UserInfos) this.getSqlMapClientTemplate().queryForObject("query", id);
40        return user;
41    }
42 
43    public List<UserInfos> findAll(int current, int maxResult) {
44        // TODO Auto-generated method stub
45        return this.getSqlMapClientTemplate().queryForList("find_all", (current-1)*maxResult, maxResult);
46    }
47}