使用 Commons-attributes-compiler一定要注意其中 在Meta-Info中的數據，因此，要注意他的版本

文章: 49 積分: 89 來自: 浙江杭州

?????? 時間: 2007-02-09 14:38 ?? 關鍵字: ? Spring?spring 引用?推薦?收藏? ??? 1、使用JdbcTemplate的execute()方法執行SQL語句 代碼 jdbcTemplate.execute( "CREATE?TABLE?USER?(user_id?integer,?name?varchar(100))" );?? 2、如果是UPDATE或INSERT,可以用update()方法。 代碼 jdbcTemplate.update("INSERT?INTO?USER?VALUES('"?? ???????????+?user.getId()?+?"',?'"?? ???????????+?user.getName()?+?"',?'"?? ???????????+?user.getSex()?+?"',?'"?? ???????????+?user.getAge()?+?"')"); ?? 3、帶參數的更新 代碼 jdbcTemplate.update("UPDATE?USER?SET?name?=???WHERE?user_id?=??",?new?Object[]?{name,?id});?? 代碼 jdbcTemplate.update("INSERT?INTO?USER?VALUES(?,??,??,??)",?new?Object[]?{user.getId(),?user.getName(),?user.getSex(),?user.getAge()}); ?? 4、使用JdbcTemplate進行查詢時，使用queryForXXX()等方法 代碼 int?count?=?jdbcTemplate.queryForInt("SELECT?COUNT(*)?FROM?USER");?? 代碼 String?name?=?(String)?jdbcTemplate.queryForObject("SELECT?name?FROM?USER?WHERE?user_id?=??",?new?Object[]?{id},?java.lang.String.class);?? 代碼 List?rows?=?jdbcTemplate.queryForList("SELECT?*?FROM?USER");?? 代碼 List?rows?=?jdbcTemplate.queryForList("SELECT?*?FROM?USER"); ?? Iterator?it?=?rows.iterator(); ?? while(it.hasNext())?{ ?? ????Map?userMap?=?(Map)?it.next(); ?? ????System.out.print(userMap.get("user_id")?+?"\t"); ?? ????System.out.print(userMap.get("name")?+?"\t"); ?? ????System.out.print(userMap.get("sex")?+?"\t"); ?? ????System.out.println(userMap.get("age")?+?"\t"); ?? } ?? JdbcTemplate將我們使用的JDBC的流程封裝起來，包括了異常的捕捉、SQL的執行、查詢結果的轉換等等。spring大量使用Template Method模式來封裝固定流程的動作，XXXTemplate等類別都是基于這種方式的實現。 除了大量使用Template Method來封裝一些底層的操作細節，spring也大量使用callback方式類回調相關類別的方法以提供JDBC相關類別的功能，使傳統的JDBC的使用者也能清楚了解spring所提供的相關封裝類別方法的使用。 JDBC的PreparedStatement 代碼 final?String?id?=?user.getId(); ?? final?String?name?=?user.getName(); ?? final?String?sex?=?user.getSex()?+?""; ?? final?int?age?=?user.getAge(); ?? ?? jdbcTemplate.update("INSERT?INTO?USER?VALUES(?,??,??,??)", ?? ?????????????????????new?PreparedStatementSetter()?{ ?? ?????????????????????????public?void?setValues(PreparedStatement?ps)?throws?SQLException?{ ?? ?????????????????????????????ps.setString(1,?id); ?? ?????????????????????????????ps.setString(2,?name);?????????? ?? ?????????????????????????????ps.setString(3,?sex); ?? ?????????????????????????????ps.setInt(4,?age); ?? ?????????????????????????} ?? ?????????????????????}); ?? ?? 代碼 final?User?user?=?new?User(); ?? jdbcTemplate.query("SELECT?*?FROM?USER?WHERE?user_id?=??", ?? ????????????????????new?Object[]?{id}, ?? ????????????????????new?RowCallbackHandler()?{ ?? ????????????????????????public?void?processRow(ResultSet?rs)?throws?SQLException?{ ?? ????????????????????????????user.setId(rs.getString("user_id")); ?? ????????????????????????????user.setName(rs.getString("name")); ?? ????????????????????????????user.setSex(rs.getString("sex").charAt(0)); ?? ????????????????????????????user.setAge(rs.getInt("age")); ?? ????????????????????????} ?? ????????????????????}); ?? ?? 代碼 class?UserRowMapper?implements?RowMapper?{ ?? ????public?Object?mapRow(ResultSet?rs,?int?index)?throws?SQLException?{ ?? ????????User?user?=?new?User(); ?? ?? ????????user.setId(rs.getString("user_id")); ?? ????????user.setName(rs.getString("name")); ?? ????????user.setSex(rs.getString("sex").charAt(0)); ?? ????????user.setAge(rs.getInt("age")); ?? ?? ????????return?user; ?? ????} ?? } ?? ?? public?List?findAllByRowMapperResultReader()?{ ?? ????String?sql?=?"SELECT?*?FROM?USER"; ?? ????return?jdbcTemplate.query(sql,?new?RowMapperResultReader(new?UserRowMapper())); ?? } ?? ?? 在getUser(id)里面使用UserRowMapper 代碼 public?User?getUser(final?String?id)?throws?DataAccessException?{ ?? ????String?sql?=?"SELECT?*?FROM?USER?WHERE?user_id=?"; ?? ????final?Object[]?params?=?new?Object[]?{?id?}; ?? ????List?list?=?jdbcTemplate.query(sql,?params,?new?RowMapperResultReader(new?UserRowMapper())); ?? ?? ????return?(User)?list.get(0); ?? } ?? 網上收集 org.springframework.jdbc.core.PreparedStatementCreator 返回預編譯SQL 不能于Object[]一起用 代碼 public?PreparedStatement?createPreparedStatement(Connection?con)?throws?SQLException?{ ?? ?return?con.prepareStatement(sql); ?? } ?? 1.增刪改 org.springframework.jdbc.core.JdbcTemplate 類(必須指定數據源dataSource) 代碼 template.update("insert?into?web_person?values(?,?,?)",Object[]); ?? 或 代碼 template.update("insert?into?web_person?values(?,?,?)",new?PreparedStatementSetter(){?匿名內部類?只能訪問外部最終局部變量 ?? ?? ?public?void?setValues(PreparedStatement?ps)?throws?SQLException?{ ?? ??ps.setInt(index++,3); ?? }); ?? org.springframework.jdbc.core.PreparedStatementSetter 接口 處理預編譯SQL 代碼 public?void?setValues(PreparedStatement?ps)?throws?SQLException?{ ?? ?ps.setInt(index++,3); ?? } ?? 2.查詢JdbcTemplate.query(String,[Object[]/PreparedStatementSetter],RowMapper/RowCallbackHandler) org.springframework.jdbc.core.RowMapper 記錄映射接口 處理結果集 代碼 public?Object?mapRow(ResultSet?rs,?int?arg1)?throws?SQLException?{???int表當前行數 ?? ??person.setId(rs.getInt("id")); ?? } ?? List?template.query("select?*?from?web_person?where?id=?",Object[],RowMapper); ?? org.springframework.jdbc.core.RowCallbackHandler 記錄回調管理器接口 處理結果集 代碼 template.query("select?*?from?web_person?where?id=?",Object[],new?RowCallbackHandler(){ ?? ?public?void?processRow(ResultSet?rs)?throws?SQLException?{ ?? ??person.setId(rs.getInt("id")); ?? }); ??

1. List?rows?=?jdbcTemplate.queryForList("SELECT?*?FROM?USER"); ??
2. Iterator?it?=?rows.iterator(); ??
3. while(it.hasNext())?{ ??
4. ????Map?userMap?=?(Map)?it.next(); ??
5. ????System.out.print(userMap.get("user_id")?+?"\t"); ??
6. ????System.out.print(userMap.get("name")?+?"\t"); ??
7. ????System.out.print(userMap.get("sex")?+?"\t"); ??
8. ????System.out.println(userMap.get("age")?+?"\t"); ??
9. }

昨天在論壇看到一篇討論嵌入式數據庫HSQLDB(http://www.javaeye.com/topic/79802)的帖子，想到自己曾經讀過部分它的源碼，有一種對某些技術豁然開朗的感覺。所以，也希望和朋友們一起分享，大家有什么好的感受，不如也分享一下吧。下面是我對那個帖子的冗余回復，我覺得有必要專門發一篇帖子重復一下：

說點題外話，建議大家讀讀HSQLDB的源碼，特別是jdbc driver（org/hsqldb/jdbc包）那部分，寫得清晰易懂。讀了它的部分源碼，我自認為對下面一些問題理解深入了：
1、JDBC規范和JDBC實現的關系：怎么自己去設計一個規范，一種架構？我是否自己可以為某種數據設計jdbc driver，如何設計？想想php里面各數據庫的函數庫各自為政對程序移植性的影響，就知道jdbc規范有多么重要了。

2、JDBC協議：JDBC是基于socket之上的，數據包格式（org.hsqldb.Result)（mysql數據包格式公開了）？那么JMS數據包呢？其實，這也可以延伸到分布式協議的設計原理，如RMI、SOAP。其實，這些數據包格式和JSON、YAML這些message格式沒有本質的區別，只不過應用范圍不一樣。任何分布式協議，肯定有一種message格式。

3、JDBC over HTTP：這樣我們對RMI over IIOP, soap over HTTP, http tunnel原理有更深入的理解。

4、什么是long connection（jdbc的socket)，什么是short connection（http)，具體怎么實現？
3和4這些在HSQLDB的org.hsqldb.HTTPClientConnection類里有實現。

