<%@ page import="javax.sql.*,javax.naming.*" %><%
Context env = (Context) new InitialContext().lookup("java:comp/env");
DataSource PoolConn = (DataSource) env.lookup("szbd");
%>
调用文件
Context env = (Context) new InitialContext().lookup("java:comp/env");
DataSource PoolConn = (DataSource) env.lookup("szbd");
%>
调用文件
<%@ 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();
%>
运行程序