blog 添加博文

BlogServlet.java

package cn.com.blog;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;

import org.apache.commons.dbutils.QueryRunner;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
import com.opensymphony.xwork2.inject.Context;

public class BlogServlet extends HttpServlet {

	public BlogServlet() {
		super();
	}

	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		doPost(request, response);
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		request.setCharacterEncoding("utf-8");
		String title = request.getParameter("title");
		String content = request.getParameter("content");
		String categoryId = request.getParameter("categoryId");

		int flag = 0;
		java.sql.Connection con;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			con = DriverManager.getConnection(
					"jdbc:mysql://localhost:3306/new_db", "root", "");
			java.sql.Statement stmt = con.createStatement(
					ResultSet.TYPE_SCROLL_INSENSITIVE,
					ResultSet.CONCUR_READ_ONLY);
			String sql = "insert into   blog(title,content,category_id) VALUES (' "
					+ title
					+ " ', ' "
					+ content
					+ " ', ' "
					+ categoryId
					+ "') ";
			flag = stmt.executeUpdate(sql);

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		String message = null;
		if (flag == 1) {
			message = "添加成功";
		} else {
			message = "添加失败";
		}

		request.setAttribute("message", message);
		request.getRequestDispatcher("/addBlogResult.jsp").forward(request,
				response);

	}

	public void init() throws ServletException {
		// Put your code here
	}

}

2 http://localhost:8088/liuwei/servlet/BlogServlet/ 错误，服务器会报错，认为这个jsp找不到
  http://localhost:8088/liuwei/servlet/BlogServlet  正确




3 Jakarta.apache.org,很多东西都是这个网站发明的，比如说Lucene


4 myeclipse中，ctrl+shift+f （格式化代码）


5 java.lang.ClassNotFoundException: com.mysql.jdbc.Driver 
 当我仔细检查的时候才发先“com.mysql.jdbc.Driver ”后面多了一个空格


6  Unknown column 'categoryId' in 'field list'
   我仔细看了一下数据库语句。发现在field当中对应的是category_id.在jsp当中才是categoryId


7 我们尽可能的把表的id设置为自动增长的类型。