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();}
%>