基于Java+JSP的 JAVA商场VIP消费查询系统(毕业设计作品)毕业设计实现+源码.zip

package service; import java.sql.ResultSet; import java.sql.SQLException; import javax.servlet.http.HttpSession; import model.TAdmin; import org.directwebremoting.WebContext; import org.directwebremoting.WebContextFactory; import db.DB; public class loginService { public String login(String userName,String userPw,int userType) { String result="no"; if(userType==0)//系统管理员登陆 { String sql="select * from t_admin where userName=? and userPw=?"; Object[] params={userName,userPw}; DB mydb=new DB(); mydb.doPstm(sql, params); try { ResultSet rs=mydb.getRs(); boolean mark=(rs==null||!rs.next()?false:true); if(mark==false) { result="no"; } else { result="yes"; TAdmin admin=new TAdmin(); admin.setUserId(rs.getInt("userId")); admin.setUserName(rs.getString("userName")); admin.setUserPw(rs.getString("userPw")); WebContext ctx = WebContextFactory.get(); HttpSession session=ctx.getSession(); session.setAttribute("userType", 0); session.setAttribute("admin", admin); } rs.close(); } catch (SQLException e) { System.out.println("登录失败！"); e.printStackTrace(); } finally { mydb.closed(); } } if(userType==1) { String sql="select * from t_yonghu where loginName = ? and loginPass = ? and del='no'"; Object[] params={userName,userPw}; DB mydb=new DB(); mydb.doPstm(sql, params); try { ResultSet rs=mydb.getRs(); boolean mark=(rs==null||!rs.next()?false:true); if(mark==false) { result="no"; } else { result="yes"; /*TYonghu yonghu = new TYonghu(); yonghu.setId(rs.getInt("id")); yonghu.setXingming(rs.getString("xingming")); yonghu.setLoginName(rs.getString("loginName")); yonghu.setLoginPass(rs.getString("loginPass")); WebContext ctx = WebContextFactory.get(); HttpSession session=ctx.getSession(); session.setAttribute("userType", 1); session.setAttribute("yonghu", yonghu);*/ } rs.close(); } catch (SQLException e) { System.out.println("登录失败！"); e.printStackTrace(); } finally { mydb.closed(); } } return result; } public String adminPwEdit(String userPwNew) { WebContext ctx = WebContextFactory.get(); HttpSession session=ctx.getSession(); TAdmin admin=(TAdmin)session.getAttribute("admin"); String sql="update t_admin set userPw=? where userId=?"; Object[] params={userPwNew,admin.getUserId()}; DB mydb=new DB(); mydb.doPstm(sql, params); return "yes"; } public String yonghuPwEdit(String userPwNew) {/* WebContext ctx = WebContextFactory.get(); HttpSession session=ctx.getSession(); TYonghu yonghu=(TYonghu)session.getAttribute("yonghu"); String sql="update t_yonghu set loginPass=? where id=?"; Object[] params={userPwNew,yonghu.getId()}; DB mydb=new DB(); mydb.doPstm(sql, params);*/ return "yes"; } public String yonghuCheck(String loginName,String loginPass){ String result = "no"; String sql = "select 1 from t_yonghu where loginName = ? and loginPass = ?"; Object[] params={loginName,loginPass}; DB mydb=new DB(); mydb.doPstm(sql, params); try { ResultSet rs=mydb.getRs(); if(rs.next()) { result="yes"; } rs.close(); } catch (SQLException e) { System.out.println("登录失败！"); e.printStackTrace(); } finally { mydb.closed(); } return result; } }