- 浏览: 313087 次
- 性别:
- 来自: 宁波
文章分类
最新评论
-
bqlin1987:
请问是不是ITeye的代码莫名的换行了?
学习SSO-1 Tomcat启用ssl -
a6821122:
在data-config.xml 里的javascript 不 ...
solr导入Oracle日期时间数据的处理 -
jie_kong:
是flexigrid不是flexgrid
FlexGrid自己用的经验 -
zjnbshifox:
呵呵,我也在摸索阶段,谢谢提醒ligywin 写道还需要补充以 ...
CAS自定义Credentials登录 -
ligywin:
还需要补充以下方法import org.apache.comm ...
CAS自定义Credentials登录
1,在web.xml加入Spring的Config配置
2,用spring的MVC,还要加入Spring的Dispatcher,(这里的servlet-name指定了MVC的配置文件ibatis-servlet.xml,也是一个spring的配置文件)
3,dataAccess.xml中加入iBatis的配置
sql-map-client.xml配置
5,Station.xml
6,Station.java ----POJO
7,StationDAO,StationDAOImpl数据访问
ibatis-serlet.xml定义动作
9。ibatis(property)
10.ListStationController.java
ListStation.jsp (MVC 中的V)
xml 代码
- <context-param>
- <param-name>contextConfigLocation</param-name>
- <param-value>
- /WEB-INF/dataAccess.xml /WEB-INF/applicationContext.xml
- </param-value>
- </context-param>
xml 代码
- <servlet>
- <servlet-name>ibatis</servlet-name>
- <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
- <load-on-startup>2</load-on-startup>
- </servlet>
- <servlet-mapping>
- <servlet-name>ibatis</servlet-name>
- <url-pattern>*.go</url-pattern>
- </servlet-mapping>
xml 代码
- <?xml version="1.0" encoding="UTF-8"?>
- <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
- <beans>
- <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
- <property name="driverClassName" value="org.gjt.mm.mysql.Driver"/>
- <property name="url" value="jdbc:mysql://localhost:3306/pulan?useUnicode=true&&characterEncoding=GBK"/>
- <property name="username" value="root"/>
- <property name="password" value=""/>
- </bean>
- <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
- <property name="dataSource" ref="dataSource"/>
- </bean>
- <bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
- <property name="configLocation" value="WEB-INF/sql-map-config.xml"/>
- <property name="dataSource" ref="dataSource"/>
- </bean>
- <bean id="lineDAO" class="dao.ibatis.dao.LineDAOImpl">
- <property name="sqlMapClient" ref="sqlMapClient"/>
- </bean>
- <bean id="stationDAO" class="dao.ibatis.dao.StationDAOImpl">
- <property name="sqlMapClient" ref="sqlMapClient"/>
- </bean>
- <bean id="meterDAO" class="dao.ibatis.dao.MeterDAOImpl">
- <property name="sqlMapClient" ref="sqlMapClient"/>
- </bean>
- <bean id="dataDAO" class="dao.ibatis.dao.DataDAOImpl">
- <property name="sqlMapClient" ref="sqlMapClient"/>
- </bean>
- </beans>
xml 代码
- <?xml version="1.0" encoding="UTF-8"?>
- <!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
- "http://www.ibatis.com/dtd/sql-map-config-2.dtd">
- <sqlMapConfig>
- <sqlMap resource="dao/ibatis/maps/Line.xml"/>
- <sqlMap resource="dao/ibatis/maps/Station.xml"/>
- <sqlMap resource="dao/ibatis/maps/Meter.xml"/>
- <sqlMap resource="dao/ibatis/maps/Data.xml"/>
- </sqlMapConfig>
xml 代码
- <?xml version="1.0" encoding="UTF-8"?>
- <!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd">
- <sqlMap namespace="Station">
- <resultMap id="result" class="dao.ibatis.db.Station">
- <result property="stationID" column="StationID" columnIndex="1"/>
- <result property="stationNumber" column="StationNumber" columnIndex="2"/>
- <result property="stationName" column="StationName" columnIndex="3"/>
- <result property="stationAddress" column="StationAddress" columnIndex="4"/>
- <result property="stationType" column="StationType" columnIndex="5"/>
- <result property="assessType" column="assessType" columnIndex="6"/>
- <result property="transformerCapacity" column="TransformerCapacity" columnIndex="7"/>
- <result property="lineID" column="LineID" columnIndex="8"/>
- </resultMap>
- <select id="getStationList" resultMap="result">
- select * from station
- </select>
- <select id="getStationListByLineID"
- parameterClass="java.lang.String"
- resultMap="result">
- select * from station where `LineID` = #value#
- </select>
- </sqlMap>
java 代码
- package dao.ibatis.db;
- import java.io.Serializable;
- public class Station implements Serializable {
- private int stationID;
- private String stationNumber;
- private String stationName;
- private String stationAddress;
- private int stationType;
- private int assessType;
- private int transformerCapacity;
- private int lineID;
- public int getAssessType() {
- return assessType;
- }
- public void setAssessType(int assessType) {
- this.assessType = assessType;
- }
- public int getLineID() {
- return lineID;
- }
- public void setLineID(int lineID) {
- this.lineID = lineID;
- }
- public String getStationAddress() {
- return stationAddress;
- }
- public void setStationAddress(String stationAddress) {
- this.stationAddress = stationAddress;
- }
- public int getStationID() {
- return stationID;
- }
- public void setStationID(int stationID) {
- this.stationID = stationID;
- }
- public String getStationName() {
- return stationName;
- }
- public void setStationName(String stationName) {
- this.stationName = stationName;
- }
- public String getStationNumber() {
- return stationNumber;
- }
- public void setStationNumber(String stationNumber) {
- this.stationNumber = stationNumber;
- }
- public int getStationType() {
- return stationType;
- }
- public void setStationType(int stationType) {
- this.stationType = stationType;
- }
- public int getTransformerCapacity() {
- return transformerCapacity;
- }
- public void setTransformerCapacity(int transformerCapacity) {
- this.transformerCapacity = transformerCapacity;
- }
- }
java 代码
- package dao.ibatis.dao;
- import java.util.List;
- public interface StationDAO {
- public List getStationList(int LineID);
- }
- package dao.ibatis.dao;
- import java.util.List;
- import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
- public class StationDAOImpl extends SqlMapClientDaoSupport implements
- StationDAO {
- public List getStationList(int LineID) {
- // TODO Auto-generated method stub
- if(LineID <= 0){
- return getSqlMapClientTemplate().queryForList("getStationList", null);
- }else{
- return getSqlMapClientTemplate().queryForList("getStationListByLineID", String.valueOf(LineID));
- }
- }
- }
xml 代码
- <bean name="/listStation.go" class="net.fox.web.ListStationController">
- <property name="ibatis" ref="ibatis"/> //这里的ibatis不是servlet名字,而是一个Spring的bean
- //定义在applicationContext.xml里
- </bean>
xml 代码
- <?xml version="1.0" encoding="UTF-8"?>
- <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
- <beans>
- <bean id="baseTransactionProxy" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean" abstract="true">
- <property name="transactionManager"><ref bean="transactionManager"/></property>
- <property name="transactionAttributes">
- <props>
- <prop key="insert*">PROPAGATION_REQUIRED</prop>
- <prop key="update*">PROPAGATION_REQUIRED</prop>
- <prop key="*">PROPAGATION_REQUIRED,readOnly</prop>
- </props>
- </property>
- </bean>
- <bean id="ibatis" parent="baseTransactionProxy">
- <property name="target">
- <bean class="net.fox.IBatisImpl">
- <property name="lineDAO" ref="lineDAO"/>
- <property name="stationDAO" ref="stationDAO"/>
- <property name="meterDAO" ref="meterDAO"/>
- <property name="dataDAO" ref="dataDAO"/>
- </bean>
- </property>
- </bean>
- </beans>
java 代码
- package net.fox.web;
- import java.util.ArrayList;
- import java.util.HashMap;
- import java.util.List;
- import java.util.Map;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- import net.fox.IBatisImpl;
- import org.springframework.web.servlet.ModelAndView;
- import org.springframework.web.servlet.mvc.Controller;
- import dao.ibatis.db.Station;
- public class ListStationController implements Controller {
- private IBatisImpl ibatis;
- public void setIbatis(IBatisImpl ibatis) {
- this.ibatis = ibatis;
- }
- public ModelAndView handleRequest(HttpServletRequest arg0,
- HttpServletResponse arg1) throws Exception {
- int LineID = Integer.parseInt(arg0.getParameter("line"));
- Map model = new HashMap();
- List l1 = this.ibatis.getStationDAO().getStationList(LineID);
- model.put("stationList", l1);
- return new ModelAndView("ListStation",model);
- }
- }
xml 代码
- <%@page contentType="text/html;charset=GBK"%>
- <%@ taglib prefix="c" uri="/WEB-INF/tld/c.tld" %>
- <%@ taglib prefix="fmt" uri="/WEB-INF/tld/fmt.tld" %>
- <html><head><title>数据查看</title>
- <meta content="text/html; charset=GBK" http-equiv="Content-Type" />
- <META HTTP-EQUIV="Cache-Control" CONTENT="max-age=0">
- <META HTTP-EQUIV="Cache-Control" CONTENT="no-cache">
- <meta http-equiv="expires" content="0">
- <META HTTP-EQUIV="Pragma" CONTENT="no-cache">
- </head>
- <body bgcolor="white">
- <center>
- <font size="4"><b>台区列表</b></font>
- </center>
- <form action="<c:url value="/listMeter.go"/>" method="post">
- <table align="center" bgcolor="#008800" border="0" cellspacing="2" cellpadding="3">
- <tr bgcolor="#CCCCCC"> <td><b>选择台区</b></td> </tr>
- <tr bgcolor="#FFFF88"><td>
- <select name="station">
- <c:forEach var="station" items="${stationList}">
- <option value="<c:out value="${station.stationID}"/>"><c:out value="${station.stationName}"/></option>
- </c:forEach>
- </select>
- </td>
- </tr>
- <tr><td><input type="submit" value="OK"/></td></tr>
- </form>
- </table>
- <%@ include file="footer.jsp" %>
总结:基本上是依靠Spring自带的jpetStore例子来做的,有几个问题,使用的TAGLIb是需要到apache的网站上下载,还有要用到的有cglib,commons,iBatis的jar,cglib是一定要用的
发表评论
-
jasper report与Spring mvc整合
2015-10-19 16:02 1609配置jasper view resolver <be ... -
solr导入Oracle日期时间数据的处理
2013-02-08 10:01 5111参考文章: http://stackoverflow.com/ ... -
solr服务端加亮设置
2013-02-06 23:25 1282在${solr.home}/conf/solrconfig.x ... -
Solr客户端自定义开发
2013-02-06 16:52 1624@Service @Qualifier(" ... -
CAS 客户端获取Credentials额外信息
2013-02-06 09:40 3948服务端的配置 1、在deployerContext.xml中加 ... -
CAS自定义Credentials登录
2013-02-02 00:03 7951先看了这篇文章http://www.blogjava.net/ ... -
Spring data MongoDB DSL
2013-01-29 13:38 2575这两天自己配置了一个通过Spring Data来连接Mongo ... -
Spring MVC和freemarker配置
2013-01-21 13:45 2443参考文章:http://www.cnblogs.com/hoo ... -
我自己的maven环境
2013-01-17 14:37 1074今天把自己的maven环境记录下来,准备重装系统能找到 mav ... -
Spring-data jpa学习
2013-01-17 14:25 1781一个早上加一个中午就耗在这里了啊,就一个小问题,让我吐血不已, ... -
今天学会的DetachedCriteria用法
2013-01-12 22:01 10149以前用hibernate,一般都是使用hql语句的,因为和sq ... -
学习SSO-1 Tomcat启用ssl
2012-11-29 10:41 6950根据网上的http://www.kafeitu.me/sso/ ... -
Solr连接数据库
2012-04-10 09:40 6190要建立自己的全文检索 ... -
Solr试用小记
2012-04-10 09:15 15411、下载tomcat7、solr 3.5.0 以及IKAnal ... -
java生成二维码,qrcode
2012-03-22 15:41 6995通过barcode4j生成 @Controller @R ... -
使用HttpClient 4.1.2调用webservice
2012-01-19 14:22 19143下载httpclient,把压缩包里lib目录的所有jar放到 ... -
Spring MVC3 Hibernate3 Annotation 补充
2011-05-30 11:59 1376通过配置文件进行事务声明 app-config.xml & ... -
Spring MVC3 Hibernate3 Annotation
2011-05-30 11:56 1746web.xml <?xml version=&quo ... -
Tomcat Mod_jk负载均衡Session复制的几点补充
2010-02-24 16:49 1316tomcat和mod_jk进行负载均衡的时候,如果要实现Ses ... -
第一次实际应用Spring MVC
2009-11-17 08:37 1565要做一个简单的投票的东西,看spring mvc的文章已经很久 ...
相关推荐
ibatis 使用手册:ibatis 开发指南、ibatis sql maps、ibatis sql maps 入门教程。
ibatis 相关使用文档及安装包ibatis 相关使用文档及安装包
ibatis简易使用ibatis简易使用ibatis简易使用
使用Ibatis对数据库的访问,实现增删改查的操作 ;
ibatis教程 主要是对这个软件的入门的介绍和如何加载和使用
ibatis学习 ibatis总结 ibatis ibatis ibatis
ibatis适用手册,快速掌握ibatis
ibatis资料ibatis资料ibatis资料ibatis资料ibatis资料ibatis资料ibatis资料ibatis资料ibatis资料
包括ibatis开发的基础教程,以及ibatis在eclipse、myeclipse中搭建开发环境的详细步骤。
ibatis使用指南
Ibatis3,手册,Ibatis3手册,Ibatis3使用手册,Ibatis3参考手册
ibatis 使用简单配置
1.每个实体类需要配置各自的“SqlMap.config”在“config/SysConfig.xml”中,SqlMap,db1.Db1SqlMap就是“ibatis/db1/Db1SqlMap.config”,不同的db将分配不同的mapper类。 2.数据库链接统一放在“config/ibatis/...
ibatis demo,ibatis例子,ibatis示例
iBATIS 级联iBATIS 级联iBATIS 级联
Spring与iBATIS的集成 iBATIS似乎已远离众说纷纭的OR框架之列,通常人们对非常流行的Hibernate情有独钟。但正如Spring A Developer's Notebook作者Bruce Tate 和Justin Gehtland所说的那样,与其他的OR框架相比...
IBatis.Net详细使用手册
iBATIS缓存的使用方法
ibatis的原码 ibatis源码 ibatis源码 ibatis源码
ibatis