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"> </td>
<td width="430"> </td>
<td width="266"> </td>
</tr>
<tr>
<td> </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"> ´øÓÐ<font color="#FF0000">* </font>ºÅΪ±ØÌîÏî,Á½Ïî¶¼±ØÐëÌîд</td>
</tr>
<tr>
<td width="32%" height="35" align="right" >±àºÅ£º</td>
<td><input type="text" name="aac157" class="text" />
<fon
Ïà¹ØÎĵµ£º
¼ÆËã¼ä¸ôʱ¼ä£º
select f_date,f_cstime,f_cetime, (((SYSDATE- TO_DATE(f_date||f_cstime,'YYYYMMDDHH24MISS')) * 86400000)-((SYSDATE- TO_DATE(f_date||f_cetime,'YYYYMMDDHH24MISS')) * 86400000))/1000 CURRENT_MILLI from ycsq_t_hauthlog where f_cstime<>'999999'
½«×Ö·û´®×ª»»³ÉÈÕÆÚÀà:SYSDATE- TO_ ......
1.µ½http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/htdocs/winsoft.htmlÏÂÔØ
11.1.0.7.0 °æµÄ¼´Ê±¿Í»§¶Ë³ÌÐò°ü — Basic£¨²»ÊÇBasic Lite£©
2.½«ÏÂÔØµ½µÄÎļþ½âѹ£¬½âѹºóÎÒ½«Ä¿Â¼instantclient_11_1ÀïµÄÈ«²¿Îļþ¿½±´µ½ÁËÒ»¸öеÄĿ¼£ºE:\programs\OracleClient¡£ÄãÒ²¿ÉÒÔ²»¿½±´£¬Ö ......
±¾ÏµÁÐÎÄÕµ¼º½
[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(Ò»)--sum()
[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(¶þ)--max()
[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(Èý)--row_number() /rank()/dense_rank()
[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(ËÄ)--lag()/lead()
ÓÐЩʱºòÎÒÃÇÏ£ÍûµÃµ½Ö¸¶¨Êý¾ÝÖеÄǰnÁУ¬Ê¾ÀýÈçÏ£º
µÃµ½Ã¿¸ö²¿ÃÅнˮ×î¸ßµÄ ......
windowsÉÏ´æÔÚ32bitµÄÏÞÖÆ£¬ÈçAIX¡¢HP UNIX µÈÓÐÃ÷È·µÄ64BIT OS and ORACLEµÄ°æ±¾£¬32bit oracle¿ÉÒÔ×°ÔÚ64bit os ÉÏ£¬64 bit oracle²»ÄÜ×°ÔÚ32 bit OSÉÏ
oracleÊÇ64bit or 32 bit,32bit ͨ³£ SGAÓÐ 1.7G µÄÏÞÖÆ(ijЩOSµÄ´¦Àí»òÕßWINDOWSÉÏÓÐÌØ¶¨É趨¿ÉÒÔÖ§³Öµ½2GÒÔÉÏÉõÖÁ´ïµ½3.7G
ÈçºÎ²é³öǰ̨ÕýÔÚ·¢³öµÄsqlÓï¾ä:
sele ......
jspÒ³ÃæÊ¹ÓÃstruts2µÄproperty±êÇ©Êä³öÈçÏÂÄÚÈÝ
<s:property value="detailinfo"/> ÆäÖУ¬detailinfo="<strong>abc</strong>"£»
ºÃÏñûÊ£¬ÎÊÌâ³öÏÖÁË£¬ÔÚjspÒ³ÃæÉÏÏÔʾ³öÁË<strong>abc</strong>
Ò»¿´Ò³ÃæÔ´Â룬·¢ÏÖ£¬Ô´´úÂëÖÐÒѾ±ä³ÉÁË
< strong&a ......