savedata.jsp

基于JAVA语言

<%@page contentType = "text/html;charset = GB2312" import = "java.sql.*"%>

<%
String name = new String (request.getParameter("name").getBytes("ISO-8859-1"));
if(name.equals(" "))
response.sendRedirect("enter.jsp?error = 1");
else
{
String sex = request.getParameter("sex");
String change = request.getParameter("change");
String color = request.getParameter("color");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:chat");
Statement smt = con.createStatement();
String sql;
sql = "select * from online where nicheng = '"+name+"'";
ResultSet rs = smt.executeQuery(sql);
if(!rs.next())
{
session.putValue("name",name);
session.putValue("sex",sex);
session.putValue("change",change);
session.putValue("color",color);
sql = "insert into online (nicheng,xingbie)values('"+name+"','"+sex+"')" ;
smt.execute(sql);
con.close();
response.sendRedirect("chatroom.jsp");
}
else 
response.sendRedirect("enter.jsp?error = 2");
con.close();
}
%>