700f398bc184001d1226fb6b1ede22e0

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

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


public class Memo {
	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;
		try {
			Class.forName(driverName);
			dbcon = DriverManager.getConnection(dbURL, dbuser, dbpass);
			PreparedStatement pstmt = dbcon.prepareStatement(sql);
			rs=pstmt.executeQuery();
			
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		return rs;
	}
}