c035235fab84001d112d930a936cdffe

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

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

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;
		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);
				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>");
				}
				String iem=title+time+detail;
			}
		} catch (Exception e) {
			// TODO: handle exception
		}
		return (title"+"time"+"detail);
	}
}