Ckeditor和数据库交互

这个设计重要的后台数据库的交互

CkeditorModel.java

package model;

import java.sql.Date;

public class CkeditorModel {
	private int id;
	private String content;
	private Date addTime;

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public String getContent() {
		return content;
	}

	public void setContent(String content) {
		this.content = content;
	}

	public Date getAddTime() {
		return addTime;
	}

	public void setAddTime(Date addTime) {
		this.addTime = addTime;
	}
}

 CKeditorDao.java

package dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import util.DbUtil;

import model.CkeditorModel;

public class CKeditorDao {
	public void addCkeditor(CkeditorModel model) throws SQLException {
		String sql = "insert into ckstudy values(?,?,?)";
		Connection conn = null;
		try {
			conn = DbUtil.getConnection();
			PreparedStatement pst = conn.prepareStatement(sql);
			pst.setInt(1, model.getId());
			pst.setString(2, model.getContent());
			pst.setDate(3, model.getAddTime());
			pst.executeUpdate();
			pst.close();
		} finally {
			if (conn != null) {
				conn.close();
			}
		}
	}

	public List<CkeditorModel> getCkeditorModels() throws SQLException {
		List<CkeditorModel> models = new ArrayList<CkeditorModel>();
		String sql = "select * from ckstudy";
		Connection conn = null;
		try {
			conn = DbUtil.getConnection();
			Statement st = conn.createStatement();
			ResultSet rs = st.executeQuery(sql);
			while (rs.next()) {
				CkeditorModel model = new CkeditorModel();
				model.setId(rs.getInt(1));
				model.setContent(rs.getString(2));
				model.setAddTime(rs.getDate(3));
				models.add(model);
			}
			st.close();
			rs.close();
		} finally {
			if (conn != null) {
				conn.close();
			}
		}
		return models;
	}
}

  CkeditorServlet.java

package servlet;

import java.io.IOException;
import java.sql.SQLException;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;

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

import dao.CKeditorDao;

import model.CkeditorModel;

/**
 * Servlet implementation class CkeditorServlet
 */
public class CkeditorServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;

	/**
	 * @see HttpServlet#HttpServlet()
	 */
	public CkeditorServlet() {
		super();
		// TODO Auto-generated constructor stub
	}

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
	 *      response)
	 */
	protected void doGet(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
	 *      response)
	 */
	protected void doPost(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");

		String data = request.getParameter("editor");

		Date date = new Date();
		DateFormat df = new SimpleDateFormat("yyyy-MM-dd");
		df.format(date);

		CkeditorModel model = new CkeditorModel();
		model.setContent(data);
		model.setAddTime(java.sql.Date.valueOf(df.format(date)));

		CKeditorDao cKeditorDao = new CKeditorDao();
		try {
			cKeditorDao.addCkeditor(model);
			List<CkeditorModel> models = cKeditorDao.getCkeditorModels();
			request.setAttribute("models", models);
			request.getRequestDispatcher("showCkeditorServlet.jsp").forward(
					request, response);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

}

 DbUtil.java

 

package util;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

public class DbUtil {
	private static String driver;
	private static String url;
	private static String user;
	private static String password;
	private static String configFilePath = "/dbconfig.ini";
	private static boolean isinited = false;

	public static Connection getConnection() throws SQLException {
		if (!isinited) {
			try {
				loadConfig();
			} catch (IOException e1) {
				e1.printStackTrace();
			}
			try {
				Class.forName(driver);
			} catch (ClassNotFoundException e) {
				e.printStackTrace();
			}
			isinited = true;
		}
		return DriverManager.getConnection(url, user, password);
	}

	private static void loadConfig() throws IOException {
		Properties props = new Properties();
		InputStream ins = DbUtil.class.getResourceAsStream(configFilePath);
		try {
			props.load(ins);
			driver = props.getProperty("driver").trim();
			url = props.getProperty("url").trim();
			user = props.getProperty("user").trim();
			password = props.getProperty("password").trim();
		} finally {
			if (ins != null) {
				ins.close();
			}
		}
	}
}

 

 dbconfig.ini

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/mydatabase
user=root
password=root

 

在进行一下简单的前台 设置 就可以进行交互了