¸÷λ´ó´ó¿´Ò»ÏÂÕâ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>ͨ¹ýÎı¾ÎļþÏòÊý¾Ý¿âÖд«µÝÊý¾
Ïà¹ØÎÊ´ð£º
ÎÒÔÚʹÓÿªÔ´µÄJXL ³öEXCEL±¨±íʱÓöµ½ÕâÑùµÄÎÊÌâ¡£
ÎÒÏë³öµÄÎļþÃû³ÆÊÇÕâÑùµÄ£ºÀý£ºtest_ÀîÇ¿.xls
´úÂëÊÇ ....test_+"UserID"+".xls";
µ«ÊÇ¿ØÖÆÌ¨ÎÒ¿´µ½µÄÊä³öÃû³ÆÐ§¹ûÊÇ£ºtest_µ ......
¸÷λ´óÏÀ¾ÈÃü°¡ £¡£¡
¸Õ×°ÁËSQL2000 sp3
ÏëÓÃJSPÁ¬½ÓÊý¾Ý¿âµ«ÊdzöÏÖÎÊÌâÁË
ÎÒÓõÄÊÇJDK6.0+tomcat5.0+SQL2000 SP3+JDBC sp3
ËüÏÔʾµÄÊÇ
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver fo ......
±¾ÈË×öÁËÒ»¸öÄ£Ä⹺ÎïÍøÕ¾£¬Óöµ½Ò»Ð©ÎÊÌâ¡£
µÚÒ»¸öÓû§Ñ¡ÔñÁËA¡¢B¡¢CÉÌÆ·
È»ºóµÚ¶þ¸öÓû§Ö»Ñ¡ÔñDÉÌÆ·¡£
µã»÷²é¿´µÄʱºò£¬¹ºÎï³µÁгöA¡¢B¡¢C¡¢DËÄÖÖÉÌÆ·£¬ÇëÎÊÄÄÀï³öÁËÎÊÌ⣿
Java code:
<%@ page content ......
ÎÒÏëÓÃjavabeanʵÏÖ¼ÆÊý
´úÂëÈçÏ£º
ComputerCount.java
package tom.jiafei;
import java.io.*;
public class ComputerCount{
int number=0;
boolean iscome=false;
File file=new ......
ÎÒ¸Õ×öºÃÒ»¸öjspµÄ¹ºÎïÉ̳ǣ¬¿ÉÎÒ²»»áÔõô·¢²¼µ½ÍøÉÏ£¡ÓÐËÄܰï°ïÎÒ
¿ÉÒÔ×Ô¼º×âÓÃһ̨·þÎñÆ÷ÅäÖ㬹ØÓÚÉÏ´«µÄ»°£¬¾ÍÊÇÓÃÉÏ´«Èí¼þ£¬°ÑÄãµÄ³ÌÐò´«µ½·þÎñÆ÷ÉÏ¡£
mark
´ò¸öwar°ü·ÅÉÏÈ¥¾ÍÐÐÁË
Õ¦ÌýÄãÃÇ˵µÄÕâ ......