JSP实现树型组织架构(6)--包含文件connectinDB.jsp & orgConnI
//connectionDB.jsp<%@ page contentType="text/html;charset=Big5"%>
<%@ page import="java.sql.*"%>
<%
Connection conn=null;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@192.168.56.199:1521:asdb";
String user="system";
String password="oracle01";
conn=DriverManager.getConnection(url, user, password);
}
catch(Exception e1)
{e1.printStackTrace();}
%>
//orgConnInclude.jsp
<%@ page import="java.sql.*"%>
<%
Connection conn=null;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@192.168.56.199:1521:asdb";
String user="System";
String password="oracle01";
conn=DriverManager.getConnection(url, user, password);}
catch(Exception se1)
{se1.printStackTrace();}
%>
补充:Jsp教程,Jsp/Servlet开发工具