亚洲免费在线-亚洲免费在线播放-亚洲免费在线观看-亚洲免费在线观看视频-亚洲免费在线看-亚洲免费在线视频

Ibatis 整合spring + Struts2 加入OSCACHE

系統 1700 0
說明:
?? 使用? spring2.5 +ibatis2.3.4+oscache2.4+struts2+oracle



Ibatis 整合spring + Struts2 加入OSCACHE

建表
    
create table STUDENT
(
  SID   NUMBER(8) primary key not null,
  SNAME VARCHAR2(20) not null,
  MAJOR VARCHAR2(100),
  BIRTH DATE,
  SCORE NUMBER(6,2)
)

-- Create sequence 
create sequence STUDENT_SEQ
minvalue 1
maxvalue 999999999999999999999999999
start with 21
increment by 1
cache 20;

  


applicationContext.xml
    
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
	xmlns="http://www.springframework.org/schema/beans"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:aop="http://www.springframework.org/schema/aop"
	xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="http://www.springframework.org/schema/beans
	http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
	http://www.springframework.org/schema/context
	http://www.springframework.org/schema/context/spring-context-2.5.xsd
	http://www.springframework.org/schema/aop
	http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
	http://www.springframework.org/schema/tx
	http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">


<!-- 采用c3p0數據源 這個是在企業中用的比較多的一個數據源 -->
<!-- destroy-method="close"的作用是當數據庫連接不使用的時候,就把該連接重新放到數據池中,方便下次使用調用 -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
   <property name="driverClass" value="oracle.jdbc.driver.OracleDriver"/>
   <property name="jdbcUrl" value="jdbc:oracle:thin:@127.0.0.1:1521:orcl"/>
   <property name="user" value="luob"/>
   <property name="password" value="luob"/>
   <!-- 連接池中的最大連接數 -->
   <property name="maxPoolSize" value="150"/>
   
   <!-- 連接池中的最小連接數 -->
   <property name="minPoolSize" value="1"></property>
   
   <!-- 初始化連接池中的 連接數,取值 在  minPoolSize 和 maxPoolSize 之間,default:3-->
   <property name="initialPoolSize" value="3"/>
   
   <!-- 最大空閑時間,60s內該連接沒有被使用則被丟棄,若為0 永不丟棄.default:0 -->
   <property name="maxIdleTime" value="60"/>
   
   <!-- 當連接數不夠時,每次同時創建多少個連接 -->
   <property name="acquireIncrement" value="1"/>
   
   <!-- 每60s檢查連接池中的所有空間連接,如果沒有被使用,就被放棄, default:0 -->
   <property name="idleConnectionTestPeriod" value="60"/>
</bean>


<!-- 從c3p0數據源中抽取出JDBC的代理對象-->
<bean id="nativeJdbcExtractor" class="org.springframework.jdbc.support.nativejdbc.C3P0NativeJdbcExtractor"  lazy-init="true" /> 

<!--9i: org.springframework.jdbc.support.lob.OracleLobHandler  -->
<!--10g以后:org.springframework.jdbc.support.lob.DefaultLobHandler(mysql,DB2等都可以用這個)  -->
<bean id="lobHandler" class="org.springframework.jdbc.support.lob.OracleLobHandler" lazy-init="true">
  <!-- 9i: 指定操作lob類型數據的jdbc代理對象 如果上面的 lobHandler 換了下面的就不需要了 -->
  <property name="nativeJdbcExtractor">
   	<ref local="nativeJdbcExtractor" />
  </property>
</bean>

<!--==================================================== -->
<!-- ////讓spring來管理batis 的SqlMapClient對象          //////////-->
<!--==================================================== -->

<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
       <property name="dataSource" ref="dataSource"/>
       <property name="lobHandler" ref="lobHandler"/>
       <property name="configLocation"><value>classpath:SqlMapConfig.xml</value></property>
</bean>


<!--=============================== -->
<!-- ////    batis事務代理配置      /////////-->
<!--=============================== -->


<!-- 使用jdbc 來管理事務 -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    <property name="dataSource" ref="dataSource"/>
</bean>

