2089e33a3286001d179bcb8f08d4888e

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

package memo;

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

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

public class Process {

	/**
	 * 注册
	 * */
	public String reg(HttpServletRequest request, HttpServletResponse response){
		String path="/reg.jsp";
		String username=request.getParameter("uname");
		String password=request.getParameter("upass");
		String  rpassword=request.getParameter("rupass");
		DbConnection con=new DbConnection();
		Connection dbcon=con.getcon();
		if(!("".equals(username)||"".equals(password) || "".equals(rpassword))){
			if(password.equals(rpassword)){
		try {
			Statement smt = dbcon.createStatement();
			smt.execute("insert into User VALUES ('"+username+"','"+password+"')");
			request.setAttribute("img","注册成功！请您登陆");
			path="/login.jsp";
		} catch (Exception e) {
			// TODO: handle exception
		}
			}
		}else{
			request.setAttribute("img","错误！请您重新注册");
		}
		
		return path;
		
	}
	/**
	 * 添加备忘录
	 * */
	public String insert(HttpServletRequest request, HttpServletResponse response){
		String path="/insert.jsp";
		String title=request.getParameter("title");
		String time=request.getParameter("time");
		String detail=request.getParameter("detail");
		String sql="insert into Memo VALUES ('" + title + "','" + time
		+ "','" + detail + "')";
		if("".equals(time)){
			sql="insert into Memo VALUES ('" + title + "',now(),'" + detail + "')";
		}
		DbConnection con=new DbConnection();
		Connection dbcon=con.getcon();
		if(!("".equals(title)|| "".equals(detail))){
			try {
				Statement smt = dbcon.createStatement();
				smt.execute(sql);
				path = "/select.jsp";
				ResultSet rs=smt.executeQuery("select * from memo");
				request.setAttribute("result", rs);
			} catch (Exception e) {
				// TODO: handle exception
			}
		}else{
			request.setAttribute("img", "错误！请您重新添加");
		}
		return path;
		}
	/**
	 * 登陆
	 * */
	public String login(HttpServletRequest request,HttpServletResponse response){
		String path="/login.jsp";
		String username=request.getParameter("uname");
		String password=request.getParameter("upass");
		DbConnection con=new DbConnection();
		Connection dbcon=con.getcon();
		try {
			Statement smt = dbcon.createStatement();
			ResultSet rs=smt.executeQuery("select * from user where username='" + username+ "' and password='" + password + "'");
			if(rs.next()){
				path = "/select.jsp";
			rs=smt.executeQuery("select * from memo");
			request.setAttribute("result", rs);
			}else{
				request.setAttribute("img","错误！请您重新登陆");
			}
		} catch (Exception e) {
			// TODO: handle exception
		}
		return path;
	}
	/**
	 * 删除
	 * */
	public String delete(HttpServletRequest request, HttpServletResponse response){
		String path="/fail.jsp";
		String title=request.getParameter("title");
//		String time=request.getParameter("time");
//		String detail=request.getParameter("detail");
		DbConnection con=new DbConnection();
		Connection dbcon=con.getcon();
		try {
			Statement smt = dbcon.createStatement();
			smt.execute("delete  from Memo where title='"+title+"' ");
			path="/select.jsp";
			ResultSet rs=smt.executeQuery("select * from memo");
			request.setAttribute("result", rs);
		} catch (Exception e) {
			// TODO: handle exception
		}
			return path;	
	}
	/**
	 * 修改
	 * */
	public String update(HttpServletRequest request, HttpServletResponse response){
		String path="/update.jsp";
		String img=null;
		String id=request.getParameter("id");
		String title=request.getParameter("title");
		String time=request.getParameter("time");
		String detail=request.getParameter("detail");
		DbConnection con=new DbConnection();
		Connection dbcon=con.getcon();
		try {
			Statement smt = dbcon.createStatement();
			smt.executeUpdate("UPDATE memo SET title='"+title+"',detail='"+detail+"' where title='"+id+"'  ");
			path="/select.jsp";
			ResultSet rs=smt.executeQuery("select * from memo");
			request.setAttribute("result", rs);
		} catch (Exception e) {
			// TODO: handle exception
		}
			return path;	
	}
	/**
	 * 查找
	 * */
	public String select(HttpServletRequest request,HttpServletResponse response){
		String path="/fail.jsp";
		String title=request.getParameter("title");
//		String time=request.getParameter("time");
//		String detail=request.getParameter("detail");
		DbConnection con=new DbConnection();
		Connection dbcon=con.getcon();
		try {
			Statement smt = dbcon.createStatement();
			ResultSet rs=smt.executeQuery("select * from Memo where title like '%"+title+"%' or time like '%"+title+"%' or detail like '%"+title+"%'");
			request.setAttribute("result", rs);
			path = "/select.jsp";
		} catch (Exception e) {
			// TODO: handle exception
		}
		return path;
	}
	/**
	 * 编辑
	 * */
	public String edit(HttpServletRequest request,HttpServletResponse response){
		String path="/fail.jsp";
		String title=request.getParameter("title");
//		String time=request.getParameter("time");
//		String detail=request.getParameter("detail");
		DbConnection con=new DbConnection();
		Connection dbcon=con.getcon();
		try {
			Statement smt = dbcon.createStatement();
			ResultSet rs=smt.executeQuery("select * from Memo where title='"+title+"'");
			request.setAttribute("result", rs);
			path = "/update.jsp";
		} catch (Exception e) {
			// TODO: handle exception
		}
		return path;
	}
}