act.jsp

可以自由留言,采用mysql数据库,jsp编程,界面美观

<%@ 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="";
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");
%>