0033Java程序设计-基于java的NBA球队运营管理系统的的设计与实现论文2

public String login(String userName,String userPw,int userType) throws Exception
   {
​       System.out.println("userType"+userType);
​       try
​       {
​           Thread.sleep(700);
​       } catch (InterruptedException e)
​       {
​           // TODO Auto-generated catch block
​           e.printStackTrace();
​       }
​       String result="no";
​     if(userType==0){
​        TAdmin admin = new TAdmin();
​           admin.setUserName(userName);
​           admin.setUserPw(userPw);
​           List adminList=tAdminService.queryTAdminList(admin);
​           if(adminList.size()==0)
​           {
​                result="no";
​           }
​           else
​           {
​                WebContext ctx = WebContextFactory.get(); 
​                HttpSession session=ctx.getSession(); 
​                TAdmin adminUser=(TAdmin)adminList.get(0);
​                session.setAttribute("userType", "0");
​          session.setAttribute("admin", adminUser);
​          result="yes";
​           }
​     }
​     if(userType==1){
​        Userinfo userinfo = new Userinfo();
​        userinfo.setUname(userName);
​        userinfo.setPwd(userPw);
​           List userList=userinfoService.queryUserinfoList(userinfo);
​           if(userList.size()==0)
​           {
​                result="no";
​           }
​           else
​           {
​                WebContext ctx = WebContextFactory.get(); 
​                HttpSession session=ctx.getSession(); 
​                Userinfo uinfo=(Userinfo)userList.get(0);
​                session.setAttribute("userType", 1);
​          session.setAttribute("user", uinfo);
​          result="yes";
​           }
​     }
​       return result;
   }

@RequestMapping(value="/qiuyuanList")
   public String qiuyuanList(HttpServletRequest request) throws Exception
   {
​       Qiuyuan qiuyuan = new Qiuyuan();
​       List<Qiuyuan> qiuyuanList=qiuyuanService.queryQiuyuanList(qiuyuan);
​       if(qiuyuanList!=null && qiuyuanList.size()>0){
​           for (Qiuyuan qiuyuan2 : qiuyuanList) {
​               qiuyuan2.setQiudui(qiuduiService.queryQiuduiById(qiuyuan2.getQd()));
​           }
​       }
​       request.setAttribute("qiuyuanList", qiuyuanList);
​       return "/admin/qiuyuan/qiuyuan_list.jsp";
}

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DbUtil {
  private String dbUrl="jdbc:mysql://127.0.0.1:3306/database?serverTimezone=UTC&useSSL=false"; // 数据库连接地址
  private String dbUserName="root"; // 用户名
  private String dbPassword="123456"; // 密码
  private String jdbcName="com.mysql.cj.jdbc.Driver"; // 驱动名称
  /**
   * 获取数据库连接
   * @return
   * @throws Exception
   */
  public Connection getCon(){
    try {
      Class.forName(jdbcName);
    } catch (ClassNotFoundException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }
    Connection con = null;
    try {
      con = DriverManager.getConnection(dbUrl, dbUserName, dbPassword);
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }
    return con;
  }
  /**
   * 关闭数据库连接
   * @param con
   * @throws Exception
   */
  public void closeCon(Connection con)throws Exception{
    if(con!=null){
      con.close();
    }
  }
  public static void main(String[] args) {
    DbUtil dbUtil=new DbUtil();
    try {
      dbUtil.getCon();
      System.out.println("数据库连接成功！");
    } catch (Exception e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
      System.out.println("数据库连接失败");
    }
  }
}