c09fc698af84001d112d930a936cdffe

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

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.HashMap;
import java.util.Map;

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


public class MemoMo {

	public String show(HttpServletRequest request,HttpServletResponse response){
		
		String keyword = request.getParameter("keyword") ;
		String driverName="com.mysql.jdbc.Driver";
		String dbURL="jdbc:mysql://localhost:3306/test";
		String dbuser="root";
		String dbpass="1234";
		Connection dbcon;
		String sql = null;
		Map map = new HashMap();
	
//			if(keyword==null)
//			{
			sql = "select title,time,detail from Memo";
//			}
//			else
//			{
//			sql = "select title,time,detail from Memo WHERE title like ? or time like ? or detail like ?" ;
//			}
		
		try {
			Class.forName(driverName);
			dbcon = DriverManager.getConnection(dbURL, dbuser, dbpass);
			PreparedStatement pstmt = dbcon.prepareStatement(sql);
			ResultSet rs = null;
//			pstmt.setString(1, keyword);
//			pstmt.setString(2, keyword);
//			pstmt.setString(3, keyword);
			rs = pstmt.executeQuery();
			while (rs.next()) {
				String title = rs.getString(1);
				String time = rs.getString(2);
				String detail = rs.getString(3);
				list.add(title);
//				if (keyword != null) {
//					title = title.replaceAll(keyword, "<font color=\"red\">"
//							+ keyword + "</font>");
//					time = time.replaceAll(keyword, "<font color=\"red\">"
//							+ keyword + "</font>");
//					detail = detail.replaceAll(keyword, "<font color=\"red\">"
//							+ keyword + "</font>");
				return title+time+detail;
				}
				 
			
		} catch (Exception e) {
			// TODO: handle exception
		}
		return null;
		
	}
}