add2.jsp

jsp 和 access 联合开发的聊天小程序

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.io.UnsupportedEncodingException"%>
<%@ include file="conn.jsp"%>
<%
String zt,username,qq,email,sex,tx,nr,zt1,username1,qq1,sex1,tx1,nr1;
	zt1=request.getParameter("zt");
	zt=(new String(zt1.getBytes("iso-8859-1"),"gb2312"));
	
	username1=request.getParameter("username");
	username=(new String(username1.getBytes("iso-8859-1"),"gb2312"));
	
	qq1=request.getParameter("qq");
	qq=(new String(qq1.getBytes("iso-8859-1"),"gb2312"));
	

    email=request.getParameter("email");

	
	sex1=request.getParameter("sex");
	sex=(new String(sex1.getBytes("iso-8859-1"),"gb2312"));
	
	tx1=request.getParameter("tx");
	tx=(new String(tx1.getBytes("iso-8859-1"),"gb2312"));
	
	nr1=request.getParameter("nr");
	nr=(new String(nr1.getBytes("iso-8859-1"),"gb2312"));
	
if(username.length()!=0&&nr.length()!=0){
	try{
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql;
sql="insert into a (zt,username,qq,email,sex,tx,nr) values ('"+zt+"','"+username+"','"+qq+"','"+email+"','"+sex+"','"+tx+"','"+nr+"')";
stmt.executeUpdate(sql);
stmt.close();
conn.close();
out.print("<script language='javascript'>alert('留言成功');window.location.href='index.jsp';</script>");
}catch(Exception e){
out.print("信息错误！");
}
}
else{
out.print("<center>用户名为空或没有留言内容"+"<br><a href=javascript:history.go(-1)>返回</a></center>");
}
%>