jsp 教程(jsp 树形菜单目录－本站代码)

以下是代码片段：
＜%@ page contentType="text/html; charset=gb2312" language="java"%＞
＜%@ page import = "java.sql.*"%＞
＜html＞
＜head＞
＜title＞#.Admin＜/title＞
＜meta http-equiv="Content-Type" content="text/html; charset=gb2312"＞
＜link rel="StyleSheet" href="css/dtree.css" type="text/css"＞
＜script type="text/javascript" src="js/dtree.js"＞＜/script＞
＜script type="text/javascript" src="js/op.js"＞＜/script＞
＜/head＞

＜body bgcolor="ffffff" text="#000000" ＞

．．．

＜%!
 //这里建议您在 bean 里面操作
 public ResultSet executeQuery(Connection conn,String sql) throws SQLException {
  ResultSet rs = null;
  Statement stmt = null;
  try {
   stmt = conn.createStatement();
   rs = stmt.executeQuery(sql);
  } catch (SQLException ex) {
   System.out.println("查询异常：" + ex.getMessage());
  }
  return rs;
 }
 //这里建议您在 bean 里面操作
 public synchronized Connection getConnection() throws Exception {
  String driverName="org.gjt.mm.mysql.Driver";
  String url="jdbc:mysql://localhost:3306/demo?useUnicode=true&characterEncoding=gb2312";
  Driver driver = (Driver) Class.forName(driverName).newInstance();
  Connection conn = DriverManager.getConnection(url, "root","888888");
  return conn;
 } 
%＞