inputregisterdao.java

hibernate应用测试,初学hibernate 的会员可以看看.

package com.dao;

import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;
import com.ibatis.common.resources.Resources;

import java.io.Reader;
import java.io.IOException;
import java.util.List;
import java.sql.SQLException;

import com.tool.pagetool.*;
import com.bean.*;
public class InputRegisterDAO extends PageDAO{
    public static List selectAllInputRegister() throws SQLException {
        return sqlMapper.queryForList("selectAllInputRegister");
   }

   public static InputRegister selectInputRegisterByinRegiId(int id) throws SQLException {
       return (InputRegister) sqlMapper.queryForObject("selectInputRegisterByinRegiId",       new Integer(id));
   }

   public static void insertInputRegister(InputRegister inputregister) throws SQLException {
      sqlMapper.insert("insertInputRegister", inputregister);
   }

   public static void updateInputRegister(InputRegister inputregister) throws SQLException {
       sqlMapper.update("updateInputRegister", inputregister);
   }

   public static void deleteInputRegisterByinRegiId(int id) throws SQLException {
        sqlMapper.delete("deleteInputRegisterByinRegiId", new Integer(id));
    }

   public int selectCount(Page page) throws SQLException{
        return ((Integer)sqlMapper.queryForObject("selectInputRegisterCount",page)).intValue();
    }

   public int selectCount() throws SQLException{
        return ((Integer)sqlMapper.queryForObject("selectInputRegisterCountNotP")).intValue();
    }

   public List selectForPage(Page page) throws SQLException{
        List pageList = sqlMapper.queryForList("selectInputRegisterForPage",page);
        return pageList;
    }

   public static void startTransation()throws SQLException{
        sqlMapper.startTransaction();
    }

     public static void startTransation(int i)throws SQLException{
        sqlMapper.startTransaction(i);
     }

   public static void rollback() throws SQLException{
        sqlMapper.endTransaction();
     }

   public static void commit()throws SQLException{
        sqlMapper.commitTransaction();
    }

  public static int getLastId() throws SQLException{
       Object obj = sqlMapper.queryForObject("selectInputRegisterLastId");
       if(obj==null) return 0;
       else
       return ((Integer)obj).intValue();
    }

    public static void updateInputInformStateTo1(int id) throws SQLException {
         sqlMapper.delete("updateInputInformStateTo1", new Integer(id));
    }

    public static void updateInputInformStateTo0(int id) throws SQLException {
         sqlMapper.delete("updateInputInformStateTo0", new Integer(id));
    }

    public static void deleteInputRegister(int id) throws SQLException {
         sqlMapper.delete("deleteInputRegister", new Integer(id));
    }

    public static void activeInputRegister(int id) throws SQLException {
         sqlMapper.delete("activeInputRegister", new Integer(id));
    }

    public static void updateInputRegisterRegisterStateTo0(int id) throws SQLException{
        sqlMapper.update("updateInputRegisterRegisterStateTo0",new Integer(id));
    }

    public static int selectInputRegisterByinApId(int id) throws SQLException{
         Object obj = sqlMapper.queryForObject("selectInputRegisterByinApId",new Integer(id));
         if(obj==null) return -1;
         else
         return ((Integer)obj).intValue();
    }

}