5、Java客戶端和服務器端的通訊實現：jdbc driver就可以認為是一個java客戶端類庫。那么JMS client呢？還有，像mysql有各種語言的driver，原理是什么。

6、sql這種command、描述型語言究竟在數據庫里面是個什么地位：sql是怎么傳入jdbc driver，最終和database交互的？我們是否可以設計出另外一種command，形成一種行業標準，它在服務器和客戶端怎么實現的。

以上我的表達可能有些晦澀，我只想表達一點：大家有興趣就多讀讀經典的源碼，擴展一下自己的設計思路?？赡芎芏嗳讼笪乙粯?，總有忙不完的項目，那么抽幾個小時就夠了，不必深入。
有很多技術我們理解總是很模糊，當你深入到內部，忽然發現原來就這么回事。我們總覺得IoC很神秘，其實最簡單的IoC容器，也許一個HashMap就夠了。


引用的http://www.javaeye.com/topic/80532

?

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO

?

ALTER???????????? PROCEDURE spITM_CheckPaperList(
@intCount??INT Output??,
@chvKeywords??????????? VARCHAR(100),??????????? --關鍵字
@chvinterunittypeid???????????? varchar(100),
?@dtmdatelowerlimit?????????????? DATETIME ,
@dtmdateupperlimit????????????? DATETIME ,
@isspecialbuy???????????? int,
@checkresultid??????????? int,
? @intAudit???????????????????????? INT,??????????????????????????????? --審批狀態
@chvEmployeeTypeID?VARCHAR(100)?,??--職員id
@bitViewPersonalLimit??BIT,??--瀏覽個人
@bitViewDepartmentLimit?BIT,??--瀏覽部門
@bitEmployeeIsManager??BIT,??--瀏覽全部
?? @chvOrgTypeID??????????? VARCHAR(100),?
@intPageSize??INT??,
@intPageNo??INT??
)
AS
--權限控制條件開始
DECLARE @chvEmployeeDepartment??VARCHAR(36)
DECLARE @bitEmployeeIsAdmin??BIT
SELECT @chvEmployeeDepartment = '000'

