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

¸÷λ´ó´ó¿´Ò»ÏÂÕâJSP´íÔÚÄÇÀï,лл

<%!
String driver="oracle.jdbc.driver.OracleDriver";
String url="jdbc:oracle:thin:@172.30.60.87:1521:ORCL";
String user = "system";
String password = "cim";

Connection conn;
%>

<%
if(request.getParameter("Submit")!=null){
File file=new File(getServletContext().getRealPath("mo.txt"));
FileReader reader=new FileReader(file);
char[] cbuf=new char[(int)file.length()];
reader.read(cbuf);
reader.close();
Class.forName(driver);
conn=DriverManager.getConnection(url,user,password);
Statement st=conn.createStatement();
String[] table=new String(cbuf).split("\n");
String[][] row=new String[table.length][];
int num=0;
for(int i=0;i <table.length;i++){
row[i]=table[i].split(" ");
st.executeUpdate("insert into all_mocsv (MO,CODE,CT,RT) values ('"+row[i][0]+"','"+row[i][1]+"','"+row[i][2]+"','"+row[i][3]+"')");
 

}
st.close();
conn.close();
if(num>0)
out.print(" <script language=javascript>alert('µ¼Èë³É¹¦') </script>");
}
%>

<html>
  <head>
    <title>ͨ¹ýÎı¾ÎļþÏòÊý¾Ý¿âÖд«µÝÊý¾


Ïà¹ØÎÊ´ð£º

JSP³öEXCEl±¨±íÖÐÎÄÃû³ÆÂÒÂë

ÎÒÔÚʹÓÿªÔ´µÄJXL ³öEXCEL±¨±íʱÓöµ½ÕâÑùµÄÎÊÌâ¡£
ÎÒÏë³öµÄÎļþÃû³ÆÊÇÕâÑùµÄ£ºÀý£ºtest_ÀîÇ¿.xls
´úÂëÊÇ ....test_+"UserID"+".xls";
µ«ÊÇ¿ØÖÆÌ¨ÎÒ¿´µ½µÄÊä³öÃû³ÆÐ§¹ûÊÇ£ºtest_µ ......

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

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

jsp ¼òµ¥µÄsessionÎÊÌâ¡£

±¾ÈË×öÁËÒ»¸öÄ£Ä⹺ÎïÍøÕ¾£¬Óöµ½Ò»Ð©ÎÊÌâ¡£
µÚÒ»¸öÓû§Ñ¡ÔñÁËA¡¢B¡¢CÉÌÆ·
È»ºóµÚ¶þ¸öÓû§Ö»Ñ¡ÔñDÉÌÆ·¡£
µã»÷²é¿´µÄʱºò£¬¹ºÎï³µÁгöA¡¢B¡¢C¡¢DËÄÖÖÉÌÆ·£¬ÇëÎÊÄÄÀï³öÁËÎÊÌ⣿
Java code:

<%@ page content ......

¹ØÓÚjspµÄһЩСÎÊÌâ - Web ¿ª·¢ / JavaScript

ÎÒÏëÓÃjavabeanʵÏÖ¼ÆÊý
´úÂëÈçÏ£º
ComputerCount.java
package tom.jiafei;
import java.io.*;
public class ComputerCount{
  int number=0;
  boolean iscome=false;
  File file=new ......

jspÍøÕ¾ÈçºÎ·¢²¼µ½ÍøÉÏ

ÎÒ¸Õ×öºÃÒ»¸öjspµÄ¹ºÎïÉ̳ǣ¬¿ÉÎÒ²»»áÔõô·¢²¼µ½ÍøÉÏ£¡ÓÐË­Äܰï°ïÎÒ
¿ÉÒÔ×Ô¼º×âÓÃһ̨·þÎñÆ÷ÅäÖ㬹ØÓÚÉÏ´«µÄ»°£¬¾ÍÊÇÓÃÉÏ´«Èí¼þ£¬°ÑÄãµÄ³ÌÐò´«µ½·þÎñÆ÷ÉÏ¡£


mark

´ò¸öwar°ü·ÅÉÏÈ¥¾ÍÐÐÁË

Õ¦ÌýÄãÃÇ˵µÄÕâ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