public void valueBound(HttpSessionBindingEvent e) {
users.trimToSize();
HttpSession session = e.getSession();
session.getAttribute("teleno");
if(!existUser(e.getName())){
users.add(e.getName());
try
{
java.util.Date dt = new java.util.Date();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String logintime=sdf.format(dt);
String url = "jdbc:bea:sqlserver://localhost:1433;DatabaseName=Community";
Class.forName("weblogic.jdbc.sqlserver.SQLServerDriver");
Connection con = DriverManager.getConnection(url,"sa","jfy");
PreparedStatement stmt = con.prepareStatement("insert into UserLoginInfo(Telephone,LoginTime,SessionID,UserIP) values('"+e.getName()+"','"+logintime+"','"+session.getId()+"','"+session.getAttribute("ip")+"')");
stmt.executeUpdate();
stmt.close();
con.close();
}catch(java.lang.Exception ex){
ex.printStackTrace();
}
System.out.print(session.getAttribute("ip")+"\t µÇÈ뵽ϵͳ\t"+(new Date()));
System.out.println(" ÔÚÏßÓû§ÊýΪ£º"+getCount());
}else
System.out.println(e.getName()+"ÒѾ­´æÔÚ");
}
users.trimToSize();
HttpSession session = e.getSession();
session.getAttribute("teleno");
if(!existUser(e.getName())){
users.add(e.getName());
try
{
java.util.Date dt = new java.util.Date();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String logintime=sdf.format(dt);
String url = "jdbc:bea:sqlserver://localhost:1433;DatabaseName=Community";
Class.forName("weblogic.jdbc.sqlserver.SQLServerDriver");
Connection con = DriverManager.getConnection(url,"sa","jfy");
PreparedStatement stmt = con.prepareStatement("insert into UserLoginInfo(Telephone,LoginTime,SessionID,UserIP) values('"+e.getName()+"','"+logintime+"','"+session.getId()+"','"+session.getAttribute("ip")+"')");
stmt.executeUpdate();
stmt.close();
con.close();
}catch(java.lang.Exception ex){
ex.printStackTrace();
}
System.out.print(session.getAttribute("ip")+"\t µÇÈ뵽ϵͳ\t"+(new Date()));
System.out.println(" ÔÚÏßÓû§ÊýΪ£º"+getCount());
}else
System.out.println(e.getName()+"ÒѾ­´æÔÚ");
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货