Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

jsp Á´½ÓOracleµÄÁ¬½Ó³ØºÍ²éÑ¯Ìø×ª´úÂ루´øµÇ¼£©

'-------------------------------------------------------------------ÒÔÏÂÊǵǼ´úÂë
<%@ page contentType="text/html; charset=gb2312"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>ÐÅÏ¢²éѯϵͳ</title>
<style type="text/css">
<!--
body {
 margin-left: 0px;
 margin-top: 0px;
 margin-right: 0px;
 margin-bottom: 0px;
}
body,td,th {
 font-size: 12px;
 color: #0000CC;
}
.text{ border:1px #D1D1D1 solid; width:150px; height:20px;}
.STYLE1 {color: #FFFFFF}
-->
</style></head>
<body scroll="no">
<table width="1024" border="0" align="center" cellpadding="0" cellspacing="0" background="images/d.jpg"  height="473">
  <tr>
    <td width="328" height="136">&nbsp;</td>
    <td width="430">&nbsp;</td>
    <td width="266">&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td valign="top"><table width="100%" border="0" cellspacing="3" cellpadding="0">
   <form name="biaodan" action="cx.jsp"  method="post" id="formCard">
     <tr>
    <td height="25" valign="top" colspan="2">&nbsp;&nbsp;´øÓÐ<font color="#FF0000">* </font>ºÅΪ±ØÌîÏî,Á½Ïî¶¼±ØÐëÌîд</td>
     </tr>
     <tr>
    <td width="32%" height="35" align="right" >±àºÅ£º</td>
    <td><input type="text" name="aac157"  class="text" />
       <fon


Ïà¹ØÎĵµ£º

ORACLEºÍSQLÓï·¨Çø±ð¹éÄÉ

¹Ø¼ü×Ö: oracle & sql server
Êý¾ÝÀàÐͱȽÏ
ÀàÐÍÃû³Æ
Oracle
SQLServer
±È½Ï
×Ö·ûÊý¾ÝÀàÐÍ CHAR CHAR ¶¼Êǹ̶¨³¤¶È×Ö·û×ÊÁϵ«oracleÀïÃæ×î´ó¶ÈΪ2kb£¬SQLServerÀïÃæ×î´ó³¤¶ÈΪ8kb
±ä³¤×Ö·ûÊý¾ÝÀàÐÍ VARCHAR2 VARCHAR OracleÀïÃæ×î´ó³¤¶ÈΪ4kb£¬SQLServerÀïÃæ×î´ó³¤¶ÈΪ8kb
¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¹Ì¶¨³¤¶È×Ö· ......

[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(ËÄ)

±¾ÏµÁÐÎÄÕµ¼º½
[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(Ò»)--sum()
[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(¶þ)--max()
[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(Èý)--row_number() /rank()/dense_rank()
[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(ËÄ)--lag()/lead()
ÓÐʱºò±¨±íÉÏÃæÐèÒªÏÔʾ¸Ã±Ê²Ù×÷µÄÉÏÒ»²½Öè»òÕßÏÂÒ»²½ÖèµÄÏêϸÐÅÏ¢£¬Õâ¸öʱºò¿ ......

OracleÖÐÓÃÒ»¾äSQLÓï¾äʵÏÖÐÐÁÐת»»

SQL*PLus>   desc   emp;  
    Ãû³Æ                                                                   &nbs ......

JSPʵÏÖ¼¸Ãëºó×Ô¶¯Ìø×ªÄ³Ò³Ãæ²¢Ò³ÃæÉÏÏÔʾʱ¼äÔÚ×ß¶¯

<script language="javascript">
var times=6;
clock();
function clock()
{
   window.setTimeout('clock()',1000);
   times=times-1;
   time.innerHTML =times;
}
</script>
<head>
<meta http-equiv= "Refresh" content= "5;url=index.jsp "& ......

MyEclipseµÄjspÒ³ÃæÎÊÌâ


ÔÚÎÒÃÇ×°ºÃMyEclipseʱ,ÓÐʱ˫»÷´ò¿ªjspÒ³Ãæ,
»áÌáʾ´íÎó,ÎÞ·¨ÏÔÊ¾Ò³Ãæ.
Òò´ËÒª½«jspµÄĬÈÏ´ò¿ª·½Ê½¸Ä³É´úÂëÊÔͼ£º
°ì·¨:Ôڲ˵¥À¸µÄ
1.window—->perferences—–>General——->editors——>file associations
2.Ñ¡Ôñjsp——->Ñ¡ÔñÏàÓ¦µÄeditor¡¡Îªdef ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