402661cabe84001d112d930a936cdffe

来自「一个简单的备忘录实现全部功能基于MVC框架开发以MySql为数据库」· 代码 · 共 47 行

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 ResultSet show(){
		ResultSet rs = null;
		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 * 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);
			
			
		} catch (Exception e) {
			// TODO: handle exception
		}
		
		return rs;
	}
}