jspÖÐÈçºÎÖ´ÐÐSQL½Å±¾
ÇëÎÊÈçºÎÔÚJSPÖÐÖ´ÐÐSQL½Å±¾°¡???
²»ÊÇSQLÓï¾äŶ!!!
лл¸÷λ´ó´óÖ¸½Ì
Java code:
Statement st = con.createStatement();
for(String sqlTable : sqlList) {
st.addBatch(sqlTable);
}
st.executeBatch();
½«sql½Å±¾½âÎö³öÀ´
È»ºóÅúÁ¿Ö´ÐÐ
<%
Á¬½Ó¡¢²éѯÊý¾Ý¿âµÄjava´úÂë
%>
лл´ð¸´
ÎұȽϲË,ÕâÑùµÄ»°,ÈçºÎµ¼Èë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
Ïà¹ØÎÊ´ð£º
´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......
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,±¾Ò³Ã滹¿ÉÒÔÈ¡³öÖµÀ´.
µ«ÊÇһˢÐÂ,»òÕß´ò¿ªÐµÄÒ³Ãæ¾ÍÈ¡²»³öÖµÀ´ÁË.
Ææ¹ÖµÄÊÇ,ÎÒ²âÊÔÁíÒ»¸ö³ÌÐòʱºò
ÔÚjspÒ³Ãæ´æÉÏÒ»¸ösession,±¾Ò³Ãæ¿ÉÒÔÈ¡³öÖµÀ´,ˢлò´ò¿ªÐÂÒ³ÃæÖµÄÜÈ¡³öÀ´ÁË.
......
ÎÒÏÖÔÚÏëÓÃsshÕûºÏÀ´×öÒ»¸öÂÛ̳£¬µ«Êý¾Ý¿â·½Ãæ²»ÐУ¬ÎÒÖ÷Òª²»»áÉæ¼°Êý¾Ý¿â£¬²»ÖªµÀ·¢Ìû±í£¬ºÍ»ØÌû±íÒªÈçºÎÉè¼ÆºÍÇø·Ö¡£²»ÖªµÀËÓÐÒ»¸ö¼òµ¥µÄ˼·£¬À´Éè¼ÆÕâЩ±í¡£Ð»Ð»ÁË¡£
·¢ÌûºÍ»ØÌûÓÃͬһÕÅ±í ¡£·¢Ìû id user ......
ÎÒÊÇÓÃSTRUTS £¬×öÁËÒ»¸öJSPÒ³Ãæ£¬Ìá½»ºóûÓдæÈëÊý¾Ý¿â¡£
JSP´úÂëÈçÏ£º
aa.jsp´úÂë
<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@ taglib uri=" ......