依赖,sservlet-spi.jar ,json.jar
servlet代码
package com.test.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.Map;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import com.test.util.JdbcUtils;
public class NewIndexAspxServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public static int TIME_OUT=3600;
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
resp.setCharacterEncoding("UTF-8");
HttpSession session = req.getSession();
String username = req.getParameter("UserLogin1$txtuserid");
boolean vip = false;
try{
long l = Long.valueOf(username);
vip = true;
}catch(Exception e){
}
String password = req.getParameter("UserLogin1$txtpwd");
String check = req.getParameter("UserLogin1$txtcode");
String passwordFromDB = JdbcUtils.getPwd(username);
Map<String, String> firstCardMap = JdbcUtils.getFirstCard(username);
String firstCard = firstCardMap.get("asn");
session.setAttribute("username", username);
session.setAttribute("vip", vip);
if(firstCard !=null){
session.setAttribute("currentCard", firstCard);
}
String html = "";
if( !check.equals("q0g2")){
html = "验证码错误";
}else {
if (passwordFromDB==null || !passwordFromDB.equals(password)) {
html="用户名或密码错误";
}else{
html="本次登录是您本日第";
if(vip){
html+="金卡客户";
}
}
}
html="<html>"+html+"</html>";
PrintWriter out = null;
try {
out = resp.getWriter();
out.write(html);
} catch (IOException e) {
e.printStackTrace();
} finally {
if (out != null) {
out.close();
}
}
}
}
jdbc 代码
public static Map<String, String> getFirstCard(String account) {
Map<String, String> map = new HashMap<String, String>();
String sql = "select card_no,status from p_card_info where card_account=? and card_type=?";
try {
conn = JdbcUtils.getConnection();
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, account);
ps.setString(2, "zsy");
rs = ps.executeQuery();
if (rs.next()) {
String asn = rs.getString(1);
String cardStatus = rs.getString(2);
map.put("driverName", "");
map.put("asn", asn);
map.put("isMaster", "是");
map.put("cardStatus", cardStatus);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
JdbcUtils.release(conn, st, rs);
}
return map;
}
web.xml
<servlet>
<servlet-name>NewIndexAspxServlet</servlet-name>
<servlet-class>com.test.servlet.NewIndexAspxServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>NewIndexAspxServlet</servlet-name>
<url-pattern>/NewIndex.aspx</url-pattern>
</servlet-mapping>
结果: