sql_map_config.xml(SQL Map»·¾³Îļþ)
<?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>
<!-- ÅäÖúÍÓÅ»¯SQL Map½âÎöʵÀýµÄÉ趨 -->
<settings cacheModelsEnabled="true" //SQL MapÔËÐÐʱʵÀýµÄ»º´æModelÊÇ·ñ¿ªÆô
enhancementEnabled="true" //È«¾ÖÐÔµÄÆôÓûò½ûÓÃ×Ö½ÚÂëÔöÇ¿£¬ÒÔÓÅ»¯·ÃÎÊPOJO±äÁ¿ÊôÐԵŦÄÜ
lazyLoadingEnabled="true" //³Ö¾Ã»¯Êý¾ÝÊÇ·ñÑÓ³Ù¼ÓÔØ
maxRequests="32" //ͬʱִÐÐsqlÓï¾äµÄ×î´óÐÐÊý
maxSessions="10" //ͬһʱ¼äÄڻµÄ×î´óSessionÊý¡£ËùνµÄSession¾ÍÊÇÒ»¸öÇëÇó»òÒ»¸öSQL MapÔËÐÐʱʵÀý×Ô¶¯»ñµÃµÄ»á»°
maxTransactions="5" //ÖÆ¶¨ÁË×î´óÊÂÎñ´¦ÀíµÄÏß³ÌÊý
useStatementNamespaces="true" />//ÖÆ¶¨ÁËÔÚSQL MapÓ³ÉäÎļþÖÐÊÇ·ñÓÃÈ«ÏÞ¶¨ÃûÀ´ÒýÓÃÓ³ÉäÉùÃ÷
<!-- ÅäÖÃÁ¬½Ó -->
<transactionManager type="JDBC" >
<dataSource type="SIMPLE">
<property name="JDBC.Driver" value="oracle.jdbc.OracleDriver"/>
<property name="JDBC.ConnectionURL"
value="jdbc:oracle:thin:@localhost:1521:orcl"/>
<property name="JDBC.Username" value="system"/>
<property name="JDBC.Password" value="abcd"/>
<!-- ×î´óÁ¬½ÓÊý -->
<property name="Pool.MaximumActiveConnections" value="10"/>
</dataSource>
</transactionManager>
<!-- SQL MapÓ³ÉäÎļþµÄÈ¡µÃ… -->
<sqlMap resource="fw_student_SqlMap.xml" />
</sqlMapConfig>
Ïà¹ØÎĵµ£º
»·¾³£ºJDK1.5
Êý¾Ý¿â£ºSql server 2005 +sp2
JDBCÇý¶¯£ºsqljdbc.jar
²âÊÔÀà´úÂëÈçÏ£º
import java.sql.*;
public class test {
/**
* @param args
* @throws SQLException
* @throws ClassNotFoundException
*/
public static void main(String[] args) throws SQL ......
½ÓÉÏÆª
ËÄ£¬¸ù¾ÝÌõ¼þÓÐÑ¡ÔñµÄUPDATE¡£
Àý£¬ÓÐÈçϸüÐÂÌõ¼þ
¹¤×Ê5000ÒÔÉϵÄÖ°Ô±£¬¹¤×ʼõÉÙ10%
¹¤×ÊÔÚ2000µ½4600Ö®¼äµÄÖ°Ô±£¬¹¤×ÊÔö¼Ó15%
ºÜÈÝÒ׿¼ÂǵÄÊÇÑ¡ÔñÖ´ÐÐÁ½´ÎUPDATEÓï¾ä£¬ÈçÏÂËùʾ
--Ìõ¼þ1
UPDATE Personnel
SET salary = salary * 0.9
WHERE salary >= 5000;
--Ìõ¼þ2
UPDATE Personnel
SET sala ......
"SQL Server ²»´æÔÚ»ò·ÃÎʱ»¾Ü¾ø "
Õâ¸öÊÇ×ÔÓµÄ,´íÎó·¢ÉúµÄÔÒò±È½Ï¶à,ÐèÒª¼ì²éµÄ·½ÃæÒ²±È½Ï¶à.
Ò»°ã˵À´,ÓÐÒÔϼ¸ÖÖ¿ÉÄÜÐÔ:
1,SQL ServerÃû³Æ»òIPµØÖ·Æ´Ð´ÓÐÎó
2,·þÎñÆ÷¶ËÍøÂçÅäÖÃÓÐÎó
3,¿Í»§¶ËÍøÂçÅäÖÃÓÐÎó
Òª½â¾öÕâ¸öÎÊÌâ,ÎÒÃÇÒ»°ãÒª×ñÑÒÔϵIJ½ÖèÀ´Ò»²½²½ÕÒ³öµ¼Ö´íÎóµÄÔÒò.
= ......
Æäʵɾ³ýÊý¾Ý¿âÖÐÊý¾ÝµÄ·½·¨²¢²»¸´ÔÓ£¬ÎªÊ²Ã´ÎÒ»¹Òª¶à´ËÒ»¾ÙÄØ£¬Ò»ÊÇÎÒÕâÀï½éÉܵÄÊÇɾ³ýÊý¾Ý¿âµÄËùÓÐÊý¾Ý£¬ÒòΪÊý¾ÝÖ®¼ä¿ÉÄÜÐγÉÏà»¥Ô¼Êø¹ØÏµ£¬É¾³ý²Ù×÷¿ÉÄÜÏÝÈëËÀÑ»·£¬¶þÊÇÕâÀïʹÓÃÁË΢ÈíδÕýʽ¹«¿ªµÄsp_MSForEachTable´æ´¢¹ý³Ì¡£
¡¡¡¡Ò²ÐíºÜ¶à¶ÁÕßÅóÓѶ¼¾Àú¹ýÕâÑùµÄÊÂÇ飺ҪÔÚ¿ª·¢Êý¾Ý¿â»ù´¡ÉÏÇåÀíÒ»¸ö¿Õ¿â£¬µ«ÓÉÓÚ¶ÔÊ ......
1¡¢³£ÓÃÈÕÆÚ·½·¨(ÏÂÃæµÄGetDate() = '2006-11-08 13:37:56.233')
(1)DATENAME ( datepart ,date )
·µ»Ø±íʾָ¶¨ÈÕÆÚµÄÖ¸¶¨ÈÕÆÚ²¿·ÖµÄ×Ö·û´®¡£DatepartÏê¼ûÏÂÃæµÄÁбí.
SELECT DateName(day,Getdate()) –·µ»Ø8
(2)DATEPART ( datepart , date )
·µ»Ø±íʾָ¶¨ÈÕÆÚµÄÖ¸ ......