savedata.jsp

数据库课程设利用好的是这个请使用网上调系统

<%@ page import="java.sql.*" %> 
<%@ page import="java.io.*" %> 
<%@ page import="java.util.*" %> 
<%@ page contentType="text/html;charset=GB2312"%> 
<%@ include file="conn.jsp"%> 
<%
String errormsg=new String();
String option1=new String();
String option2=new String();
String userip=new String();
String olduserip=new String();
String SQL=new String();
olduserip="";
errormsg="";
option1=request.getParameter("option1");
option2=request.getParameter("option2");
Cookie acookie[] = request.getCookies();
        for(int i = 0; i < acookie.length; i++)
        {
            Cookie bcookie = acookie[i];
            if(bcookie.getName().equals("cuserip"))
                olduserip = bcookie.getValue();
        }

if (option1==null) option1="";
if (option2==null) option2="";
if (option1.equals(""))
errormsg="对不起，如果要投票，两项均不可漏选！";
if (option2.equals(""))
errormsg="对不起，如果要投票，两项均不可漏选！";
if (!errormsg.equals("")){
out.println("<SCRIPT LANGUAGE=JavaScript>alert('"+errormsg+"');"); 
out.println("location.href='research.jsp'"); 
out.println("</SCRIPT>"); 
}
else{
userip=request.getRemoteAddr();
if (userip.equals(olduserip)){ 
   errormsg="您已经投过票了，请不要重复投票，谢谢您的支持！";
   out.println("<SCRIPT LANGUAGE=JavaScript>alert('"+errormsg+"');"); 
   out.println("location.href='research.jsp'"); 
   out.println("</SCRIPT>");
    }
else{    
   Cookie cookie = new Cookie("cuserip",request.getRemoteAddr());
   cookie.setMaxAge(600);
   response.addCookie(cookie);
   SQL="select * from research where id=1";
Statement stmt=con.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
ResultSet rs=stmt.executeQuery(SQL);
if(!rs.next()){
  rs.close();
  SQL="insert into research("+option1+","+option2+") values(1,1)";
  stmt.executeQuery(SQL);
}
else{
  rs.close();
  SQL="update research set "+option1+"="+option1+"+1,"+option2+"="+option2+"+1 where id=1";
  stmt.executeQuery(SQL);
}
stmt.close();
   errormsg="投票完成，谢谢您的支持！";
   out.println("<SCRIPT LANGUAGE=JavaScript>alert('"+errormsg+"');"); 
   out.println("location.href='look.jsp'"); 
   out.println("</SCRIPT>");
}
}
con.close();
%>