jsp小问题。高手请指点!!!只要正确,一定送分。在线等待!!!
cdsun 2002-11-28 11:11:35 代码如下:
<%@ page language = "java" %>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*"%>
<%@ page contentType="text/html;charset=gb2312" %>
<%
String sqlRst;
String open;
String sql;
//java.lang.String sql;
//java.lang.String sqlRst;
String ids = request.getParameter("id");
int id=Integer.parseInt(ids);
String style = request.getParameter("style");
%>
<%
try {
//---取得联接,SQl Server数据库---
Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); //这个是jdbc桥用来连odbc的
String url="jdbc:odbc:Test_DB"; //Test_DB是数据库名字
String user="sa"; //登陆用户名
String password=""; //登陆密码
Connection con= DriverManager.getConnection(url,user,password); //连接字符串
//---修改数据---
if (sqlRst.getString("style").equalsIgnoreCase("open"))
{
sql = "update from news set isvalid='1' where id="+id;
}
if (sqlRst.getString("style").equalsIgnoreCase("cancel"))
{
sql = "update from news set isvalid='0' where id="+id;
}
stmt.executeUpdate(sql);
con.commit();
//}
//}
//rs.close();
//stmt.close();
//con.close();
}
catch(Exception e)
{
System.out.println(e.getMessage());
}
%>
<%
String redirectURL = "index.jsp";
response.sendRedirect(response.encodeURL(redirectURL));
%>
有劳各位费神帮我看看