savenote.jsp

基于JAVA语言

<%@page contentType="text/html;charset=GB2312" import="java.sql.*"
%>
<%
String note=new String(request.getParameter("note").getBytes("ISO-8859-1"));
if(note.equals(" "))
  response.sendRedirect("show.jsp?error=1");
else
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:chat");
Statement smt=con.createStatement();
String sql;
String color=(String)session.getValue("color");
String name=(String)session.getValue("name");
sql="insert into chatroom(nicheng,xinxi,yanse)values('"+name+"','"+note+"','"+color+"')";
smt.execute(sql);
con.close();
response.sendRedirect("show.jsp");
}
%>