<!--   定義DAO bean的事務代理-->    
<bean id="templatesDAO"    
    class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean ">    
    <!--   為事務代理bean注入事務管理器-->    
    <property name="transactionManager">    
        <ref bean="transactionManager" />    
    </property>    
  
    <!--   設置事務屬性-->    
    <property name="transactionAttributes">    
        <props>    
            <!--   所有以add開頭的方法,采用required的事務策略,并且只讀-->    
            <prop key="add*">PROPAGATION_REQUIRED</prop>    
            <!--   所有以mod開頭的方法,采用required的事務策略,并且只讀-->    
            <prop key="mod*">PROPAGATION_REQUIRED</prop>    
            <!--   所有以del開頭的方法,采用required的事務策略,并且只讀-->    
            <prop key="del*">PROPAGATION_REQUIRED</prop>    
            <!--   其他方法,采用required的事務策略 -->    
            <prop key="*">readOnly</prop>    
        </props>    
    </property>   
  
    <!--   為事務代理bean設置目標bean -->    
    <property name="target">    
        <!--   采用嵌套bean配置目標bean-->    
        <bean class="test.dao.impl.TaoTemplatesDAOImpl">    
            <property name="sessionFactory">    
                <ref local="sessionFactory" />    
            </property>    
        </bean>    
    </property>    
</bean>   


<!-- =============================== -->
<!--  /////////    dao 的配置              /////-->
<!-- =============================== -->
<bean id="studentDAO" class="com.ibatis.student.IStudentDAOImpl">
	<property name="sqlMapClient" ref="sqlMapClient"/>
</bean>

<!-- =============================== -->
<!--  /////   Serivce 的配置                /////-->
<!-- =============================== -->
<bean id="studentService" class="com.ibatis.student.IStudentServiceImpl">
	<property name="studentDAO" ref="studentDAO"/>
</bean>

</beans>

  


SqlMapConfig.xml
    
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMapConfig      
    PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"      
    "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">

<sqlMapConfig>
  
 <!-- 使用spring之后,數據源的配置移植到了spring上,所以IBATIS本身的配置可以取消 -->
	
 <!-- 對 ibatis 的設置  --> 
 <settings maxRequests="256" maxSessions="64" maxTransactions="16"  
        enhancementEnabled="true" lazyLoadingEnabled="true" useStatementNamespaces="false" />

  <!-- List the SQL Map XML files. They can be loaded from the 
       classpath, as they are here (com.domain.data...) -->
       
  <sqlMap resource="com/ibatis/student/Student.xml"/>
  <!-- List more here...
  <sqlMap resource="com/mydomain/data/Order.xml"/>
  <sqlMap resource="com/mydomain/data/Documents.xml"/>
  -->
</sqlMapConfig>

  

Student.xml
    