IF EXISTS(SELECT TypeID FROM CRM_Employee WHERE TypeID = @chvEmployeeTypeID)
?AND
?EXISTS(SELECT Count(*) FROM CRM_LoginUser WHERE InnerObject = 'Employee' AND InnerObjectTypeID = @chvEmployeeTypeID)
BEGIN
?--SELECT @chvEmployeeDepartment = [Department] FROM [CRM_Employee] WHERE [TypeID] = @chvEmployeeTypeID
?SELECT @bitEmployeeIsAdmin = IsAdmin FROM CRM_LoginUser WHERE InnerObject = 'Employee' AND InnerObjectTypeID = @chvEmployeeTypeID
?--deal? empty 2007/1/22
?SELECT @chvEmployeeDepartment = case @chvEmployeeDepartment when ' ' then? '000' else? @chvEmployeeDepartment end
END
ELSE
BEGIN
?SELECT * FROM ITM_CheckPaper? WHERE TypeID = '0'?--返回一個空的記錄集
?RETURN
END
--權限控制條件結束--
select a.*? ,b.Name VendorName,? ww.Name CheckPaperName,
w.Name CreatorName
??INTO #ITM_CheckPaperListPageTable
?? from ITM_CheckPaper as? a?
???????????? left JOIN CRM_Employee w????? ON a.CreatorTypeID = w.TypeID
?????? left join CRM_Employee ww on a.CHECKERTYPEID=ww.Typeid
??LEFT JOIN scm_Vendor b ON a.VendorTypeID = b.TypeID
WHERE
?a.OrgTypeID = @chvOrgTypeID and
(
?a.SERIALNUMBER???? like '%'+@chvKeywords+'%' or
?a.ContractNo???????????????? like '%'+@chvKeywords+'%' or
b.Name???????????????? like '%'+@chvKeywords+'%' or
?a.CheckSite???? like '%'+@chvKeywords+'%'
)
--and
--a.AuditFlag = case @intAudit
? ---??????????????????????? when 0 then a.AuditFlag
? --?????????????????????? else @intAudit
? --??????????????????? end
--權限控制條件開始--
AND
(
?@bitViewDepartmentLimit = 1
?AND
?(
?ISNULL(w.[Department],'001') LIKE ISNULL(@chvEmployeeDepartment,'not the same') + '%'
?OR
?ISNULL(w.[Department2],'001') LIKE ISNULL(@chvEmployeeDepartment,'not the same') + '%'
?OR
?ISNULL(w.[Department3],'001') LIKE? ISNULL(@chvEmployeeDepartment,'not the same') + '%'
?)
?OR
?a.[CreatorTypeID] = @chvEmployeeTypeID? AND? @bitViewPersonalLimit = 1
?OR
?@bitEmployeeIsAdmin = 1
?OR
?@bitEmployeeIsManager = 1
?OR
?a.[EmployeeRange] LIKE '%' +@chvEmployeeTypeID +'%'
)
--權限控制條件結束--
--Order by a.CreateDate desc
---------------判斷是否取記錄數
if @intCount = 1
Begin
?SELECT @intCount=Count(0)
?FROM #ITM_CheckPaperListPageTable;
End
--------------------------取記錄數完成
DECLARE @chvSql??VARCHAR(1000)
--處理大于總頁數時的請求頁數
DECLARE @intPageCount?INT
SELECT @intPageCount = (@intCount + @intPageSize-1) / @intPageSize;
IF @intPageNo > 1 AND @intPageNo > @intPageCount
?SELECT @intPageNo = @intPageCount
ELSE IF @intPageNo > @intPageCount
?SELECT @intPageNo = 1
--處理大于總頁數時的請求頁數結束
Select @chvSql = 'SELECT TOP ' + Str(@intPageSize) + '? *? ' +
' FROM #ITM_CheckPaperListPageTable a ' +
' WHERE a.TypeID not in ' +
' (select top ' + Str((@intPageNo - 1) * @intPageSize) + ' TypeID from #ITM_CheckPaperListPageTable )'
Exec(@chvSql)
Drop Table #ITM_CheckPaperListPageTable

