ibatis主键生成方式 用序列实现自动增长 查询方式

select seqname.currval from dual   查询序列当前值


select seqname.nextval from dual   查询序列下一值


主键用序列来建立   


   1.先新建一个序列SEQ_RD_CI_APPSUBSYSTEM_ID
  <selectKey resultClass="Integer" keyProperty="id">      //将值赋值给id
select SEQ_RD_CI_APPSUBSYSTEM_ID.currval from dual
</selectKey>


 < selectKey> 来支持主键自动生成

keyProperty="id" 定义了主键名称   resultClass="Integer" 定义返回类型 

在此处也可以将#sid#改为studentPKSequence.nextVal来实现同样的效果

<sqlMap namespace="changeReport">
<!-- 代表的是resultclass的简写 -->
<typeAlias alias="ChgDto" type="com.readysoft.report.change.model.ChgDto" />


<!-- 变更状态报表 

Map<String, Object> condition = new HashMap<String, Object>();
condition.put("mt1", mt1);
condition.put("mt2", mt2);
  List<ChgDto>  chg_list=changeReportService.ChangeStatus(condition); 需要num和status   -->     

<select id="changeStatus" resultClass="ChgDto"  parameterClass="Map">
select  count(chg.id)num, sta.sym status 
from  RD_CHG chg,RD_CHGSTAT sta  
where chg.status=sta.code 
and chg.OPEN_DATE  between #mt1# and #mt2#
group by sta.sym 
</select>

<!--
OPEN_DATE
 因为chg的open_date都为空     所以改为LAST_MOD_DT,
  因为后者有时间  LAST_MOD_DT有时间-->
  
  
<!-- 关闭变更    ChgDto.setMt1(mt1); ChgDto.setMt2(mt2);-->
<select id="changeClosed" resultClass="Integer"  parameterClass="ChgDto">
select  count(chg.id) num 
from  RD_CHG chg,RD_CHGSTAT sta  
where chg.status=sta.code 
and  chg.status='Closed'
and chg.CLOSE_DATE between #mt1# and #mt2#
</select>

package com.car.dao;import java.io.*;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import java.util.List;import com.car.dto.CarInfoDTO;import com.car.dto.CarValueDTO;import com.car.jdbc.DB;import com.ibatis.sqlmap.client.SqlMapClient;public class CarValueDAOimpl_ibatis implements CarValueDAO {public static SqlMapClient  sqlMapClient=null;static{Reader reader;try {reader = com.ibatis.common.resources.Resources.getResourceAsReader("SqlMapConfig.xml");sqlMapClient=com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(reader);reader.close();} catch (IOException e) {// TODO Auto-generated catch blocke.printStackTrace();}}public void add(CarValueDTO carvaluedto) {}public void delete(int num) {}public List<CarValueDTO> findAll() {List<CarValueDTO> carList=null;try {carList=sqlMapClient.queryForList("car.selectAllCar");} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}return carList;}public CarValueDTO findBynum(int num) {//List<CarValueDTO> carList=null;CarValueDTO carValueDTO=null;try {carValueDTO=(CarValueDTO) sqlMapClient.queryForObject("car.selectcarBynum", num);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}return carValueDTO;}public void update(CarValueDTO carvaluedto) {}public static void main(String[] args) {    List<CarValueDTO> car_list=new CarValueDAOimpl_ibatis().findAll();/*for (int i = 0; i < car_list.size(); i++) {System.out.println(car_list.get(i).getCarnum());}for(CarValueDTO  carValueDTO:new CarValueDAOimpl_ibatis().findAll()){System.out.println(carValueDTO.getCarnum());}*/    CarValueDTO  carValueDTO = new CarValueDAOimpl_ibatis().findBynum(10);System.out.println(carValueDTO.getCarnum()+"   "+carValueDTO.getCost());}}

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd" ><sqlMap namespace="car"><!-- typeAlias 给类取别名 --><typeAlias alias="Car" type="com.car.dto.CarValueDTO" /><!-- 返回对象类型的数据 --><select id="selectAllCar"  resultClass="Car"> select * from carvalue</select>   <select id="selectcarBynum" parameterClass="Integer"  resultClass="Car">   select * from  carvalue  where carnum=#carnum#   </select>      <insert id="">   </insert>   </sqlMap>  

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd" >
<sqlMap namespace="changeReport">
<!-- 代表的是resultclass的简写 -->
<typeAlias alias="ChgDto" type="com.readysoft.report.change.model.ChgDto" />


<!-- 变更状态报表 
    需要num和status   -->     
<select id="changeStatus" resultClass="ChgDto"  parameterClass="Map">
select  count(chg.id)num, sta.sym status 
from  RD_CHG chg,RD_CHGSTAT sta  
where chg.status=sta.code 
and chg.OPEN_DATE  between #mt1# and #mt2#
group by sta.sym 
</select>

<!--
OPEN_DATE
 因为chg的open_date都为空     所以改为LAST_MOD_DT,
  因为后者有时间  LAST_MOD_DT有时间-->
  
  
<!-- 关闭变更 -->
<select id="changeClosed" resultClass="Integer"  parameterClass="ChgDto">
select  count(chg.id) num 
from  RD_CHG chg,RD_CHGSTAT sta  
where chg.status=sta.code 
and  chg.status='Closed'
and chg.CLOSE_DATE between #mt1# and #mt2#
</select>


 <!-- 新建变更 -->
    <select id="changeCreated" resultClass="Integer" parameterClass="ChgDto">
select  count(chg.id) num1 
from   RD_CHG chg
where   chg.OPEN_DATE between #mt1# and #mt2#
</select>


<!--变更分类  所有的 -->
<select id="changeType" resultClass="ChgDto" >
select  count(chg.id) num,ctg.SYM
from   RD_CHG chg,RD_CHG_CATEGORY ctg 
where chg.Z_CHG_CATEGORY=ctg.ID
group by ctg.SYM 
</select>






<!-- 变更分类 -->
<!-- 网络设备 -->
<select id="changeType1" resultClass="Integer" parameterClass="ChgDto">
select  count(chg.id) num
from   RD_CHG chg,RD_CHG_CATEGORY ctg 
where chg.Z_CHG_CATEGORY=ctg.ID
where ctg.ID=61
and chg.OPEN_DATE between #mt1# and #mt2# 
group by ctg.SYM 
</select>

<!-- 软件产品 -->
<select id="changeType2" resultClass="Integer" parameterClass="ChgDto">
select  count(chg.id) num
from   RD_CHG chg,RD_CHG_CATEGORY ctg 
where chg.Z_CHG_CATEGORY=ctg.ID
where ctg.ID=163
and chg.OPEN_DATE between #mt1# and #mt2# 
group by ctg.SYM 
</select>

<!-- 主机设备 -->
<select id="changeType3" resultClass="Integer" parameterClass="ChgDto">
select  count(chg.id) num
from   RD_CHG chg,RD_CHG_CATEGORY ctg 
where chg.Z_CHG_CATEGORY=ctg.ID
where ctg.ID=165
and chg.OPEN_DATE between #mt1# and #mt2# 
group by ctg.SYM 
</select>


  
   




</sqlMap>