jsp笔记

索引:
安装设置:
    1.安装Jdk,Tomcat
    2.设置环境变量:  (变量名不区分大小写)
         JAVA_HOME:     D:/Program Files/Java/jdk1.7.0
         TOMCAT_HOME:     D:/Program Files/Apache Software Foundation/Tomcat 6.0
         classpath:     .;%JAVA_HOME%/lib/dt.jar;%JAVA_HOME%/lib/tools.jar;
                               %TOMCAT_HOME%/common/lib/servlet-api.jar;
                               %TOMCAT_HOME%/common/lib/jsp-api.jar 
         path:              .;%SystemRoot%/system32;%SystemRoot%;%SystemRoot%/System32/Wbem;
                               C:/Program Files/Microsoft SQL Server/80/Tools/BINN;%JAVA_HOME%/bin;
    3.设置server.xml (位于%TOMCAT_HOME%/conf下,设置这一项后要重起Tomcat)
         在</Host>前加上:<Context path="" docBase="D:/Tjsp" reloadable="true"></Context>
           (其中,path表示虚拟目录,docBase为物理目录)
    4.设置Dreamweaver 
         管理站点: 测试服务器(JSP,本地/网络,http://localhost:8080/ (加上端口号,虚拟目录))
    5.类目录  
       在你的docBase所在目录下建立WEB-INF/classes,yourclass.class就放在
       这个目录的youpackage下, 如未设置reloadable属性,就重起Tomcat
    6.JavaBean  
         编辑*.java WEB-INF/classes目录下建立yourclass.java
         生成*.class dos下d:,cd (你的docBase目录)/WEB-INF/classes,
           javac -d . yourclass.java, java yourpackage/yourclass.class
         使用JavaBean <%@ page language="java" import="tao5.*" %> 
           <jsp:useBean id="bean4" scope="session" class="tao5.thinsd"/>
           <jsp:useBean id="bean5" scope="session" class="tao5.sb"/>
           <%out.println("the counter is : "+bean4.sout(2)+"<br/>");
           out.println("the counter is : "+bean5.sout(6)+"<br/>"); %> 
 注意:
     1.改变目录要重起Tomcat,无论是主目录,还是类目录
         最好的是在server.xml中加入<Context path="" docBase="D:/Tjsp" reloadable="true"></Context>
        ,这样就不用重起了
     2.jsp:useBean id="bean3",id记得不要重复 
    7.Oracle驱动JDBC,安装方法
      1.将E:/oracle/ora92/jdbc/lib下classes12.jar文件复制到你的站点主目录下/WEB-INF/lib中（如无则新建）
      2.重启Tomcat.
      3.测试连接

         Connection con=null;java.sql.Statement stmt=null;ResultSet rs=null;//定义
         Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();//载入驱动程序类别
         con=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:tour","tour","tour");//建立连接
         stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
         ResultSet.CONCUR_READ_ONLY);//127.0.0.1如远程则改为IP,第一个tour是sid,第二个是用户名，再是密码
    8.使用ODBC,（好处:不需jdbc驱动）
        1.系统dsn(这里是yun)
        2.测试连接
        <%
         Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
         Connection con=DriverManager.getConnection("jdbc:odbc:yun","hanson","317");
         java.sql.Statement stmt=con.createStatement();
         String sql="select * from info2";
         ResultSet rs=stmt.executeQuery(sql);
         while(rs.next()) {%>
         <%=rs.getString(1)%>
         <%System.out.print("  ");%>
         <%=rs.getString(2)%><br>
         <%}
         con.close();
        %>