guanliyuanpassword2.jsp

WEB图书馆系统,jsp编写,适用用于JSP的初始者

<%@ page contentType="text/html;charset=GB2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.lang.Exception.*"%>
<%
//数据库连接
String url="jdbc:odbc:xuesheng";
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
  Connection con=DriverManager.getConnection(url);
  Statement stmt=con.createStatement();
  //ResultSet result=stmt.executeQuery("update xinxi_book set");
  //ResultSetMetaData resultmd=result.getMetaData();


if(request.getParameter("condition1")!=null)
{
    String condition1=request.getParameter("condition1");
    String condition3=request.getParameter("condition3"); 



//condition2 = new String(condition2.getBytes("ISO-8859-1"), "GBK"); 
//condition3 = new String(condition3.getBytes("ISO-8859-1"), "GBK");
String sql="update xinxi_guanliyuan set guanliyuan_mima="+"'"+condition3+"'" +"where guanliyuan_id="+"'"+condition1+"'";
//ResultSet result1
//stmt.executeQuery(sql);
out.println("<br>");
//out.println(sql);
out.println("<p>");
out.println("<center>");
int n=stmt.executeUpdate(sql);
if(n>0)
{
	out.println("修改成功，请记好您的密码！");
}
else
{
	out.println("操作未完成");
}

stmt.close();
con.close();
}
%>