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");
ÖÁÓÚÄãÒªÏÔʾʲôÄÚÈݾÍ×Ô¼º¿ØÖÆÁË£¬ÓÉÓÚÎÒÊÇÏÈÁ¬µÃÊý¾Ý¿â£¬Ã»ÓаѱíÃû·Å½øÈ¥£¬ºóÃæÁ¬½Ó¾ßÌåµÄ±íʱ£¬ÅªÁ˺þ᣺ÜÓôÃƵľÍÊÇ£¬Ã¿´ÎÎÊÌⶼ³öÔÚÕâЩÎÊÌâÉÏ£¬Ò»²»Ð¡ÐľÍÍü¼ÇÁËÈ¥Ìí¼ÓһЩ¶«Î÷£¡£¡£¡
¸öÈ˵ľÑé×ܽ᣺¸Õ¿ªÊ¼Ñ§ÕâЩ¶«Î÷£¬ÒòΪûÓÐÕû¸öµ
Ïà¹ØÎĵµ£º
ÄãµÄ¿ì½Ý½¨ÉèÖÃÓÐÎÊÌ⣬ÄãÖØÐÂÉèÖÃÒ»ÏÂÔÚ window --> Perferences--> General--> keys
½«Content Assist¿ì½Ý¼üÉèÖóÉAlt + /¾Í¿ÉÒÔÁË
Èç¹ûÄã·¢ÏÖµãÁËApply¹ØÁËÖ®ºó£¬Ôٴδò¿ªContent AssistµÄ¿ì½Ý¼üûÓиıäµÄ»°£¬ÄÇÊÇÒòΪÏÂÃæÓÐÒ»¸öÑ¡ÏîÒѾÓõ½ÁËAlt + /£¬¾ßÌåÊÇÄÄÒ»¸öÎҼDz»ÇåÁË£¬Äã°ÑÄǸöcommandµÄ¿ì½Ý¼ü¸ ......
ÔÚJspºÍjspÖеÄjavabeanÀïÃ棬"/"Ö¸µÄÊÇtomcatËùÔڵĸù·¾¶£¬Èç¹ûÊÇÔÚWindowsϾÍÊÇtomcatËùÔÚÅ̵ÄÅÌ·û£»¶ø“.”Ö¸µÄÊÇtomcatµÄbinĿ¼ËùÔڵķ¾¶¡£
ÎÒ²ÂÏëÕâÊÇÒòΪjsp´úÂ붼»á±»tomcatתΪServlet£¬¶øServletÊÇÔÚtomcatÖзÃÎʵģ¬ËùÒÔjvmÔÚÔËÐÐServletʱ¾ÍÈÏΪĿ¼ÊÇtomcatËùÔÚµÄĿ¼¡£
HtmlÖеē/&r ......
Õâ¸öÎÊÌâÊÇ´ÓÏîÄ¿ÖÐÉè¼ÆÊý¾Ý¿âºÍ²Ù×÷Êý¾Ý¿âµÄÈ˲»Í¬¶øÔì³ÉµÄ¡£ËùÓõÄÊý¾Ý¿â
ÊÇsybase£¬Éè¼Æʱ°ÑÊý¾ÝÀàÐÍÉè¼ÆΪnvarcharÁË£¬Èç¹ûÊÇÖÐÎÄ£¬¶ÁÈ¡³öÀ´¾Í»áµÃ
µ½ÂÒÂë¡£ÎÒÊÔÁ˺ö෽·¨»¹ÊDz»ÐУ¬×îºóÎÞÄΣ¬Ö»ºÃ½«Êý¾ÝÀàÐ͸ÄΪvarcharÁË¡£
ËùÒÔÔÚ´Ë×ܽáÒ»ÏÂÖÐÎÄÂÒÂëÎÊÌâ¡£
Ò»¡¢JSPÓëÒ³Ãæ²ÎÊýÖ®¼äµÄÂÒÂë
&nb ......
Ò»¡¢JSPÒ³ÃæÏÔʾÂÒÂë
¶þ¡¢±íµ¥Ìá½»ÖÐÎÄʱ³öÏÖÂÒÂë
Èý¡¢Êý¾Ý¿âÁ¬½Ó
´ó¼ÒÔÚJSPµÄ¿ª·¢¹ý³ÌÖУ¬¾³£³öÏÖÖÐÎÄÂÒÂëµÄÎÊÌ⣬¿ÉÄÜÒ»ÖÁÀ§ÈÅ×ÅÄú£¬ÎÒÏÖÔÚ°ÑÎÒÔÚJSP¿ª·¢ÖÐÓöµ½
µÄÖÐÎÄÂÒÂëµÄÎÊÌâ¼°½â¾ö°ì·¨Ð´³öÀ´¹©´ó¼Ò²Î¿¼¡£
Ò»¡¢JSPÒ³ÃæÏÔʾÂÒÂë
ÏÂÃæµÄÏÔʾҳÃæ(display.jsp)¾Í³öÏÖÂÒÂ룺
<html>
<head>
<tit ......