<?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="studentSqlMap">
    <!-- 別名  就像java中 import packageName -->
    <typeAlias alias="Student" type="com.ibatis.student.Student"/>
     
    <!-- 使用 OSCACHE 緩存機制 -->
    <cacheModel id="student-cache" type="OSCACHE">  
        <flushInterval hours="24" />  
        <flushOnExecute statement="queryAllStudent" />  
        <property name="size" value="1000" />  
    </cacheModel> 
    
    <select id="queryAllStudent" resultClass="Student">
    	select * from student
    </select>
    
    <select id="queryStudentById" parameterClass="int" resultClass="Student">
		select * from student where sid=#sid#    
    </select>
    
    <!-- 這個里面的 占位符 就不能亂寫了 因為會調用 Student 的 getSid ...getSname() ..  -->
    <insert id="addStudent" parameterClass="Student">
    	insert into student(sid,sname,major,birth,score) 
    	values    (#sid#,#sname#,#major#,#birth#,#score#)
    </insert>
      
    <!-- #sid# 這個 只是一個占位符 可以更改的 -->
    <delete id="deleteStudentById" parameterClass="int">
    	delete from student where sid=#sid#
    </delete>
    
    
    <update id="updateStudent" parameterClass="Student">
    	update student
    	set 
    		sname=#sname#,
    		major=#major#,
    	    birth=#birth#,
    	    score=#score#
    	 where sid=#sid#
    </update>
    
    <!-- 如果參數  要拼接成一個表達式 就要將#  換成  $ -->
    <select id="queryStudentByName" parameterClass="String" resultClass="Student">
    	select sid,sname,major,birth,score from student where sname like '$sname$'	
    </select>  
    
    <!-- Student  不區分大小寫的   -->
    <insert id="insertStudentBySequence" parameterClass="Student">
    	<selectKey resultClass="int" keyProperty="sid">
    		select STUDENT_SEQ.nextVal from dual
    	</selectKey>
    	insert into student(sid,sname,major,birth,score)
    	values (#sid#,#sname#,#major#,#birth#,#score#)
    </insert>
    	
</sqlMap>



  


Student.java
    
package com.ibatis.student;

import java.util.Date;

public class Student {
	private int sid;
	private String sname;
	private String major;
	private Date birth;
	private float score;

	public int getSid() {
		return sid;
	}

	public void setSid(int sid) {
		this.sid = sid;
	}

	public String getSname() {
		return sname;
	}

	public void setSname(String sname) {
		this.sname = sname;
	}

	public String getMajor() {
		return major;
	}

	public void setMajor(String major) {
		this.major = major;
	}

	public Date getBirth() {
		return birth;
	}

	public void setBirth(Date birth) {
		this.birth = birth;
	}

	public float getScore() {
		return score;
	}

	public void setScore(float score) {
		this.score = score;
	}

	@Override
	public String toString() {
		// TODO Auto-generated method stub
		String content = "sid:" + sid + "\tsname:" + sname + "\tmajor:" + major
				+ "\tbirth:" + birth + "\tscore=" + score;
		return content;
	}

}


  



IStudentDAO.java
    

package com.ibatis.student;

import java.util.List;


public interface IStudentDAO {
	public void addStudent(Student student);

	//使用自動增長 主鍵 
	public void addStudentBySequence(Student student);

	public void delStudentById(int id);

	public void updStudentById(Student student);

	
	public List<Student> queryAllStudent();

	//使用模糊查詢
	public List<Student> queryStudentByName(String name);

	public Student queryStudentById(int id);
}


  


IStudentDAOImpl.java
    
package com.ibatis.student;


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

import org.springframework.dao.DataAccessException;
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;

import com.ibatis.sqlmap.client.SqlMapClient;

public class IStudentDAOImpl extends SqlMapClientDaoSupport implements IStudentDAO {

	//private static SqlMapClient sqlMapClient=null;
	
	/*static{
		try {
			Reader 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 block
			e.printStackTrace();
		}
	}*/
	public void addStudent(Student student) {
		// TODO Auto-generated method stub
		student=(Student)getSqlMapClientTemplate().insert("addStudent", student);
		System.out.println(student.getSid());
	}

	public void addStudentBySequence(Student student) {
		// TODO Auto-generated method stub 
		getSqlMapClientTemplate().insert("insertStudentBySequence", student); 
	}

	public void delStudentById(int id) {
		// TODO Auto-generated method stub
		try {
			int rows=getSqlMapClientTemplate().delete("deleteStudentById", id);
			System.out.println(rows);
		} catch (DataAccessException e) {
			e.printStackTrace();
		}
	}

	public List<Student> queryAllStudent() {
		// TODO Auto-generated method stub
		List<Student>  studentList=null;
		try {
			studentList=getSqlMapClientTemplate().queryForList("queryAllStudent");
		} catch (DataAccessException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return studentList;
	}

	public Student queryStudentById(int id) {
		Student student=null;  
		try {
			student=(Student)getSqlMapClientTemplate().queryForObject("queryStudentById",id);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return student;
	}

	public List<Student> queryStudentByName(String name) {
		// TODO Auto-generated method stub
		List<Student> studentList=null;  
		try {
			studentList=getSqlMapClientTemplate().queryForList("queryStudentByName", name);
		} catch (DataAccessException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		return studentList;
	}

	public void updStudentById(Student student) {
		// TODO Auto-generated method stub
		try {
			int rows=getSqlMapClientTemplate().update("updateStudent", student);
		} catch (DataAccessException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	


}


  

IStudentServiceImpl.java
    
package com.ibatis.student;

import java.util.List;

public class IStudentServiceImpl implements IStudentService {

	private IStudentDAO  studentDAO;
	
	public void setStudentDAO(IStudentDAO studentDAO) {
		this.studentDAO = studentDAO;
	}

	
	public void addStudent(Student student) {
		// TODO Auto-generated method stub
		studentDAO.addStudent(student);
	}

	public void addStudentBySequence(Student student) {
		// TODO Auto-generated method stub
		studentDAO.addStudentBySequence(student);
	}

	public void delStudentById(int id) {
		// TODO Auto-generated method stub
		studentDAO.delStudentById(id);
	}

	public List<Student> queryAllStudent() {
		// TODO Auto-generated method stub
		return studentDAO.queryAllStudent();
	}

	public Student queryStudentById(int id) {
		// TODO Auto-generated method stub
		return studentDAO.queryStudentById(id);
	}

	public List<Student> queryStudentByName(String name) {
		// TODO Auto-generated method stub
		return studentDAO.queryStudentByName(name);
	}

	public void updStudentById(Student student) {
		// TODO Auto-generated method stub
		studentDAO.updStudentById(student);
	}

}


  

Test.java
    
package com.ibatis.student;

import java.sql.Date;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

public class Test {

	public  static void main(String [] args){
		ApplicationContext context=new ClassPathXmlApplicationContext("classpath:applicationContext.xml");
		
		IStudentService studentService=(IStudentService)context.getBean("studentService");
		
		//1.
		for (Student student : studentService.queryAllStudent()) {
			System.out.println(student);
		}
		
		//2.
//		System.out.println(dao.queryStudentById(1));
		
		//3.
//		Student student=new Student();
//		student.setSid(5);
//		student.setSname("admin");
//		student.setScore(100);
//		student.setMajor("Games");
//		student.setBirth(Date.valueOf("2008-08-08"));
//		
//		dao.addStudent(student);
		
		//4.
//		dao.delStudentById(1);
		
		//5.
//		Student student=new Student();
//		student.setSid(2);
//		student.setSname("luob");
//		student.setScore(50);
//		student.setMajor("Games");
//		student.setBirth(Date.valueOf("2008-08-08"));
//		dao.updStudentById(student);
		
		//6.
//		for (Student student : dao.queryStudentByName("l%")) {
//			System.out.println(student);
//		}
		
		//7.
		/*Student student=new Student();
		student.setSid(2);
		student.setSname("SCOTT");
		student.setScore(50);
		student.setMajor("paly Games");
		student.setBirth(Date.valueOf("2008-08-08"));
		
		studentService.addStudentBySequence(student);
		System.out.println("success");*/
		
	}
}

  

struts.xml
    
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC
	"-//Apache Software Foundation//DTD Struts Configuration 2.3//EN"
	"http://struts.apache.org/dtds/struts-2.3.dtd">

<struts>
	<package name="student" namespace="/student" extends="struts-default">
		<action name="userLogin" class="com.ibatis.student.action.StudentAction" method="login">
			<result name="success">/index.jsp</result>
		</action>
	</package>
</struts>

  


BaseAction.java
    
package com.ibatis.student.common;

import java.util.Map;

import javax.servlet.ServletContext;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts2.ServletActionContext;
import org.apache.struts2.interceptor.SessionAware;
import org.springframework.web.context.WebApplicationContext;
import org.springframework.web.context.support.WebApplicationContextUtils;

import com.opensymphony.xwork2.ActionContext;
import com.opensymphony.xwork2.ActionSupport;

public class BaseAction extends ActionSupport{

	public Object getServiceBean(String beanId){
		ServletContext sc=ServletActionContext.getServletContext();
		WebApplicationContext ctx=WebApplicationContextUtils.getWebApplicationContext(sc);
		return ctx.getBean(beanId);
	}
	
	public HttpServletRequest getRequest(){
		return ServletActionContext.getRequest();
	}
	
	public HttpServletResponse getResponse(){
		return ServletActionContext.getResponse();
	}
	
	public Map<String, Object> getSession() {
		ActionContext act=ActionContext.getContext();
		return act.getSession();
	}
}


  


StudentAction.java
    
package com.ibatis.student.common;

import java.util.Map;

import javax.servlet.ServletContext;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts2.ServletActionContext;
import org.apache.struts2.interceptor.SessionAware;
import org.springframework.web.context.WebApplicationContext;
import org.springframework.web.context.support.WebApplicationContextUtils;

import com.opensymphony.xwork2.ActionContext;
import com.opensymphony.xwork2.ActionSupport;

public class BaseAction extends ActionSupport{

	public Object getServiceBean(String beanId){
		ServletContext sc=ServletActionContext.getServletContext();
		WebApplicationContext ctx=WebApplicationContextUtils.getWebApplicationContext(sc);
		return ctx.getBean(beanId);
	}
	
	public HttpServletRequest getRequest(){
		return ServletActionContext.getRequest();
	}
	
	public HttpServletResponse getResponse(){
		return ServletActionContext.getResponse();
	}
	
	public Map<String, Object> getSession() {
		ActionContext act=ActionContext.getContext();
		return act.getSession();
	}
}


  


index.jsp
    
<%@ 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">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>Ibatis + Spring + Struts2 </title>
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->
  </head>
  
  <body>
    <form action="${pageContext.request.contextPath}/student/userLogin.action" method="post">
    	用戶名:<input type="text" name="userName"/>
    	密碼:<input type="password" name="password"/>
    	<input type="submit" value="提交"/> 
    </form>
    ${sesssion_msg}
    ${request_msg}
  </body>
</html>


  

Ibatis 整合spring + Struts2 加入OSCACHE


更多文章、技術交流、商務合作、聯系博主

微信掃碼或搜索:z360901061

微信掃一掃加我為好友

QQ號聯系: 360901061

您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧,狠狠點擊下面給點支持吧,站長非常感激您!手機微信長按不能支付解決辦法:請將微信支付二維碼保存到相冊,切換到微信,然后點擊微信右上角掃一掃功能,選擇支付二維碼完成支付。

【本文對您有幫助就好】

您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描上面二維碼支持博主2元、5元、10元、自定義金額等您想捐的金額吧,站長會非常 感謝您的哦!!!

發表我的評論
最新評論 總共0條評論
主站蜘蛛池模板: 欧美大陆日韩一区二区三区 | 国产乱人伦偷精品视频不卡 | 一级毛片一级毛片一级毛片 | 日本成人不卡 | 又黑又粗又硬欧美视频在线观看 | 国产欧美日韩精品一区二区三区 | 九九精品免视频国产成人 | 亚洲欧洲日韩国产aa色大片 | 偷偷鲁影院手机在线观看 | 一级大黄视频 | 日本久久高清视频 | 99re66热这里只有精品首页 | 国产成人一区二区在线不卡 | 奇米在线| 永久免费观看黄网站 | 久久97精品久久久久久清纯 | 欧美成人性生活视频 | 最新永久地址 | 特级一级黄色片 | 日韩在线播放中文字幕 | 最新中文字幕一区 | 成人永久福利在线观看不卡 | 亚洲男人的天堂在线视频 | 97在线免费观看 | 久热最新 | 福利毛片 | 中文字幕 亚洲精品 | 午夜久久久久久网站 | 91视频a | 日日摸日日碰夜夜97 | 日韩欧美在线视频 | 亚洲黄色在线视频 | 久久的爱久久的你 | 国产成人国产在线观看入口 | 99热久久这里只有精品6 | 热re99久久精品国产99热 | 亚洲日韩欧美综合 | 天天干天天操天天舔 | 天天玩天天操 | 牛牛本精品99久久精品 | 成年女人a毛片免费视频 |