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

jspÖÐÈçºÎÖ´ÐÐSQL½Å±¾

ÇëÎÊÈçºÎÔÚJSPÖÐÖ´ÐÐSQL½Å±¾°¡???
²»ÊÇSQLÓï¾äŶ!!!
лл¸÷λ´ó´óÖ¸½Ì
Java code:

Statement st = con.createStatement();
for(String sqlTable : sqlList) {
st.addBatch(sqlTable);
}
st.executeBatch();


½«sql½Å±¾½âÎö³öÀ´
È»ºóÅúÁ¿Ö´ÐÐ

<%
Á¬½Ó¡¢²éѯÊý¾Ý¿âµÄjava´úÂë

%>

ÒýÓÃ
Java code
Statement st= con.createStatement();for(String sqlTable : sqlList) {
                st.addBatch(sqlTable);
            }
            st.executeBatch();
½«sql½Å±¾½âÎö³öÀ´
È»ºóÅúÁ¿Ö´ÐÐ


лл´ð¸´
ÎұȽϲË,ÕâÑùµÄ»°,ÈçºÎµ¼ÈëSQL½Å±¾ÄØ???

<%@ page contentType="text/html; charset=GBK" import="java.sql.*"%>
<%
String url="jdbc:oracle:thin:@127.0.0.1:1521:mydb";//ORACLEÊý¾Ý¿â
  String dbdriver="oracle.jdbc.driver.OracleDriver";
  String user="xxx";
  String pwd="xxx";
  Statement stmt=null;
  ResultSet rs=null;
  Connection conn=null;
try{
      Class.forName(dbd


Ïà¹ØÎÊ´ð£º

SQLÓï¾äЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / ÆäËûÊý¾Ý¿â

´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
  ±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

jspÒ³Ãæ»ñÈ¡sessionµÄÎÊÌâ - Java / Java EE

ÎÒÔÚjspÒ³Ãæ´æÉÏÒ»¸ösession,±¾Ò³Ã滹¿ÉÒÔÈ¡³öÖµÀ´.
µ«ÊÇһˢÐÂ,»òÕß´ò¿ªÐµÄÒ³Ãæ¾ÍÈ¡²»³öÖµÀ´ÁË.
Ææ¹ÖµÄÊÇ,ÎÒ²âÊÔÁíÒ»¸ö³ÌÐòʱºò
ÔÚjspÒ³Ãæ´æÉÏÒ»¸ösession,±¾Ò³Ãæ¿ÉÒÔÈ¡³öÖµÀ´,ˢлò´ò¿ªÐÂÒ³ÃæÖµÄÜÈ¡³öÀ´ÁË.
......

¹ØÓÚjspÂÛ̳ - Java / Web ¿ª·¢

ÎÒÏÖÔÚÏëÓÃsshÕûºÏÀ´×öÒ»¸öÂÛ̳£¬µ«Êý¾Ý¿â·½Ãæ²»ÐУ¬ÎÒÖ÷Òª²»»áÉæ¼°Êý¾Ý¿â£¬²»ÖªµÀ·¢Ìû±í£¬ºÍ»ØÌû±íÒªÈçºÎÉè¼ÆºÍÇø·Ö¡£²»ÖªµÀË­ÓÐÒ»¸ö¼òµ¥µÄ˼·£¬À´Éè¼ÆÕâЩ±í¡£Ð»Ð»ÁË¡£
·¢ÌûºÍ»ØÌûÓÃͬһÕÅ±í ¡£·¢Ìû id user ......

JSP´æÈëÊý¾Ý¿â

ÎÒÊÇÓÃSTRUTS £¬×öÁËÒ»¸öJSPÒ³Ãæ£¬Ìá½»ºóûÓдæÈëÊý¾Ý¿â¡£
JSP´úÂëÈçÏ£º
aa.jsp´úÂë
<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@ taglib uri=" ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