tre_vote.jsp~2~

来自「JAVA实验图形 =各种 的 JAVA简单代码 出初学者必备！！！！！！！！！」· JSP~2~ 代码 · 共 41 行

<%@ page contentType="text/html; charset=gb2312"%>
<%@ page language="java" import="java.sql.*"%>
<%
String getitem = request.getParameter("voteitem");
if(getitem == null)
{
response.sendRedirect("y1.jsp");
}
else
{

response.sendRedirect("y2.jsp");
}
Statement stmt=null;
        PreparedStatement pstmt=null;

String sql = "update vote set vnum = vnum + 1 where id = "+getitem+"";
        //加载JDBC-ODBC桥驱动
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            //定义JDBC URL
        }catch (Exception e) {
        out.println(e.getMessage());
        }
          try{

        String url = "jdbc:odbc:s";
            //得到与数据库的连接
            Connection con = DriverManager.getConnection(url);
            //显示UPL和连接信息
            System.out.print("URL:" + url);
            System.out.print("Connection:" + con);
            //得到一个Statement对象
            stmt = con.createStatement();
            //执行SQL语句
            System.out.print("SQL:" + sql);
            ResultSet p = stmt.executeQuery(sql);
            } catch (Exception e) {}
%>
%>