刘雨杭jsp

package org.mbw.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.mbw.entity.Login;<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>package com.dx.DAO;
 
import com.dx.entity.dlBean;
 
import java.sql.*;
 
public class dlDAO {
    public int insert(dlBean dlBean) throws ClassNotFoundException, SQLException {
        Class.forName("com.mysql.jdbc.Driver");
 
        Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql", "root", "root");
 
        PreparedStatement preparedStatement = connection.prepareStatement("insert into dl(uname,upwd)value (?,?)");
        preparedStatement.setString(1, dlBean.getUname());
        preparedStatement.setString(2, dlBean.getUpwd());
 
        Integer res = preparedStatement.executeUpdate();
        return res;
    }
}
    <base href="<%=basePath%>">

    <title>My JSP 'index.jsp' starting page</title>
    <meta http-equiv="pragma" content="no-cache">
    <meta http-equiv="cache-control" content="no-cache">
    <meta http-equiv="expires" content="0">   
    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    <meta http-equiv="description" content="This is my page">
    <!--
    <link rel="stylesheet" type="text/css" href="styles.css">
    -->

public class LoginDao {
        public static int login(Login Login) {
            //boolean flag = false;
            int flag = -1 ;
            int result = -1;try {
                Class.forName("com.mysql.jdbc.Driver");
                connection = DriverManager.getConnection(URL, USERNAME, PWD);
                
                String sql = "select count(*) from user where uname = ? and pwsd = ?";
                ps = connection.prepareStatement(sql);
                ps.setString(1, Login.getUname());
                ps.setString(2, Login.getPwsd());
                rs = ps.executeQuery();
                if(rs.next()) {
                    result = rs.getInt(1);
                }
                if(result>0) {
                    return 1;
                }else {
                  return 0;
                }
            } catch (ClassNotFoundException e) {
                e.printStackTrace();
                return -1;
            }catch(SQLException e) {
                e.printStackTrace();
                return -1;
            }catch(Exception e) {
                e.printStackTrace();
                return -1;
            }finally {
                try {
                if(rs!=null) rs.close();
                if(ps!=null) rs.close();
                if(connection!=null) rs.close();
                }catch(SQLException e) {
                    e.printStackTrace();
                }catch(Exception e) {
                    e.printStackTrace();
                }
            }
        }
}


package org.mbw.entity;

public class Login {
       private int id;
       private String uname;
       private String pwsd;
       
   public Login() {
}
   
   public Login(String uname, String pwsd) {
        this.uname = uname;
        this.pwsd = pwsd;
    }
    public Login(int id, String uname, String pwsd) {
        this.id = id;
        this.uname = uname;
        this.pwsd = pwsd;
    }
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getUname() {
        return uname;
    }
    public void setUname(String uname) {
        this.uname = uname;
    }
    public String getPwsd() {
        return pwsd;
    }
    public void setPwsd(String pwsd) {
        this.pwsd = pwsd;
    }
       
       
}



package org.mbw.servlet;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.mbw.dao.LoginDao;
import org.mbw.entity.Login;


public class LoginServlet extends HttpServlet {
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        String name = request.getParameter("uname");
        String pwd = request.getParameter("upwsd");
        Login login = new Login(name,pwd);//用户名,密码
        
        int result = LoginDao.login(login);
        if(result>0) {
            response.sendRedirect("Welcome.jsp");
        }else {
            response.sendRedirect("login.jsp");
        }
    }
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doGet(request, response);
    }

}

 

posted @ 2021-04-19 17:35  38岁离婚带俩孩  阅读(36)  评论(0编辑  收藏  举报