oracle+springmvc整合mybatis+mybatis注册页面怎么写

来源：蜘蛛抓取(WebSpider) 时间：2016-04-22 04:24 标签： springmvcmybatis项目
现在位置：
基于Spring4框架的三层架构，使用了SpringMVC框架，EasyUI作为展示层，业务逻辑层和数据访问层使用了Spring4集成MyBatis。
系统介绍：1. 该框架的开发环境为EclipseJEE集成开发工具。2. 基于Spring4框架的三层架构开发完成。3. Mybatis版本为：3.2.8。4. 使用了SpringMVC框架，Spring4的xml配置和注解配置。5. 前台展示页面使用了JQuery EasyUI的布局、列表和消息组件。6. 系统实现了较为完善的用户模块，对用户数据实现了增、删、改、查、分页等的功能。展现界面：下载：链接： 密码：t0uv&&&&Spring+SpringMVC+Mybatis+oracle整合实例
Spring+SpringMVC+Mybatis+oracle整合实例
Spring+SpringMVC+Mybatis+oracle整合实例
若举报审核通过，可奖励20下载分
被举报人：
举报的资源分：
请选择类型
资源无法下载
资源无法使用
标题与实际内容不符
含有危害国家安全内容
含有反动色情等内容
含广告内容
版权问题，侵犯个人或公司的版权
*详细原因：
VIP下载&&免积分60元/年（1200次）
您可能还需要
开发技术下载排行springMVC+mybatis +oracle（4）
&&& 网上查了一下，批量插入的基本都是用union 插入的，这个在数据量大的时候会有问题，
& &insert id=&addPartTimerInf&&& parameterType=&java.util.List&&
& && &&& &&foreach collection=&list& item=&item& index=&index&& open=&begin& close=&;& separator=&;&& &
& && &&& &&& &insert& into CFG_USER_PART_TIME
& && &&& &&& &(ID_, USER_ID, SAP_COST_CENTER_ID, STATE, STATE_TIME, USER_NAME, SAP_COST_CENTER_NAME ) &
& && &&& &&& &values (SEQ_CFG_USER_PART_TIME.NEXTVAL,
&&&&& &&& &&& &#{item.userId,jdbcType=VARCHAR},
&&&&& &&& &&& &#{item.sapCostCenterId,jdbcType=VARCHAR},
&&&&&&& &&& &#{item.state,jdbcType=CHAR},
&&&&&&& &&& &SYSDATE,
&&&&&&& &&& &#{item.userName,jdbcType=NVARCHAR},
&&&&&&& &&& &#{item.sapCostCenterName,jdbcType=NVARCHAR})
&&& &&& &&/foreach&
& &/insert&
用这种方式就不会有问题了，不过要注意的是，不管插入多少条，返回的都是-1，判断是否插入成功我们可以根据捕获异常来判断，如果有异常则插入失败，否则成功。
顺带提一下，前台传数据最好用post的方式，如果网络报405错误，controller层 @RequestMapping(value = URLConstants.PARTTIMERCONTROLLER_ADDPARTT,method = RequestMethod.POST)& 这里的method必须要post，否则就会405异常。
参考知识库
* 以上用户言论只代表其个人观点，不代表CSDN网站的观点或立场
访问：2289次
排名：千里之外
原创：24篇
(5)(3)(1)(1)(18)(2)<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
您的访问请求被拒绝 403 Forbidden - ITeye技术社区
您的访问请求被拒绝
亲爱的会员，您的IP地址所在网段被ITeye拒绝服务，这可能是以下两种情况导致：
一、您所在的网段内有网络爬虫大量抓取ITeye网页，为保证其他人流畅的访问ITeye，该网段被ITeye拒绝
二、您通过某个代理服务器访问ITeye网站，该代理服务器被网络爬虫利用，大量抓取ITeye网页
请您点击按钮解除封锁&首先项目结构
&project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"&
&modelVersion&4.0.0&/modelVersion&
&groupId&com.maven&/groupId&
&artifactId&springMvc_MyBatis&/artifactId&
&packaging&war&/packaging&
&version&0.0.1-SNAPSHOT&/version&
&name&springMvc_MyBatis Maven Webapp&/name&
&url&http://maven.apache.org&/url&
&dependencies&
&!-- JUnit testing framework --&
&dependency&
&groupId&junit&/groupId&
&artifactId&junit&/artifactId&
&version&3.8.1&/version&
&scope&test&/scope&
&/dependency&
&!-- Spring framework --&
&dependency&
&groupId&org.springframework&/groupId&
&artifactId&spring-context&/artifactId&
&version&3.2.6.RELEASE&/version&
&/dependency&
&dependency&
&groupId&org.springframework&/groupId&
&artifactId&spring-jdbc&/artifactId&
&version&3.2.6.RELEASE&/version&
&/dependency&
&!-- Spring AOP dependency --&
&dependency&
&groupId&cglib&/groupId&
&artifactId&cglib&/artifactId&
&version&2.2&/version&
&/dependency&
&!-- MySQL database driver --&
&dependency&
&groupId&mysql&/groupId&
&artifactId&mysql-connector-java&/artifactId&
&version&5.0.5&/version&
&/dependency&
&dependency&
&groupId&dom4j&/groupId&
&artifactId&dom4j&/artifactId&
&version&1.6.1&/version&
&/dependency&
&dependency&
&groupId&commons-dbcp&/groupId&
&artifactId&commons-dbcp&/artifactId&
&version&1.4&/version&
&/dependency&
&dependency&
&groupId&commons-logging&/groupId&
&artifactId&commons-logging&/artifactId&
&version&1.1.1&/version&
&/dependency&
&dependency&
&groupId&commons-collections&/groupId&
&artifactId&commons-collections&/artifactId&
&version&3.2.1&/version&
&/dependency&
&dependency&
&groupId&antlr&/groupId&
&artifactId&antlr&/artifactId&
&version&2.7.7&/version&
&/dependency&
&dependency&
&groupId&org.mybatis&/groupId&
&artifactId&mybatis&/artifactId&
&version&3.2.3&/version&
&/dependency&
&dependency&
&groupId&org.springframework&/groupId&
&artifactId&spring-webmvc&/artifactId&
&version&3.1.1.RELEASE&/version&
&/dependency&
&dependency&
&groupId&org.springframework&/groupId&
&artifactId&spring-test&/artifactId&
&version&3.1.1.RELEASE&/version&
&/dependency&
&dependency&
&groupId&org.mybatis&/groupId&
&artifactId&mybatis-spring&/artifactId&
&version&1.2.1&/version&
&/dependency&
&dependency&
&groupId&c3p0&/groupId&
&artifactId&c3p0&/artifactId&
&version&0.9.1.2&/version&
&/dependency&
&dependency&
&groupId&org.aspectj&/groupId&
&artifactId&aspectjweaver&/artifactId&
&version&1.7.4&/version&
&/dependency&
&dependency&
&groupId&org.codehaus.jackson&/groupId&
&artifactId&jackson-core-asl&/artifactId&
&version&1.9.11&/version&
&/dependency&
&dependency&
&groupId&org.codehaus.jackson&/groupId&
&artifactId&jackson-core-lgpl&/artifactId&
&version&1.9.11&/version&
&/dependency&
&dependency&
&groupId&org.codehaus.jackson&/groupId&
&artifactId&jackson-mapper-asl&/artifactId&
&version&1.9.11&/version&
&/dependency&
&dependency&
&groupId&org.codehaus.jackson&/groupId&
&artifactId&jackson-mapper-lgpl&/artifactId&
&version&1.9.11&/version&
&/dependency&
&dependency&
&groupId&commons-io&/groupId&
&artifactId&commons-io&/artifactId&
&version&2.4&/version&
&/dependency&
&dependency&
&groupId&commons-fileupload&/groupId&
&artifactId&commons-fileupload&/artifactId&
&version&1.2.2&/version&
&/dependency&
&!-- httpclient --&
&dependency&
&groupId&org.apache.httpcomponents&/groupId&
&artifactId&httpclient&/artifactId&
&version&4.2.2&/version&
&/dependency&
&!-- log日志 --&
&dependency&
&groupId&log4j&/groupId&
&artifactId&log4j&/artifactId&
&version&1.2.9&/version&
&/dependency&
&!--servlet --&
&dependency&
&groupId&javax.servlet&/groupId&
&artifactId&jstl&/artifactId&
&version&1.2&/version&
&/dependency&
&dependency&
&groupId&taglibs&/groupId&
&artifactId&standard&/artifactId&
&version&1.1.2&/version&
&/dependency&
&dependency&
&groupId&javaee&/groupId&
&artifactId&javaee-api&/artifactId&
&version&5&/version&
&scope&provided&/scope&
&/dependency&
&/dependencies&
&finalName&springMvc_MyBatis&/finalName&
&/project&
使用maven install下载需要的jar包。
之后一步一步实现这一个简单的小例子。
一个特别好的例子的网址
/code/96610.html
本机运行结果：
主要代码：
package com.bky.
public class Add {
public String getId() {
public void setId(String id) {
this.id = id == null ? null : id.trim();
public String getTname() {
public void setTname(String tname) {
this.tname = tname == null ? null : tname.trim();
public String getTpwd() {
public void setTpwd(String tpwd) {
this.tpwd = tpwd == null ? null : tpwd.trim();
AddMapper.java
package com.bky.
import java.util.L
import com.bky.model.A
public interface AddMapper {
int deleteByPrimaryKey(String id);
int insert(Add record);
int insertSelective(Add record);
Add selectByPrimaryKey(String id);
int updateByPrimaryKeySelective(Add record);
int updateByPrimaryKey(Add record);
List&Add& getAll();
AddMapper.xml
&?xml version="1.0" encoding="UTF-8" ?&
&!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" &
&mapper namespace="com.bky.dao.AddMapper" &
&resultMap id="BaseResultMap" type="com.bky.model.Add" &
&id column="id" property="id" jdbcType="VARCHAR" /&
&result column="tname" property="tname" jdbcType="VARCHAR" /&
&result column="tpwd" property="tpwd" jdbcType="VARCHAR" /&
&/resultMap&
&sql id="Base_Column_List" &
id, tname, tpwd
&select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.String" &
&include refid="Base_Column_List" /&
where id = #{id,jdbcType=VARCHAR}
&delete id="deleteByPrimaryKey" parameterType="java.lang.String" &
delete from tadd
where id = #{id,jdbcType=VARCHAR}
&insert id="insert" parameterType="com.bky.model.Add" &
insert into tadd (id, tname, tpwd
values (#{id,jdbcType=VARCHAR}, #{tname,jdbcType=VARCHAR}, #{tpwd,jdbcType=VARCHAR}
&insert id="insertSelective" parameterType="com.bky.model.Add" &
insert into tadd
&trim prefix="(" suffix=")" suffixOverrides="," &
&if test="id != null" &
&if test="tname != null" &
&if test="tpwd != null" &
&trim prefix="values (" suffix=")" suffixOverrides="," &
&if test="id != null" &
#{id,jdbcType=VARCHAR},
&if test="tname != null" &
#{tname,jdbcType=VARCHAR},
&if test="tpwd != null" &
#{tpwd,jdbcType=VARCHAR},
&update id="updateByPrimaryKeySelective" parameterType="com.bky.model.Add" &
update tadd
&if test="tname != null" &
tname = #{tname,jdbcType=VARCHAR},
&if test="tpwd != null" &
tpwd = #{tpwd,jdbcType=VARCHAR},
where id = #{id,jdbcType=VARCHAR}
&update id="updateByPrimaryKey" parameterType="com.bky.model.Add" &
update tadd
set tname = #{tname,jdbcType=VARCHAR},
tpwd = #{tpwd,jdbcType=VARCHAR}
where id = #{id,jdbcType=VARCHAR}
&select id="getAll" resultMap="BaseResultMap"&
SELECT * FROM tadd
BaseService.java
package com.bky.
import java.util.L
import com.bky.model.A
public interface BaseService {
String addInfo(Add addInfo);
List&Add& getAll();
String delete(String id);
Add findById(String id);
String update(Add addInfo);
BaseServiceImpl.java
package com.bky.service.
import java.util.L
import java.util.UUID;
import org.springframework.beans.factory.annotation.A
import org.springframework.stereotype.S
import com.bky.dao.AddM
import com.bky.model.A
import com.bky.service.BaseS
@Service("baseService")
public class BaseServiceImpl implements BaseService {
private AddMapper addM
public AddMapper getAddMapper() {
return addM
@Autowired
public void setAddMapper(AddMapper addMapper) {
this.addMapper = addM
public String addInfo(Add addInfo) {
if (addMapper.insertSelective(addInfo) == 1) {
return "添加成功";
return "添加失败";
public List&Add& getAll() {
return addMapper.getAll();
public String delete(String id) {
if (addMapper.deleteByPrimaryKey(id) == 1) {
return "删除成功";
return "删除失败";
public Add findById(String id) {
return addMapper.selectByPrimaryKey(id);
public String update(Add addInfo) {
if (addMapper.updateByPrimaryKeySelective(addInfo) == 1) {
return "更新成功";
return "更新失败";
BaseController.java
package com.bky.
import java.util.L
import java.util.UUID;
import javax.servlet.http.HttpServletR
import org.springframework.beans.factory.annotation.A
import org.springframework.stereotype.C
import org.springframework.web.bind.annotation.RequestM
import com.bky.model.A
import com.bky.service.BaseS
@Controller
public class BaseController {
private BaseService baseS
public BaseService getBaseService() {
return baseS
@Autowired
public void setBaseService(BaseService baseService) {
this.baseService = baseS
@SuppressWarnings("finally")
@RequestMapping("addInfo")
public String add(Add add,HttpServletRequest request){
add.setId(UUID.randomUUID().toString());
System.out.println(add.getId() + ":::::" + add.getTname() + ":::::" + add.getTpwd());
String str = baseService.addInfo(add);
System.out.println(str);
request.setAttribute("InfoMessage", str);
} catch (Exception e) {
e.printStackTrace();
request.setAttribute("InfoMessage", "添加信息失败！具体异常信息：" + e.getMessage());
} finally {
return "result";
@RequestMapping("getAll")
public String getAddInfoAll(HttpServletRequest request){
List&Add& list = baseService.getAll();
System.out.println(list);
request.setAttribute("addLists", list);
return "listAll";
} catch (Exception e) {
e.printStackTrace();
request.setAttribute("InfoMessage", "信息载入失败！具体异常信息：" + e.getMessage());
return "result";
@SuppressWarnings("finally")
@RequestMapping("del")
public String del(String tid,HttpServletRequest request){
String str = baseService.delete(tid);
request.setAttribute("InfoMessage", str);
} catch (Exception e) {
e.printStackTrace();
request.setAttribute("InfoMessage", "删除信息失败！具体异常信息：" + e.getMessage());
} finally {
return "result";
@RequestMapping("modify")
public String modify(String tid,HttpServletRequest request){
Add add = baseService.findById(tid);
request.setAttribute("add", add);
return "modify";
} catch (Exception e) {
e.printStackTrace();
request.setAttribute("InfoMessage", "信息载入失败！具体异常信息：" + e.getMessage());
return "result";
@SuppressWarnings("finally")
@RequestMapping("update")
public String update(Add add,HttpServletRequest request){
String str = baseService.update(add);
request.setAttribute("InfoMessage", str);
} catch (Exception e) {
e.printStackTrace();
request.setAttribute("InfoMessage", "更新信息失败！具体异常信息：" + e.getMessage());
} finally {
return "result";
config.properties
#hibernate.dialect=com.bky.util.Oracle10gDialect
#driverClassName=oracle.jdbc.driver.OracleDriver
#validationQuery=SELECT 1 FROM DUAL
#jdbc_url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=Baikeyang)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))
#jdbc_username=sshe
#jdbc_password=1234
#hibernate.dialect=org.hibernate.dialect.Oracle9Dialect
#driverClassName=oracle.jdbc.driver.OracleDriver
#validationQuery=SELECT 1 FROM DUAL
#jdbc_url=jdbc:oracle:thin:@127.0.0.1:1521:orcl
#jdbc_username=sshe
#jdbc_password=1234
#hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
#driverClassName=com.mysql.jdbc.Driver
validationQuery=SELECT 1
jdbc_url=jdbc:mysql://localhost:3306/bkytest?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull
jdbc_username=root
jdbc_password=root
#hibernate.dialect=org.hibernate.dialect.SQLServer2008Dialect
#driverClassName=net.sourceforge.jtds.jdbc.Driver
#validationQuery=SELECT 1
#jdbc_url=jdbc:jtds:sqlserver://127.0.0.1:1433/dbName
#jdbc_username=sa
#jdbc_password=123456
#jndiName=java:comp/env/BenDiShuJuYuan
#hibernate.hbm2ddl.auto=update
#hibernate.show_sql=true
#hibernate.format_sql=true
#hibernate.use_sql_comments=true
#sessionInfoName=sessionInfo
#uploadPath=/ssheUploadFile
spring-mvc.xml
&?xml version="1.0" encoding="UTF-8"?&
&beans xmlns="http://www.springframework.org/schema/beans" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p" xmlns:context="http://www.springframework.org/schema/context" xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.0.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd"&
&!-- 自动扫描controller包下的所有类，使其认为spring mvc的控制器 --&
&context:component-scan base-package="com.bky.controller" /&
&!-- 对模型视图名称的解析，即在模型视图名称添加前后缀 --&
&bean class="org.springframework.web.servlet.view.InternalResourceViewResolver" p:prefix="/" p:suffix=".jsp" /&
spring-mybatis.xml
&?xml version="1.0" encoding="UTF-8"?&
&beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:aop="http://www.springframework.org/schema/aop" xsi:schemaLocation="
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
&!-- 配置数据源 --&
&bean name="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close"&
&property name="url" value="${jdbc_url}" /&
&property name="username" value="${jdbc_username}" /&
&property name="password" value="${jdbc_password}" /&
&!-- 初始化连接大小 --&
&property name="initialSize" value="0" /&
&!-- 连接池最大使用连接数量 --&
&property name="maxActive" value="20" /&
&!-- 连接池最大空闲 --&
&property name="maxIdle" value="20" /&
&!-- 连接池最小空闲 --&
&property name="minIdle" value="0" /&
&!-- 获取连接最大等待时间 --&
&property name="maxWait" value="60000" /&
&!-- &property name="poolPreparedStatements" value="true" /& &property name="maxPoolPreparedStatementPerConnectionSize" value="33" /& --&
&property name="validationQuery" value="${validationQuery}" /&
&property name="testOnBorrow" value="false" /&
&property name="testOnReturn" value="false" /&
&property name="testWhileIdle" value="true" /&
&!-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 --&
&property name="timeBetweenEvictionRunsMillis" value="60000" /&
&!-- 配置一个连接在池中最小生存的时间，单位是毫秒 --&
&property name="minEvictableIdleTimeMillis" value="" /&
&!-- 打开removeAbandoned功能 --&
&property name="removeAbandoned" value="true" /&
&!-- 1800秒，也就是30分钟 --&
&property name="removeAbandonedTimeout" value="1800" /&
&!-- 关闭abanded连接时输出错误日志 --&
&property name="logAbandoned" value="true" /&
&!-- 监控数据库 --&
&!-- &property name="filters" value="stat" /& --&
&property name="filters" value="mergeStat" /&
&!-- myBatis文件 --&
&bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"&
&property name="dataSource" ref="dataSource" /&
&!-- 自动扫描entity目录, 省掉Configuration.xml里的手工配置 --&
&property name="mapperLocations" value="classpath:com/bky/mapping/*.xml" /&
&bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"&
&property name="basePackage" value="com.bky.dao" /&
&property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" /&
&!-- 配置事务管理器 --&
&bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"&
&property name="dataSource" ref="dataSource" /&
&!-- 注解方式配置事物 --&
&!-- &tx:annotation-driven transaction-manager="transactionManager" /& --&
&!-- 拦截器方式配置事物 --&
&tx:advice id="transactionAdvice" transaction-manager="transactionManager"&
&tx:attributes&
&tx:method name="add*" propagation="REQUIRED" /&
&tx:method name="append*" propagation="REQUIRED" /&
&tx:method name="insert*" propagation="REQUIRED" /&
&tx:method name="save*" propagation="REQUIRED" /&
&tx:method name="update*" propagation="REQUIRED" /&
&tx:method name="modify*" propagation="REQUIRED" /&
&tx:method name="edit*" propagation="REQUIRED" /&
&tx:method name="delete*" propagation="REQUIRED" /&
&tx:method name="remove*" propagation="REQUIRED" /&
&tx:method name="repair" propagation="REQUIRED" /&
&tx:method name="delAndRepair" propagation="REQUIRED" /&
&tx:method name="get*" propagation="SUPPORTS" /&
&tx:method name="find*" propagation="SUPPORTS" /&
&tx:method name="load*" propagation="SUPPORTS" /&
&tx:method name="search*" propagation="SUPPORTS" /&
&tx:method name="datagrid*" propagation="SUPPORTS" /&
&tx:method name="*" propagation="SUPPORTS" /&
&/tx:attributes&
&/tx:advice&
&aop:config&
&aop:pointcut id="transactionPointcut" expression="execution(* com.bky.service..*Impl.*(..))" /&
&aop:advisor pointcut-ref="transactionPointcut" advice-ref="transactionAdvice" /&
&/aop:config&
&!-- 配置druid监控spring jdbc --&
&bean id="druid-stat-interceptor" class="com.alibaba.druid.support.spring.stat.DruidStatInterceptor"&
&bean id="druid-stat-pointcut" class="org.springframework.aop.support.JdkRegexpMethodPointcut" scope="prototype"&
&property name="patterns"&
&value&com.bky.service.*&/value&
&/property&
&aop:config&
&aop:advisor advice-ref="druid-stat-interceptor" pointcut-ref="druid-stat-pointcut" /&
&/aop:config&
spring.xml
&?xml version="1.0" encoding="UTF-8"?&
&beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context" xsi:schemaLocation="
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.0.xsd
&!-- 引入属性文件 --&
&context:property-placeholder location="classpath:config.properties" /&
&!-- 自动扫描(自动注入) --&
&context:component-scan base-package="com.bky.service..*" /&
&?xml version="1.0" encoding="UTF-8"?&
&web-app version="3.0"
xmlns="/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="/xml/ns/javaee
/xml/ns/javaee/web-app_3_0.xsd"&
&display-name&&/display-name&
&context-param&
&param-name&contextConfigLocation&/param-name&
&param-value&classpath:spring.classpath:spring-mybatis.xml&/param-value&
&/context-param&
&description&字符集过滤器&/description&
&filter-name&encodingFilter&/filter-name&
&filter-class&org.springframework.web.filter.CharacterEncodingFilter&/filter-class&
&init-param&
&description&字符集编码&/description&
&param-name&encoding&/param-name&
&param-value&UTF-8&/param-value&
&/init-param&
&filter-mapping&
&filter-name&encodingFilter&/filter-name&
&url-pattern&/*&/url-pattern&
&/filter-mapping&
&listener&
&description&spring监听器&/description&
&listener-class&org.springframework.web.context.ContextLoaderListener&/listener-class&
&/listener&
&listener&
&listener-class&org.springframework.web.util.IntrospectorCleanupListener&/listener-class&
&/listener&
&description&spring mvc servlet&/description&
&servlet-name&springMvc&/servlet-name&
&servlet-class&org.springframework.web.servlet.DispatcherServlet&/servlet-class&
&init-param&
&description&spring mvc 配置文件&/description&
&param-name&contextConfigLocation&/param-name&
&param-value&classpath:spring-mvc.xml&/param-value&
&/init-param&
&load-on-startup&1&/load-on-startup&
&/servlet&
&servlet-mapping&
&servlet-name&springMvc&/servlet-name&
&url-pattern&*.do&/url-pattern&
&/servlet-mapping&
&session-config&
&session-timeout&15&/session-timeout&
&/session-config&
&welcome-file-list&
&welcome-file&index.jsp&/welcome-file&
&/welcome-file-list&
&/web-app&
&%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%&
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
&!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"&
&base href="&%=basePath%&"&
&title&My JSP 'index.jsp' starting page&/title&
&meta http-equiv="pragma" content="no-cache"&
&meta http-equiv="cache-control" content="no-cache"&
&meta http-equiv="expires" content="0"&
&meta http-equiv="keywords" content="keyword1,keyword2,keyword3"&
&meta http-equiv="description" content="This is my page"&
&link rel="stylesheet" type="text/css" href="styles.css"&
&a href="add.jsp"&新增数据&/a&
&a href="getAll.do"&查看全部数据&/a&
&%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%&
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
&!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"&
&base href="&%=basePath%&"&
&title&添加数据&/title&
&meta http-equiv="pragma" content="no-cache"&
&meta http-equiv="cache-control" content="no-cache"&
&meta http-equiv="expires" content="0"&
&meta http-equiv="keywords" content="keyword1,keyword2,keyword3"&
&meta http-equiv="description" content="This is my page"&
&link rel="stylesheet" type="text/css" href="styles.css"&
&form action="&%=request.getContextPath() %&/addInfo.do" method="post"&
用户名：&input type="text" name="tname"&
密码：&input type="password" name="tpwd"&
&input type="submit" value="提交数据"&
&listall.jsp
&%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%&
&%@taglib prefix="c" uri="/jsp/jstl/core" %&
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
&!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"&
&base href="&%=basePath%&"&
&title&所有数据&/title&
&meta http-equiv="pragma" content="no-cache"&
&meta http-equiv="cache-control" content="no-cache"&
&meta http-equiv="expires" content="0"&
&meta http-equiv="keywords" content="keyword1,keyword2,keyword3"&
&meta http-equiv="description" content="This is my page"&
&link rel="stylesheet" type="text/css" href="styles.css"&
所有结果&br/&
&table border="1"&
&td&编号&/td&
&td&用户名&/td&
&td&密码&/td&
&td&操作&/td&
&c:forEach var="list"
items="${addLists}"&
&td&${list.id}&/td&
&td&${list.tname}&/td&
&td&${list.tpwd}&/td&
&td&&a href="modify.do?tid=${list.id}"&更新&/a&&&&&&a href="del.do?tid=${list.id}"&删除&/a&&/td&
&/c:forEach&
阅读(...) 评论()

我要回帖

更多关于 springmvcmybatis项目 的文章

 

随机推荐