act.jsp

一个bug管理系统

<%@ page contentType="text/html; charset=gb2312" language="java"
	import="java.sql.*" errorPage=""%>
<%!public String gb2iso(String qs) {
		try {
			if (qs == null)
				return "NULL";
			else
				return new String(qs.getBytes("gb2312"), "iso-8859-1");
		} catch (Exception e) {
			log("gb2iso error：" + e.getMessage());
		}
		return "NULL";
	}%>
<%
	String host = "localhost";
	String user = "root";
	String pw = "123";
	String db = "numb1";

	Class.forName("com.mysql.jdbc.Driver").newInstance();
	String url = "jdbc:mysql://" + host + "/" + db;
	Connection con = DriverManager.getConnection(url, user, pw);
	Statement st = con.createStatement();

	request.setCharacterEncoding("gb2312");
	String title = request.getParameter("title");
	String name = request.getParameter("name");
	String mail = request.getParameter("mail");
	String web = request.getParameter("web");
	String qq = request.getParameter("qq");
	String txt = request.getParameter("text");
	String ip = request.getRemoteAddr();
	if ("http://".equals(web)) {
		web = "";
	}

	String sql = "insert into lyb values(0,'" + gb2iso(title) + "','"
			+ gb2iso(name) + "','" + gb2iso(mail) + "','" + gb2iso(web)
			+ "','" + gb2iso(qq) + "','" + ip + "',now(),'"
			+ gb2iso(txt) + "','','n')";
	st.executeUpdate(sql);
	st.close();
	con.close();
	response.sendRedirect("index.jsp");
%>