%@page contentType="text/html;charset=utf-8" import="java.sql.*,java.util.*,jerehnet.jsp.database.*,jerehnet.jsp.util.*,java.text.SimpleDateFormat"%> <% String no=(String)session.getAttribute("userInfoid"); PoolManager pool = new PoolManager(); if (pool == null) { pool = new PoolManager(); } Connection conn = null; DataManager db = new DataManager(); try { conn = pool.getConnection(); String query="select * from jrcms_members where website_no='20150619082201914' and id='"+no+"'"; ResultSet rs = db.executeQuery(conn,query); String username="";String lasttime="";String usern="";String gender="";String telephone=""; String email="";String address="";String postcode="";String company="";String remark=""; String id="";String headimg=""; if(rs!=null&&rs.next()){ id=Common.getFormatStr(rs.getString("id")); username=Common.getFormatStr(rs.getString("name")); lasttime=Common.getFormatDate("yyyy-MM-dd HH:mm:ss",rs.getDate("last_login_date")); usern=Common.getFormatStr(rs.getString("usern")); gender=Common.getFormatStr(rs.getString("gender")); telephone=Common.getFormatStr(rs.getString("telephone")); email=Common.getFormatStr(rs.getString("email")); address=Common.getFormatStr(rs.getString("address")); postcode=Common.getFormatStr(rs.getString("postcode")); company=Common.getFormatStr(rs.getString("company")); remark=Common.getFormatStr(rs.getString("remark")); headimg=Common.getFormatStr(rs.getString("headimg")); } if(headimg.equals("")){ headimg="/resources/web/images/userhead.png"; } %>