JSP實現樹型組織架構(6)--包含檔案connectinDB.jsp & orgConnInclude.jsp

include|js|架構
//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();}%>