90e8c7e3c883001d1ff08d9f6b01f3dd

一个简单的备忘录实现全部功能基于MVC框架开发以MySql为数据库

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

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


public class LoginMo {

	public String over(HttpServletRequest request,HttpServletResponse response){
		
		String url=null;
		String username=request.getParameter("uname");
		String password=request.getParameter("upass");
		
		String driverName="com.mysql.jdbc.Driver";
		String dbURL="jdbc:mysql://localhost:3306/test";
		String dbuser="root";
		String dbpass="1234";
		Connection dbcon;
		
		try {
			Class.forName(driverName);
			dbcon = DriverManager.getConnection(dbURL, dbuser, dbpass);
			Statement stmt = dbcon.createStatement();
			String sql = "select * from user where username='" + username
					+ "' and password='" + password + "'";
			ResultSet rs = stmt.executeQuery(sql);
			if (rs.next()) {

				request.setAttribute("name", username);
				rs.close();
				stmt.close();
				dbcon.close();
				return "/memo.jsp";
			} else {
				rs.close();
				stmt.close();
				dbcon.close();
				return "/fai.jsp";
			}
		} catch (Exception e) {
			// TODO: handle exception
		}
		return null;
	
		
	}
}