mcv小案例

<form action="loginServlet" method="post">
用户名:<input type="text" name="name"><br>
用密码:<input type="password" name="pwd"><br>
<input type="submit" value="提交">
</form>

package entry;

public class Admin {
private String name;
private String pasword;

public String getName() {
	return name;
}
public void setName(String name) {
	this.name = name;
}
public String getPasword() {
	return pasword;
}
public void setPasword(String pasword) {
	this.pasword = pasword;
}
@Override
public String toString() {
	return "Admin [name=" + name + ", pasword=" + pasword + "]";
}
public Admin(String name, String pasword) {
	super();
	this.name = name;
	this.pasword = pasword;
}
}

package Dao;

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

import entry.Admin;

public class loginDao {
	public static int login(Admin admin) {
		Connection conn = null;
		PreparedStatement pas = null;
		ResultSet rs = null;
		int row = 0;
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
			String user = "scott";
			String password = "tiger";
			conn = DriverManager.getConnection(url, user, password);
			String sql = "SELECT count(*) from  Admin1  where name =? and password =?";
			pas = conn.prepareStatement(sql);
			pas.setString(1, admin.getName());
			pas.setString(2, admin.getPasword());
			rs = pas.executeQuery();
			while (rs.next()) {
				// 查询返回一列数据，获取这列数据；
				row = rs.getInt(1);
			}
		} catch (SQLException e) {
			e.printStackTrace();
			return 0;
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
			return 0;
		} catch (Exception e) {
			e.printStackTrace();
			return 0;
		} finally {
			try {
				if(rs != null) 
					rs.close();
				if(pas != null) 
				pas.close();
				if(conn != null) 
			      conn.close();
				}catch (Exception e) {
				
			}
		}
		return row;
	}
}

package Service;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import Dao.loginDao;
import entry.Admin;

public class loginServlet extends HttpServlet{
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    response.setContentType("text/html; charset=UTF-8");
	request.setCharacterEncoding("utf-8");
	String name = request.getParameter("name");
	String pwd = request.getParameter("pwd");
	//获取前端的页面；
	Admin admin = new Admin(name,pwd);
	int login = loginDao.login(admin);
	if(login>0) {
		//可以跳转页jsp.在这里不跳转了
		//response.sendRedirect("");
		System.out.println("登录成功");
	}else {
		System.out.println("登录失败");
	}
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request, response);
}
}