??xml version="1.0" encoding="utf-8" standalone="yes"?>国语产色综合,亚洲三级一区,一本大道久久a久久综合婷婷http://www.aygfsteel.com/kang-ak/开发心?/description>zh-cnSat, 05 Jul 2025 19:56:56 GMTSat, 05 Jul 2025 19:56:56 GMT60面跌{http://www.aygfsteel.com/kang-ak/archive/2007/12/14/167749.htmljava fan nbjava fan nbFri, 14 Dec 2007 05:15:00 GMThttp://www.aygfsteel.com/kang-ak/archive/2007/12/14/167749.htmlhttp://www.aygfsteel.com/kang-ak/comments/167749.htmlhttp://www.aygfsteel.com/kang-ak/archive/2007/12/14/167749.html#Feedback0http://www.aygfsteel.com/kang-ak/comments/commentRss/167749.htmlhttp://www.aygfsteel.com/kang-ak/services/trackbacks/167749.html

   对于开发对于页面连接尤如蜘蛛网一Pl常会有一堆具有千头万l的兌面l成的大中型Web应用来说Q如何组l及处理面的蟩转成Z个MVC框架非常关键因素。Struts1之所以能得到大家的认可,是因Z基本解决了数据与视图分离的问题,之所以Struts升一个版本到Struts2后不?#8220;Struts”了,核心原因除了框架核心技术落后、很多地方受限制以外Q一个原因是他无法很好地l织及处理页面蟩转问题。当然尽升U到了Struts2Q但相对于Rails{新兴MVC的框架来_昑־L了很多?br />    而EasyJWeb在页面组l及处理面跌{{方面,提供了很多更加灵zȝ功能Q很多思想来自于Spring MVC、Rails{一些新兴Web框架的精髓,他能让你用比较简z的代码、甚至不用代码来实现面的蟩转?br />   在Web应用E序开发中Q我们经帔R到如下的需求:
  1、从q个面q接到另外一个页面;
  2、在服务器执行完某一D늨序后Q把输出导向另外一个页面;
  3、在服务器端执行完某一D늨序后Q把输出导向到另外一D늨序l执行;
  4、在服务器程序执行完后,选择使用一个页面呈现用戯出;
  5、页面蟩转要h较强的环境适应能力Q比如部|在跟目录下跟部|到其它Context目录下都能执行正的跌{Q?br />   6、还有更变态的Q比如EasyJF官网Q要求?a target="_blank">动态地址讉K的时候,看到的地址全是动态,当?a target="_blank">静态地址讉K的时候,地址全是静态的QJava Web服务器不能工作了QApache或IIS也要保证|页能正常访问?br />   7、有的h喜欢使用/user/edit/1q样的urlQ有的h喜欢使用/user.ejf?cmd=edit&id=1q样的urlQ我们要求不用哪一Uurl样式讉K面Q连接都会非常友好的变成用户喜爱的Ş式?/p>

   可以_现在很少有框架能完全满或者ؓ用户考虑到如此复杂多变而对于我们国人来说应用性又非常q泛的需求。一些框架即使提供上面一些功能也是以书写复杂的代码及配置文gZL。在EasyJWeb中,提供了上面所列的q些功能Qƈ提供了非常简z的调用接口及方法?br />    针对上面的几点,EasyJWeb的解x案:
  1,q个?lt;a>标签Q不用说了?br />   2、在服务器执行完某一D늨序后Q把输出导向另外一个页面;
  q回htmlcd的Page对象?br />   3、在服务器端执行完某一D늨序后Q把输出导向到另外一D늨序l执行;
   使用forward或者goҎ?/strong>
  4、在服务器程序执行完后,选择使用一个页面呈现用戯出;
   使用pageҎ?br />   5、页面蟩转要h较强的环境适应能力Q比如部|在跟目录下跟部|到其它Context目录下都能执行正的跌{Q?br />   在页面模板中使用$html.urlQ比如:<a href="$html.url('user.list')">用户列表</a>?br />   6、不同地址样式转移
  在页面模板中使用$html.forwardQ比?lt;a href="$html. forward'('news.technic')">技术前?lt;/a>。这样动态的时候访问到的是news.ejf?cmd= technicQ静态的时候访问到的是/news/technic.html?/strong>
  7、传l及C的URL样式转换
   仍然是?html.urlQ或$html.forward标签Q他能感知你的url样式。比如:<a href="$html.url('user.add')">d用户</a>。你使用user.ejf?cmd=lsit,讉K应用Q则当点duser.ejf?cmd=add。而如果你使用/ejf/user/list讉K应用Q则~辑按钮的连接变成ejf/user/add?br />   
  在代码中Q除了可以用最原始的return new Page()方式q回用户的视图模板以外,q可以用一些快h法来实现灉|的视图查询及跌{。比如,go、forward、page{方法。下面看一个用h删改查的CZ中的Action代码如下Q?br />

import com.easyjf.container.annonation.Inject;
import com.easyjf.core.support.query.QueryObject;
import com.easyjf.util.CommUtil;
import com.easyjf.web.WebForm;
import com.easyjf.web.core.AbstractPageCmdAction;
import com.easyjf.web.tools.IPageList;

public class UserAction extends AbstractPageCmdAction {
 
 @Inject
 
private UserService service;
 
 
public void setService(UserService service) {
  
this.service = service;
 }

 
/**
  * 昄d用户的界面user/edit.html
  
*/

 
public void add()
 
{
  page(
"edit");
 }

 
public void edit(WebForm form)
 
{
  String id
=(String)form.get("id");
  User user
=this.service.getUser(new Long(id));
  form.addPo(user);
 }

 
public void save(WebForm form)
 
{
  User user
=form.toPo(User.class);
  
if(hasErrors())
  
{
   page(
"edit");
   
return;
  }

  service.saveUser(user);
  forward(
"list");
 }

 
public void update(WebForm form)
 
{
  String id
=(String)form.get("id");
  User user
=this.service.getUser(new Long(id));
  form.toPo(user,
true);
  
if(hasErrors())
  
{
   page(
"edit");
   
return;
  }

  service.updateUser(user);
  forward(
"list");
 }

 
public void delete(WebForm form)
 
{
  String id
=(String)form.get("id");
  User user
=this.service.getUser(new Long(id));
  service.delUser(user);
  go(
"list");
 }

 
public void list(WebForm form)
 
{
  QueryObject qo
=form.toPo(QueryObject.class);
  IPageList pageList
=service.queryUser(qo);
  CommUtil.saveIPageList2WebForm(pageList, form);  
 }

}


UserService接口Q?br />
public interface UserService {
 
/**
  * Ҏid查询用户
  * 
  * 
@param id
  * 
@return
  
*/

 User getUser(Long id);

 
/**
  * 保存用户
  * 
  * 
@param user
  
*/

 
void saveUser(User user);

 
/**
  * 修改用户信息
  * 
  * 
@param user
  
*/

 
void updateUser(User user);

 
/**
  * 删除用户
  * 
  * 
@param user
  
*/

 
void delUser(User user);

 
/**
  * 查询用户信息
  * 
@param query 
  * 
@return 分页信息及记录集
  
*/

 IPageList queryUser(IQueryObject query);
}




java fan nb 2007-12-14 13:15 发表评论
]]>
随机?/title><link>http://www.aygfsteel.com/kang-ak/archive/2007/12/14/167681.html</link><dc:creator>java fan nb</dc:creator><author>java fan nb</author><pubDate>Fri, 14 Dec 2007 02:06:00 GMT</pubDate><guid>http://www.aygfsteel.com/kang-ak/archive/2007/12/14/167681.html</guid><wfw:comment>http://www.aygfsteel.com/kang-ak/comments/167681.html</wfw:comment><comments>http://www.aygfsteel.com/kang-ak/archive/2007/12/14/167681.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.aygfsteel.com/kang-ak/comments/commentRss/167681.html</wfw:commentRss><trackback:ping>http://www.aygfsteel.com/kang-ak/services/trackbacks/167681.html</trackback:ping><description><![CDATA[<p>import java.util.ArrayList;<br /> import java.util.List;<br /> import java.util.Random;<br /> public class PrimeNumberTest {<br />  /** Creates a new instance of PrimeNumberTest */<br />  public PrimeNumberTest() { } <br /> public static void main(String[] args){<br />  //获得一?位数的随机大素数 <br /> long longVar4 = createRadomPrimeNunber(4); <br /> System.out.println(longVar4);<br />  //获得一?位数的随机大素数 <br /> long longVar5 = createRadomPrimeNunber(5); <br /> System.out.println(longVar5);<br />  } <br /> public static long createRadomPrimeNunber(int n){<br />  long recLong = 0; <br /> List list = listAllPrimeNumber(n); <br /> Random rd = new Random(); <br /> int randomIndex = Math.abs( rd.nextInt()%list.size()); <br /> recLong = ((Long)list.get(randomIndex)).longValue(); <br /> return recLong; <br /> }<br />  public static List listAllPrimeNumber(int n){ <br /> List list = new ArrayList(); <br /> long low = (long)Math.pow(10,n-1);<br />  long high = (long)Math.pow(10,n) - 1; <br /> for(long i= low;i < high;i++){ <br /> if( isSushu(i)) { <br /> list.add(new Long(i)); <br /> } }<br />  return list; <br /> }<br />  public static boolean isSushu(long x){<br /> //定义一个判断一个数是否是素数的函数 <br /> if(x<2) return false; if( x==2)return true; <br /> for(long i=2;<br /> i<= (long)Math.sqrt(x);i++)<br />  if(x%i==0) <br /> return false; <br /> return true;<br />  }}</p> <br /> <br /> <br /> 例二<br /> <p>import java.util.Random;<br /> /**<br />  * Java实用工具cd中的cjava.util.Random提供了生各U类型随机数的方法?br />  * 它可以生int、long、float、double以及Goussian{类型的随机数?br />  * java.lang.Math中的Ҏrandom()只生double型的随机数?br />  */<br /> public class RandomNumber{</p> <p> public static void main(String[] args) {</p> <p>  // 使用java.lang.Math的randomҎ生成随机?br />   System.out.println("Math.random(): " + Math.random());</p> <p>  // 使用不带参数的构造方法构造java.util.Random对象<br />   System.out.println("使用不带参数的构造方法构造的Random对象:");<br />   Random rd1 = new Random();<br />   // 产生各种cd的随机数<br />   // 按均匀分布产生整数<br />   System.out.println("int: " + rd1.nextInt());<br />   // 按均匀分布产生长整?br />   System.out.println("long: " + rd1.nextLong());<br />   // 按均匀分布产生大于{于0Q小?的float数[0, 1)<br />   System.out.println("float: " + rd1.nextFloat());<br />   // 按均匀分布产生[0, 1)范围的double?br />   System.out.println("double: " + rd1.nextDouble());<br />   // 按正态分布生随机数<br />   System.out.println("Gaussian: " + rd1.nextGaussian());</p> <p>  // 生成一pd随机?br />   System.out.print("随机整数序列:");<br />   for (int i = 0; i < 5; i++) {<br />    System.out.print(rd1.nextInt() + "  ");<br />   }<br />   System.out.println();</p> <p>  // 指定随机C生的范围<br />   System.out.print("[0,10)范围内随机整数序? ");<br />   for (int i = 0; i < 10; i++) {<br />    // Random的nextInt(int n)Ҏq回一个[0, n)范围内的随机?br />    System.out.print(rd1.nextInt(10) + "  ");<br />   }<br />   System.out.println();<br />   System.out.print("[5,23)范围内随机整数序? ");<br />   for (int i = 0; i < 10; i++) {<br />    // 因ؓnextInt(int n)Ҏ的范围是?开始的Q?br />    // 所以需要把区间[5,28)转换? + [0, 23)?br />    System.out.print(5 + rd1.nextInt(23) + "  ");<br />   }<br />   System.out.println();<br />   System.out.print("利用nextFloat()生成[0,99)范围内的随机整数序列: ");<br />   for (int i = 0; i < 10; i++) {<br />    System.out.print((int) (rd1.nextFloat() * 100) + "  ");<br />   }<br />   System.out.println();<br />   System.out.println();</p> <p>  // 使用带参数的构造方法构造Random对象<br />   // 构造函数的参数是longcdQ是生成随机数的U子?br />   System.out.println("使用带参数的构造方法构造的Random对象:");<br />   Random ran2 = new Random(10);<br />   // 对于U子相同的Random对象Q生成的随机数序列是一L?br />   System.out.println("使用U子?0的Random对象生成[0,10)内随机整数序? ");<br />   for (int i = 0; i < 10; i++) {<br />    System.out.print(ran2.nextInt(10) + "  ");<br />   }<br />   System.out.println();<br />   Random ran3 = new Random(10);<br />   System.out.println("使用另一个种子ؓ10的Random对象生成[0,10)内随机整数序? ");<br />   for (int i = 0; i < 10; i++) {<br />    System.out.print(ran3.nextInt(10) + "  ");<br />   }<br />   System.out.println();<br />   // ran2和ran3生成的随机数序列是一LQ如果用两个没带参数构造函数生成的Random对象Q?br />   // 则不会出现这U情况,q是因ؓ在没带参数构造函数生成的Random对象的种子缺省是当前pȝ旉的毫U数?/p> <p>  // 另外Q直接用Random无法避免生成重复的数字,如果需要生成不重复的随机数序列Q需要借助数组和集合类<br />   //本书W?章将l出解决Ҏ?br />  }<br /> }</p> <p>q行l果Q?br /> C:\>java  RandomNumber<br /> Math.random(): 0.525171492959965<br /> 使用不带参数的构造方法构造的Random对象:<br /> int: 636539740<br /> long: -752663949229005813<br /> float: 0.87349784<br /> double: 0.4065973309853902<br /> Gaussian: 0.4505871918488808<br /> 随机整数序列:1936784917  1339857386  -1185229615  1883411721  1409219372<br /> [0,10)范围内随机整数序? 1  1  5  5  9  0  1  0  2  4<br /> [5,23)范围内随机整数序? 9  13  26  18  11  27  26  12  21  8<br /> 利用nextFloat()生成[0,99)范围内的随机整数序列: 1  47  72  59  49  86  80  88  55   82</p> <p>使用带参数的构造方法构造的Random对象:<br /> 使用U子?0的Random对象生成[0,10)内随机整数序?<br /> 3  0  3  0  6  6  7  8  1  4<br /> 使用另一个种子ؓ10的Random对象生成[0,10)内随机整数序?<br /> 3  0  3  0  6  6  7  8  1  4<br /> <br /> <br /> <br /> 例三:带随机种子的随机?br />    <br />   import   java.util.*;   <br />     <br />   public   class   test   {   <br />   public   static   void   main(String[]   args)   {   <br />   Random   rand   =   new   Random();   <br />   for(int   i   =   0;   i   <   10;   i++)   {   <br />                                                           rand.setSeed(i);   <br />   System.out.println(rand.nextInt());   <br />   }   <br />   }   <br />   }   <br /> <br /> </p> <img src ="http://www.aygfsteel.com/kang-ak/aggbug/167681.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/kang-ak/" target="_blank">java fan nb</a> 2007-12-14 10:06 <a href="http://www.aygfsteel.com/kang-ak/archive/2007/12/14/167681.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title> 如何快速生?00万不重复?位编?/title><link>http://www.aygfsteel.com/kang-ak/archive/2007/12/14/167672.html</link><dc:creator>java fan nb</dc:creator><author>java fan nb</author><pubDate>Fri, 14 Dec 2007 01:47:00 GMT</pubDate><guid>http://www.aygfsteel.com/kang-ak/archive/2007/12/14/167672.html</guid><wfw:comment>http://www.aygfsteel.com/kang-ak/comments/167672.html</wfw:comment><comments>http://www.aygfsteel.com/kang-ak/archive/2007/12/14/167672.html#Feedback</comments><slash:comments>1</slash:comments><wfw:commentRss>http://www.aygfsteel.com/kang-ak/comments/commentRss/167672.html</wfw:commentRss><trackback:ping>http://www.aygfsteel.com/kang-ak/services/trackbacks/167672.html</trackback:ping><description><![CDATA[<p style="background: #ccffff; margin: 0cm 0cm 0pt"><font size="3"><strong><span style="color: red; font-family: 宋体">生成</span><span style="color: red"><font face="Times New Roman">100</font></span></strong><strong><span style="color: red; font-family: 宋体">万条</span><span style="color: red"><font face="Times New Roman">8</font></span></strong><strong><span style="color: red; font-family: 宋体">位不重复数据的示?/span></strong></font></p> <div style="border-right: medium none; padding-right: 0cm; border-top: windowtext 1pt solid; padding-left: 0cm; background: #f3f3f3; padding-bottom: 1pt; border-left: medium none; padding-top: 1pt; border-bottom: windowtext 1pt solid"> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; color: blue; font-family: 'Courier New'">USE</span><span style="font-size: 9pt; font-family: 'Courier New'"> tempdb</span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; font-family: 'Courier New'">GO</span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; color: green; font-family: 'Courier New'">-- </span><span style="font-size: 9pt; color: green; font-family: 宋体">创徏试?/span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; color: blue; font-family: 'Courier New'">CREATE</span><span style="font-size: 9pt; font-family: 'Courier New'"> <span style="color: blue">TABLE</span> tb<span style="color: gray">(</span>id <span style="color: blue">char</span><span style="color: gray">(</span>8<span style="color: gray">))</span></span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; color: green; font-family: 'Courier New'">-- </span><span style="font-size: 9pt; color: green; font-family: 宋体">创徏用于自动qo重复值的唯一索引</span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; color: blue; font-family: 'Courier New'">CREATE</span><span style="font-size: 9pt; font-family: 'Courier New'"> <span style="color: blue">UNIQUE</span> <span style="color: blue">INDEX</span> IX_tb <span style="color: blue">ON</span> tb<span style="color: gray">(</span>id<span style="color: gray">)</span></span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; color: blue; font-family: 'Courier New'">WITH</span><span style="font-size: 9pt; font-family: 'Courier New'"> IGNORE_DUP_KEY </span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; font-family: 'Courier New'">GO</span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; color: green; font-family: 'Courier New'">-- </span><span style="font-size: 9pt; color: green; font-family: 宋体">试数据插入的处理时?/span><span style="font-size: 9pt; color: green; font-family: 'Courier New'">, </span><span style="font-size: 9pt; color: green; font-family: 宋体">记录开始处理的旉?/span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; color: blue; font-family: 'Courier New'">DECLARE</span><span style="font-size: 9pt; font-family: 'Courier New'"> @dt <span style="color: blue">datetime</span></span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; color: blue; font-family: 'Courier New'">SET</span><span style="font-size: 9pt; font-family: 'Courier New'"> @dt <span style="color: gray">=</span> <span style="color: fuchsia">GETDATE</span><span style="color: gray">()</span></span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; color: green; font-family: 'Courier New'">-- </span><span style="font-size: 9pt; color: green; font-family: 宋体">插入随机数据</span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; color: blue; font-family: 'Courier New'">SET</span><span style="font-size: 9pt; font-family: 'Courier New'"> <span style="color: blue">NOCOUNT</span> <span style="color: blue">ON</span></span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; color: blue; font-family: 'Courier New'">DECLARE</span><span style="font-size: 9pt; font-family: 'Courier New'"> @row <span style="color: blue">int</span></span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; color: blue; font-family: 'Courier New'">SET</span><span style="font-size: 9pt; font-family: 'Courier New'"> @row <span style="color: gray">=</span> 1000000 <span style="color: green">-- </span></span><span style="font-size: 9pt; color: green; font-family: 宋体">讄总记录数</span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; color: blue; font-family: 'Courier New'">WHILE</span><span style="font-size: 9pt; font-family: 'Courier New'"> @row <span style="color: gray">></span>0</span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; color: blue; font-family: 'Courier New'">BEGIN</span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; font-family: 'Courier New'">    <span style="color: green">-- </span></span><span style="font-size: 9pt; color: green; font-family: 宋体">昄提示信息</span><span style="font-size: 9pt; color: green; font-family: 'Courier New'">, </span><span style="font-size: 9pt; color: green; font-family: 宋体">表示q需要插入多行数?/span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; font-family: 'Courier New'">    <span style="color: blue">RAISERROR</span><span style="color: gray">(</span><span style="color: red">'need %d rows'</span><span style="color: gray">,</span> 10<span style="color: gray">,</span> 1<span style="color: gray">,</span> @row<span style="color: gray">)</span> <span style="color: blue">WITH</span> NOWAIT</span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; font-family: 'Courier New'">    <span style="color: green">-- </span></span><span style="font-size: 9pt; color: green; font-family: 宋体">插入随机的位~码数据</span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; font-family: 'Courier New'">    <span style="color: blue">SET</span> <span style="color: blue">ROWCOUNT</span> @row</span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; font-family: 'Courier New'">    <span style="color: blue">INSERT</span> tb <span style="color: blue">SELECT</span></span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; font-family: 'Courier New'">        id <span style="color: gray">=</span> <span style="color: gray">RIGHT(</span>100000000 <span style="color: gray">+</span> <span style="color: fuchsia">CONVERT</span><span style="color: gray">(</span><span style="color: blue">bigint</span><span style="color: gray">,</span> <span style="color: fuchsia">ABS</span><span style="color: gray">(</span><span style="color: fuchsia">CHECKSUM</span><span style="color: gray">(</span><span style="color: fuchsia">NEWID</span><span style="color: gray">()))),</span> 8<span style="color: gray">)</span></span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; font-family: 'Courier New'">    <span style="color: blue">FROM</span> syscolumns c1<span style="color: gray">,</span> syscolumns c2</span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; font-family: 'Courier New'">    <span style="color: blue">SET</span> @row <span style="color: gray">=</span> @row <span style="color: gray">-</span> <span style="color: fuchsia">@@ROWCOUNT</span></span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; color: blue; font-family: 'Courier New'">END</span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; color: green; font-family: 'Courier New'">-- </span><span style="font-size: 9pt; color: green; font-family: 宋体">昄插入数据使用的时?/span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; color: blue; font-family: 'Courier New'">SELECT</span><span style="font-size: 9pt; font-family: 'Courier New'"> BeginDate <span style="color: gray">=</span> @dt<span style="color: gray">,</span> EndDate <span style="color: gray">=</span> <span style="color: fuchsia">GETDATE</span><span style="color: gray">(),</span> </span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; font-family: 'Courier New'">    Second <span style="color: gray">=</span> <span style="color: fuchsia">DATEDIFF</span><span style="color: gray">(</span>Second<span style="color: gray">,</span> @dt<span style="color: gray">,</span> <span style="color: fuchsia">GETDATE</span><span style="color: gray">()),</span></span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; font-family: 'Courier New'">GO</span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; color: green; font-family: 'Courier New'">-- </span><span style="font-size: 9pt; color: green; font-family: 宋体">昄最l的l果记录是否正确</span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; color: blue; font-family: 'Courier New'">SELECT</span><span style="font-size: 9pt; font-family: 'Courier New'"> <span style="color: fuchsia">COUNT</span><span style="color: gray">(*)</span> <span style="color: blue">FROM</span> tb</span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; font-family: 'Courier New'">GO</span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; color: green; font-family: 'Courier New'">-- </span><span style="font-size: 9pt; color: green; font-family: 宋体">删除试</span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; color: blue; font-family: 'Courier New'">DROP</span><span style="font-size: 9pt; font-family: 'Courier New'"> <span style="color: blue">TABLE</span> tb</span></p> </div> <p style="background: #ccffff; margin: 0cm 0cm 0pt"><strong><font size="3"><span style="color: red; font-family: 宋体">解决中用到的技巧:</span></font></strong></p> <div style="border-right: medium none; padding-right: 0cm; border-top: windowtext 1pt solid; padding-left: 0cm; background: #f3f3f3; padding-bottom: 1pt; border-left: medium none; padding-top: 1pt; border-bottom: windowtext 1pt solid"> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt 21pt; border-left: medium none; text-indent: -21pt; padding-top: 0cm; border-bottom: medium none; tab-stops: list 21.0pt"><span style="color: blue"><font face="Times New Roman"><font size="3">1Q?/font><span style="font: 7pt 'Times New Roman'">    </font></span></span><font size="3"><span style="color: blue; font-family: 宋体">控制产生的数据不重复Q直接用唯一索引中的</span></font><span style="font-size: 9pt; color: red; font-family: 'Courier New'">IGNORE_DUP_KEY</span><span style="font-size: 9pt; color: blue; font-family: 宋体">选项Q插入数据中的重复D动过滤,避免手工处理重复</span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt 21pt; border-left: medium none; text-indent: -21pt; padding-top: 0cm; border-bottom: medium none; tab-stops: list 21.0pt"><span style="color: blue"><font face="Times New Roman"><font size="3">2Q?/font><span style="font: 7pt 'Times New Roman'">    </font></span></span><font size="3"><span style="color: blue; font-family: 宋体">使用</span><font face="Times New Roman"><span style="color: red">CHECKSUM</span></font><span style="color: blue; font-family: 宋体">配合</span><font face="Times New Roman"><span style="color: red">NEWID()</span></font><span style="color: blue; font-family: 宋体">函数Q生成的数据尽量随机,一般生成随机数会考虑使用</span><font face="Times New Roman"><span style="color: red">RAND()</span></font><span style="color: blue; font-family: 宋体">函数Q但q个函数是生伪随机|用下面的语句试一下,会发C生的数据全部是一LQ这不适用于想扚w生成多个随机敎ͼ?/span><font face="Times New Roman"><span style="color: red">NEWID()</span></font><span style="color: blue; font-family: 宋体">函数生成的是</span><span style="color: blue"><font face="Times New Roman">GUID</font></span><span style="color: blue; font-family: 宋体">Q基本上不会有重复的Q再通过</span><span style="color: red"><font face="Times New Roman">CHECKSUM</font></span><span style="color: blue; font-family: 宋体">其转化成数字,q样产生重复的可能性会比较?/span></font></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #ffcc99; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; color: blue; font-family: 'Courier New'">SELECT</span><span style="font-size: 9pt; font-family: 'Courier New'"> <span style="color: blue">TOP</span> 10</span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #ffcc99; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none; text-align: left" align="left"><span style="font-size: 9pt; font-family: 'Courier New'">    <span style="color: fuchsia">RAND</span><span style="color: gray">()</span></span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #ffcc99; padding-bottom: 0cm; margin: 0cm 0cm 0pt; border-left: medium none; padding-top: 0cm; border-bottom: medium none"><span style="font-size: 9pt; color: blue; font-family: 'Courier New'">FROM</span><span style="font-size: 9pt; font-family: 'Courier New'"> sysobjects</span></p> <p style="border-right: medium none; padding-right: 0cm; border-top: medium none; padding-left: 0cm; background: #f3f3f3; padding-bottom: 0cm; margin: 0cm 0cm 0pt 21pt; border-left: medium none; text-indent: -21pt; padding-top: 0cm; border-bottom: medium none; tab-stops: list 21.0pt"><span style="color: blue"><font face="Times New Roman"><font size="3">3Q?/font><span style="font: 7pt 'Times New Roman'">    </font></span></span><font size="3"><span style="color: blue; font-family: 宋体">在效率控Ӟ使用循环</span><span style="color: blue"><font face="Times New Roman">+</font></span><span style="color: blue; font-family: 宋体">扚w生成的方式,而不是传l的逐个生成。在</span><span style="color: blue"><font face="Times New Roman">SQL Server</font></span><span style="color: blue; font-family: 宋体">中,每个插入语句都会有一个内部的事务处理Q如果逐条插入Q则事务的开销太大Q效率势必非怽Q不考虑一ơ性生?/span><span style="color: blue"><font face="Times New Roman">100</font></span><span style="color: blue; font-family: 宋体">万数据,一则因为生成的数据可能有重复的Q去掉重复就没有</span><span style="color: blue"><font face="Times New Roman">100</font></span><span style="color: blue; font-family: 宋体">万了Q二则一ơ性生?/span><span style="color: blue"><font face="Times New Roman">100</font></span><span style="color: blue; font-family: 宋体">万数据,消耗的内存?/span><span style="color: blue"><font face="Times New Roman">CPU</font></span><span style="color: blue; font-family: 宋体">资源也很高,一般的电脑可能承受不住</span></font></p> </div> <img src ="http://www.aygfsteel.com/kang-ak/aggbug/167672.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/kang-ak/" target="_blank">java fan nb</a> 2007-12-14 09:47 <a href="http://www.aygfsteel.com/kang-ak/archive/2007/12/14/167672.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item></channel></rss> <footer> <div class="friendship-link"> <a href="http://www.aygfsteel.com/" title="狠狠久久亚洲欧美专区_中文字幕亚洲综合久久202_国产精品亚洲第五区在线_日本免费网站视频">狠狠久久亚洲欧美专区_中文字幕亚洲综合久久202_国产精品亚洲第五区在线_日本免费网站视频</a> </div> </footer> վ֩ģ壺 <a href="http://" target="_blank">¡</a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank">ˮ</a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank">ƾ</a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank">ݳ</a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank">گ</a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank">ְ</a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank">鱦</a>| <a href="http://" target="_blank">̩</a>| <a href="http://" target="_blank">˼</a>| <a href="http://" target="_blank">п</a>| <a href="http://" target="_blank">ԭ</a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank">ǧ</a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <a href="http://" target="_blank"></a>| <script> (function(){ var bp = document.createElement('script'); var curProtocol = window.location.protocol.split(':')[0]; if (curProtocol === 'https') { bp.src = 'https://zz.bdstatic.com/linksubmit/push.js'; } else { bp.src = 'http://push.zhanzhang.baidu.com/push.js'; } var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(bp, s); })(); </script> </body>