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
Ïà¹ØÎÊ´ð£º
ÈçÌ⣬ÎÒÊÇÓÃstruts2×öµÄÍøÒ³£¬ÓÃÁËradio±êÇ©£¬Ã¿¸öÑ¡Ïîǰ¶¼ÓÐÒ»¸öСԲȦ£¬ÎÒÐèÒª°ÑСԲȦȥµô£¬µ¥»÷×־ͺ㬱»Ñ¡ÖеÄÑ¡Ïî±³¾°±äÉ«¡£
¾ÍÏñ´ó¶àÊýÍøÕ¾µÄ·ÖÀà¼ìË÷£¬±ÈÈçÕâ¸öÍøÕ¾µÄÄÇÑùµÄ¸ù¾Ý¸÷ÖÖÌõ¼þµÄʵʱËÑË÷£º
ht ......
ÎÒµãºóÍËʱÊǿհ×Ò³Ãæ
ÐèˢвÅÄÜÏÔʾ
Õâ¸öÔõô´¦Àí°¡
Çë´ó¼Ò°ï°ïæ
°ÑÎÊÌâ˵µÄÏêϸһЩ£¬ÕâÑùÓÐÖúÓÚÎÊÌâµÄ»Ø¸´£¬¼°´ð°¸µÄ׼ȷÐÔ£¡
ÎÒ¾õµÃÊÇÄãµÄä¯ÀÀÆ÷Æ÷µÄÎÊÌâ°É£¬ÎÒÒÔǰÓöµ½¹ýÕâÑùµÄÎÊÌ⣬°ÑIEµÄËùÓÐÊôÐÔÖ ......
//Óÿͻ§µÄsessionµÄid½¨Á¢Ò»¸öÁÙʱÎļþ£º
//String tempFileName=(String)session.getId();
String tempFileName = (String)session.getId();
//out.println(& ......
¸÷λ´óÏÀ¾ÈÃü°¡ £¡£¡
¸Õ×°ÁËSQL2000 sp3
ÏëÓÃJSPÁ¬½ÓÊý¾Ý¿âµ«ÊdzöÏÖÎÊÌâÁË
ÎÒÓõÄÊÇJDK6.0+tomcat5.0+SQL2000 SP3+JDBC sp3
ËüÏÔʾµÄÊÇ
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver fo ......
<%@page language="java" contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="wang.connectDB"/>
< ......