?

?

?

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

?

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN 2.0//EN" "

<!--
? - DispatcherServlet application context for the Countries web tier.
? -->
<beans>

public interface Controller {

    /**
     * Process the request and return a ModelAndView object which the DispatcherServlet
     * will render.
     */
    ModelAndView handleRequest(
        HttpServletRequest request,
        HttpServletResponse response) throws Exception;

}

package samples;

public class SampleController extends AbstractController {

    public ModelAndView handleRequestInternal(
        HttpServletRequest request,
        HttpServletResponse response) throws Exception {

        ModelAndView mav = new ModelAndView("hello");
        mav.addObject("message", "Hello World!");
        return mav;        
    }
}

<bean id="sampleController" class="samples.SampleController">
    <property name="cacheSeconds" value="120"/>
</bean>

								
										// anyMeaningfulName can be replaced by any methodname
								
public [ModelAndView | Map | void] anyMeaningfulName(HttpServletRequest, HttpServletResponse [, Exception | AnyObject]);

public ModelAndView doRequest(HttpServletRequest, HttpServletResponse)

public ModelAndView doLogin(HttpServletRequest, HttpServletResponse, Login)

public ModelAndView processException(HttpServletRequest, HttpServletResponse, IllegalArgumentException)

public void goHome(HttpServletRequest, HttpServletResponse)

