<%@ page import="javax.sql.*,javax.naming.*" %><%
  Context env = (Context) new InitialContext().lookup("java:comp/env");
  DataSource PoolConn = (DataSource) env.lookup("szbd");
%>  
调用文件

解决方案 »

  1.   

    <%@ page contentType="text/html;charset=Gb2312" errorPage="../system/Error.jsp"%>
    <%@ page import="java.lang.*,hxy.*,java.util.*"%>
    <%@ page import="java.sql.*,oracle.jdbc.pool.*" %><%@ include file="../includes/Conn.jsp"%>
    <%@ include file="../includes/NoCahe.jsp"%>
    <jsp:useBean id="PubDb" class="hxy.MyDb" /><jsp:useBean id="PubFunc" class="hxy.MyFunc"/>
    <jsp:useBean id="PubHtml" class="hxy.MyHtml"/>
    <jsp:useBean id="PubUser" class="hxy.MyUser" scope="session"/><%
      String NextId="";
      String strSql="";
      int count=0;
      //建立Pool连接及Stmt
      Connection Conn=PoolConn.getConnection();
      Statement Stmt=Conn.createStatement();
    %>
    <%
      String strAccount=PubFunc.Trim(request.getParameter("Account"));
      String strPassword=PubFunc.Trim(request.getParameter("Password"));
      PubUser.setAccount(strAccount);
      PubUser.setPassword(strPassword);
      PubUser.setStmt(Stmt);  if (PubUser.IsValidUser()){
         Cookie cookie=new Cookie("Account",strAccount);
         cookie.setMaxAge(365*24*60*60);
         response.addCookie(cookie);
         NextId=PubFunc.Cstr(PubDb.getFirstValue(Stmt,"Select userlogonid.NextVal From Dual"));
         strSql="Insert into userlogon (id,userid,login_time,addr)values("+NextId+","+PubUser.getUserId()+",sysdate,'"+request.getRemoteAddr()+"')";
         count=PubDb.RunSql(Stmt,strSql);
         response.sendRedirect("../system/main.jsp?id="+NextId);
      }
      else{
           out.println(PubHtml.getGoBackMsg(PubUser.getErrorMsg()));
      }
    %><%
      Stmt.close();
      Conn.close();
    %>
    运行程序