package Bean;
public class login {
private String user;
private String password;
public login(){
super();
}
public String getUser() {
return user;
}
public void setUser(String user) {
this.user = user;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}package Dao;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import Bean.login;
import Util.DBUtil;
public class loginDao {
public static Bean.login login(String user) throws SQLException{ //static Bean.login根据提示修改
String sql = "select * from user where user_name ='" +user+"'";
Connection con = DBUtil.getConnection();
Statement stmd = con.createStatement();
ResultSet rs = stmd.executeQuery(sql);
while(rs.next()){
login u = new login();
u.setUser(rs.getString("user"));
u.setPassword(rs.getString("password"));
return null;
}
return null;
}
}
package Servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.swing.JOptionPane;
import Bean.login;
import Dao.loginDao;
public class loginServlet extends HttpServlet {
/**
*
*/
private static final long serialVersionUID = 6835706189070152812L;
/**
* Constructor of the object.
*/
public loginServlet() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
return;
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String user = request.getParameter("user");
String password = request.getParameter("password");
response.setContentType("text/html");
//PrintWriter out = response.getWriter();
try{
login lg = new Bean.login();
lg = loginDao.login("user");
if(user != null){
if(lg.getPassword().endsWith(password)){
request.getRequestDispatcher("index.jsp")
.forward(request, response);
}else{
request.getRequestDispatcher("login.jsp")
.forward(request, response);
}
}else{
JOptionPane.showMessageDialog(null, "用户名不存在！");
response.sendRedirect("Login.jsp");
}
}catch(SQLException e){
e.printStackTrace();
}
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occurs
*/
public void init() throws ServletException {
// Put your code here
}
}
package Util;
import java.sql.*;
public class DBUtil {
public static Connection getConnection() throws SQLException{
String url = "jdbc:mysql://192.168.100.1:3306/bus";
String user = "root";
String password = "";
Connection con = null;
try{
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection(url,user,password);
}catch(Exception e){
e.printStackTrace();
}
return con;
}
}
<%@ page language="java" import="java.util.*" pageEncoding="GB2312"%>
<%
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>
<base href="<%=basePath%>">
<title>My JSP 'login.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">
-->
</head>
<title>登录</title>
<body>
<form action="servlet/loginServlet" method="post">
用户名：<input type="text" name="user">
密码： <input type="text" name="password">
<input type="submit" name="login" value="submit">
</form>
</body>
</html>
慕村4705583
相关分类