public Map doRequest(HttpServletRequest, HttpServletResponse)

<bean id="paramResolver" class="org....mvc.multiaction.ParameterMethodNameResolver">
  <property name="paramName" value="method"/>
</bean>

<bean id="paramMultiController" class="org....mvc.multiaction.MultiActionController">
  <property name="methodNameResolver" ref="paramResolver"/>
  <property name="delegate" ref="sampleDelegate"/>
</bean>

<bean id="sampleDelegate" class="samples.SampleDelegate"/>

## together with

public class SampleDelegate {

    public ModelAndView retrieveIndex(HttpServletRequest req, HttpServletResponse resp) {

        return new ModelAndView("index", "date", new Long(System.currentTimeMillis()));
    }
}

<bean id="propsResolver" class="org....mvc.multiaction.PropertiesMethodNameResolver">
  <property name="mappings">
    <value>
        /index/welcome.html=retrieveIndex
        /**/notwelcome.html=retrieveIndex
        /*/user?.html=retrieveIndex
    </value>
  </property>
</bean>

<bean id="paramMultiController" class="org....mvc.multiaction.MultiActionController">
    <property name="methodNameResolver" ref="propsResolver"/>
    <property name="delegate" ref="sampleDelegate"/>
</bean>

就象和Spring集成的其他表現層技術一樣，對于JSP頁面你需要一個視圖解析器來解析。最常用的JSP視圖解析器是InternalResourceViewResolver和ResourceBundleViewResolver。它們被定義在WebApplicationContext里：

# The ResourceBundleViewResolver:
<bean id="viewResolver" class="org.springframework.web.servlet.view.ResourceBundleViewResolver">
    <property name="basename"><value>views</value></property>
</bean>

# And a sample properties file is uses (views.properties in WEB-INF/classes):
welcome.class=org.springframework.web.servlet.view.JstlView
welcome.url=/WEB-INF/jsp/welcome.jsp

productList.class=org.springframework.web.servlet.view.JstlView
productList.url=/WEB-INF/jsp/productlist.jsp

你可以看到ResourceBundleViewResolver需要一個屬性文件來把視圖名稱映射到 1)類和 2) URL。 通過ResolverBundleViewResolver，你可以用一個解析器來解析兩種類型的視圖。

<bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    <property name="viewClass"><value>org.springframework.web.servlet.view.JstlView</value></property>
    <property name="prefix"><value>/WEB-INF/jsp/</value></property>
    <property name="suffix"><value>.jsp</value></property>
</bean>

InternalResourceBundleViewResolver可以配置成使用JSP頁面。作為好的實現方式，強烈推薦你將JSP文件放在WEB-INF下的一個目錄中，這樣客戶端就不會直接訪問到它們。

2007-07-18

Spring的事務通知???