JSP实现树型组织架构(6)--包含文件connectinDB.jsp & orgConnInclude.jsp

来源: 作者: 2007-11-21 出处:pcdog.com

java  oracle  

//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实现浏览器关闭cookies情况下的会话管理
下一篇:JSP数据库操作例程数据分页显示