MVC设计模式:
M:Model ,模型 :一个功能。用JavaBean实现。
V:View,视图: 用于展示、以及与用户交互。使用html js css jsp jquery等前端技术实现
C:Controller,控制器 :接受请求,将请求跳转到模型进行处理;模型处理完毕后,再将处理的结果
返回给 请求处 。 可以用jsp实现, 但是一般建议使用 Servlet实现控制器。
案例:
login.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="LoginServlet" method="post">
用户名:<input type="text" name="uname"></br>
密码:<input type="password" name="upwd"></br>
<input type="submit" value="登陆">
</form>
</body>
登录之后,welcom.jsp
</html>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
登陆成功!!!!
</body>
</html>
LoginDao.java
package com.baidu.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.baidu.entity.Login;
public class LoginDao {
static Connection connection=null;
static PreparedStatement pstmt =null;
static ResultSet result=null;
public static int login(Login login) {
try {
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/ts", "root", "root");
String sql ="select count(*) from t_login where name =? and pwd = ?";
pstmt = connection.prepareStatement(sql);
pstmt.setString(1, login.getName());
pstmt.setString(2, login.getPwd());
result = pstmt.executeQuery();
int count=-1;
if (result.next()) {
return count =result.getInt(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(result== null) result.close();
if(pstmt == null) pstmt.close();
if(connection==null) connection.close();
} catch (SQLException e) {
e.printStackTrace();
}catch (Exception e) {
e.printStackTrace();
}
}
}
}
Login.java
package com.baidu.entity;
public class Login {
private String name;
private String pwd;
public Login(String name, String pwd) {
super();
this.name = name;
this.pwd = pwd;
}
public Login() {
super();
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPwd() {
return pwd;
}
public void setPwd(String pwd) {
this.pwd = pwd;
}
}
LoginServlet.java
package com.baidu.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 com.baidu.dao.LoginDao;
import com.baidu.entity.Login;
public class LoginServlet extends HttpServlet {
private String name;
private String pwd;
private int result;
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//处理登陆
request.setCharacterEncoding("Utf-8");
name = request.getParameter("uname");
pwd = request.getParameter("upwd");
Login login = new Login(name,pwd);
result = LoginDao.login(login);
if (result==1) {
response.sendRedirect("welcom.jsp");
}else {
response.sendRedirect("login.jsp");
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request, response);
}
}