JSPÁ¬½ÓÊý¾Ý¿âµÄ×ܽá
ÒòΪÊǸú×ÅÊÓƵѧϰµÄ£¬ÓкܶàÓõĶ«Î÷²»Ò»Ñù£¬µ«ÊÇ»¹ÊÇÂýÂýµÄÃþË÷³öÀ´À²£¡
1.Microsoft JDBC Driver µÄÏÂÔØ°²×°
Ö»ÒªÔÚÍøÉÏÕÒµ½×ÊÔ´Ò»²½²½À´¾Í¿ÉÒÔÁË¡£
2.ÅäÖû·¾³±äÁ¿
ÎÒÓõÄÊÇtomcat6.0Ê×ÏÈÅäµÄÊÇ
classpathºÍpath£¬ÕâЩ¶¼ÊÇÔÚÅäjdkµÄʱºò¾ÍÅä¹ýÁË£¬ËùÒԾͲ»Ïêϸ˵Ã÷ÁË£¬Ö»Òª½«libºÍbinÎļþ¼ÓÈëµ½Ïà¹ØµÄ·¾¶Ï¾ͿÉÒÔÁË¡£
ÁíÍâµÄÒ»¸öÎÊÌâ¾ÍÊÇ¿ÉÄÜ»á³öÏÖNeither the JAVA_HOME nor the JRE_HOME environment variable is defined
At least one of these environment variable is needed to run this program
Ò»¸öÕâÑùµÄÎÊÌ⣬ÕâÊÇÒòΪÏÖÔÚµÄjdk°æ±¾²»»á×Ô¶¯µÄ¼ÓÔØÕâÁ½¸ö¶«Î÷ÁË£¬½â¾ö°ì·¨£º
Ö»ÒªÔÚsetclasspathÖÐÈçÏÂÉèÖþͿÉÒÔÁË
rem ---------------------------------------------------------------------------
rem Set CLASSPATH and Java options
rem
rem $Id: setclasspath.bat 505241 2007-02-09 10:22:58Z jfclere $
rem ---------------------------------------------------------------------------
set JAVA_HOME=D:\Java\jdk1.6.0_11
set JRE_HOME=D:\Java\jre6
rem Make sure prerequisite environment variables are set
if not "%JAVA_HOME%" == "" goto gotJdkHome
if not "%JRE_HOME%" == "" goto gotJreHome
echo Neither the JAVA_HOME nor the JRE_HOME environment variable is defined
echo At least one of these environment variable is needed to run this program
goto exit
......
3.µ¼ÈëÏàÓ¦µÄjar°ü£º
ÓÉÓÚÓõÄÊǼ¯³ÉµÄ¿ª·¢»·¾³£¬ËùÒÔÏà¶ÔÀ´Ëµ±È½ÏµÄ¼òµ¥¡£
Ö»ÒªÔÚwebContentϵÄlibÎļþ¼Ðϵ¼ÈëÎÒÃǵÄjdbcµÄjar°ü¾Í¿ÉÒÔÁË¡£
4.Á¬½ÓSQL Server 2005 µÄjsp´úÂ룺
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url="jdbc:sqlserver://10.1.0.10:1433;database=bbs";
String user="sa";
String pwd="123";
Connection conn=DriverManager.getConnection(url,user,pwd);
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from dbo.article");
ÖÁÓÚÄãÒªÏÔʾʲôÄÚÈݾÍ×Ô¼º¿ØÖÆÁË£¬ÓÉÓÚÎÒÊÇÏÈÁ¬µÃÊý¾Ý¿â£¬Ã»ÓаѱíÃû·Å½øÈ¥£¬ºóÃæÁ¬½Ó¾ßÌåµÄ±íʱ£¬ÅªÁ˺þ᣺ÜÓôÃƵľÍÊÇ£¬Ã¿´ÎÎÊÌⶼ³öÔÚÕâЩÎÊÌâÉÏ£¬Ò»²»Ð¡ÐľÍÍü¼ÇÁËÈ¥Ìí¼ÓһЩ¶«Î÷£¡£¡£¡
¸öÈ˵ľÑé×ܽ᣺¸Õ¿ªÊ¼Ñ§ÕâЩ¶«Î÷£¬ÒòΪûÓÐÕû¸öµ
Ïà¹ØÎĵµ£º
<script language="javascript">
var times=6;
clock();
function clock()
{
window.setTimeout('clock()',1000);
times=times-1;
time.innerHTML =times;
}
</script>
<head>
<meta http-equiv= "Refresh" content= "5;url=index.jsp "& ......
Á½ÄêÇ°£¬ÔøÓÐһλǰ±²¶ÔÎÒ˵¹ý£º¿ª·¢Ò»¸öÊôÓÚÄã×Ô¼ºµÄÍøÕ¾£¬È»ºóÿÌ컨һµã¿ÕÏеÄʱ¼äÈ¥¾ÓªÒ»Ï£¬ÖÕÓÐÒ»Ì죬Äã»á·¢¾õËüÊǷdz£ÓÐÓõġ£¸Õ¿ªÊ¼µÄʱºò£¬ÎÒûÓаÑÕâЩ»°·ÅÔÚÐÄÉÏ£¬ÂýÂýµØ£¬ÎҲŷ¢¾õÕâλǰ±²ËµµÄ»°ÊǺÜÓеÀÀíµÄ¡£¼ÙÉèÁ½ÄêÇ°¿ªÊ¼¾ÓªÒ»¸öÍøÕ¾£¬Í¨¹ýÕâÁ½ÄêµÄÍƹãºÍÔËÓª£¬Ëµ²»¶¨µ½Ï ......
ÔÚJspºÍjspÖеÄjavabeanÀïÃ棬"/"Ö¸µÄÊÇtomcatËùÔڵĸù·¾¶£¬Èç¹ûÊÇÔÚWindowsϾÍÊÇtomcatËùÔÚÅ̵ÄÅÌ·û£»¶ø“.”Ö¸µÄÊÇtomcatµÄbinĿ¼ËùÔڵķ¾¶¡£
ÎÒ²ÂÏëÕâÊÇÒòΪjsp´úÂ붼»á±»tomcatתΪServlet£¬¶øServletÊÇÔÚtomcatÖзÃÎʵģ¬ËùÒÔjvmÔÚÔËÐÐServletʱ¾ÍÈÏΪĿ¼ÊÇtomcatËùÔÚµÄĿ¼¡£
HtmlÖеē/&r ......
<%@ page contentType="text/html; charset=gbk" language="java" import="java.io.*" buffer="64kb" %>
<%
String path_in = "";
String content = "";
path_in = request.getRealPath("/")+"admin"+File.separator+ ......
1¡¢Óû§µÇ¼½çÃælog.jsp
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content ......