Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

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Á´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

¾ÈÃü°¡£¡£¡JSPÁ¬½ÓSQL2000ÎÊÌ⣡

¸÷λ´óÏÀ¾ÈÃü°¡ £¡£¡
¸Õ×°ÁËSQL2000 sp3
ÏëÓÃJSPÁ¬½ÓÊý¾Ý¿âµ«ÊdzöÏÖÎÊÌâÁË
ÎÒÓõÄÊÇJDK6.0+tomcat5.0+SQL2000 SP3+JDBC sp3
ËüÏÔʾµÄÊÇ
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver fo ......

jspÏà¹ØÎÊÌâ - Web ¿ª·¢ / JavaScript

ÎÒÏëµÇ¼ºó£¬Èç¹ûµÇ¼³É¹¦¾ÍÈ¥Ö´ÐÐij¸öÒ³Ãæ
ÎÒÏÖÔڵĴúÂëÊÇÕâÑùµÄ£º
if(rs.next()){
 session.setAttribute( "username" , user);
  <jsp:include page="login.jsp" />// ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