¸÷λ´ó´ó¿´Ò»ÏÂÕâ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>ͨ¹ýÎı¾ÎļþÏòÊý¾Ý¿âÖд«µÝÊý¾
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃSTRUTS £¬×öÁËÒ»¸öJSPÒ³Ãæ£¬Ìá½»ºóûÓдæÈëÊý¾Ý¿â¡£
JSP´úÂëÈçÏ£º
aa.jsp´úÂë
<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@ taglib uri=" ......
ÈçÌ⣬ÎÒÊÇÓÃstruts2×öµÄÍøÒ³£¬ÓÃÁËradio±êÇ©£¬Ã¿¸öÑ¡Ïîǰ¶¼ÓÐÒ»¸öСԲȦ£¬ÎÒÐèÒª°ÑСԲȦȥµô£¬µ¥»÷×־ͺ㬱»Ñ¡ÖеÄÑ¡Ïî±³¾°±äÉ«¡£
¾ÍÏñ´ó¶àÊýÍøÕ¾µÄ·ÖÀà¼ìË÷£¬±ÈÈçÕâ¸öÍøÕ¾µÄÄÇÑùµÄ¸ù¾Ý¸÷ÖÖÌõ¼þµÄʵʱËÑË÷£º
ht ......
¸÷λ´óÏÀ¾ÈÃü°¡ £¡£¡
¸Õ×°ÁËSQL2000 sp3
ÏëÓÃJSPÁ¬½ÓÊý¾Ý¿âµ«ÊdzöÏÖÎÊÌâÁË
ÎÒÓõÄÊÇJDK6.0+tomcat5.0+SQL2000 SP3+JDBC sp3
ËüÏÔʾµÄÊÇ
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver fo ......
ÎÒÏëµÇ¼ºó£¬Èç¹ûµÇ¼³É¹¦¾ÍÈ¥Ö´ÐÐij¸öÒ³Ãæ
ÎÒÏÖÔڵĴúÂëÊÇÕâÑùµÄ£º
if(rs.next()){
session.setAttribute( "username" , user);
<jsp:include page="login.jsp" />// ......