<%@ page contentType="text/html;charset=gb2312"%>
<%@page import="IAToolkit.*"%>
<%@page import="java.sql.*"%>
<%@page import="java.io.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<jsp:useBean id="dbt" class="IAToolkit.DBTools" scope="page"/>
<body>
<%
ResultSet rs=null;
String SQL=null;
try{
String name=request.getParameter("name");
String psw=request.getParameter("psw");
String right_id=request.getParameter("rank");
dbt.dbserverConnect();
SQL="updata INFOAIR_USERINFO set USERPSW='"+psw+"',"+"RIGHT_ID='"+right_id+"'where USERNAME='"+name+"'";
rs=dbt.executeQuery(SQL);
dbt.dbserverDisConnect();
}catch(Exception e){e.printStackTrace();}
%>
<center><h1>修改成功</h1>
<a href="index.jsp">返回</a>
</center>
</body>
</html>
<%@page import="IAToolkit.*"%>
<%@page import="java.sql.*"%>
<%@page import="java.io.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<jsp:useBean id="dbt" class="IAToolkit.DBTools" scope="page"/>
<body>
<%
ResultSet rs=null;
String SQL=null;
try{
String name=request.getParameter("name");
String psw=request.getParameter("psw");
String right_id=request.getParameter("rank");
dbt.dbserverConnect();
SQL="updata INFOAIR_USERINFO set USERPSW='"+psw+"',"+"RIGHT_ID='"+right_id+"'where USERNAME='"+name+"'";
rs=dbt.executeQuery(SQL);
dbt.dbserverDisConnect();
}catch(Exception e){e.printStackTrace();}
%>
<center><h1>修改成功</h1>
<a href="index.jsp">返回</a>
</center>
</body>
</html>
解决方案 »
- 请各位帮忙能够解决一下 ssh整合的问题 已经无奈了
- Struts标签中如何对char类型变量进行比较?
- java.lang.IllegalArgumentException: Cannot invoke com.dc.portal.common.entity.Fp
- 初学stuts-menu碰到了不懂的问题?????
- <html:file>中选择文件后,如何取得文件的路径呢?
- Tomcat启动时的异常!
- 程序出错大家帮我看看啊,跪求了!要多少分都给呀!!
- 关于apache tomcat
- 救命,给一个网站软硬件方案,五六十万左右
- 关于几个JSP操作数据库的菜问题,请各位老大帮忙!
- jsp计数器,无法获取web.xml中的初值,怎么办
- Struts的异常处理机制
更删插要用executeUpdate
try {
url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=fids";
String driver1 = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
Class.forName(driver1);
user="sa";
psw="ats";
connection = DriverManager.getConnection(url,user,psw);
statemt = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
}
catch (Exception e) {
System.out.println("serverConnectERR:" + e.toString());
return false;
}
return true;
} public boolean dbserverDisConnect() {
try {
if (statemt != null) {
statemt.close();
statemt = null;
}
if (prepstmt != null) {
prepstmt.close();
prepstmt = null;
}
connection.close();
}
catch (SQLException e) {
System.out.println(e.toString());
return false;
}
return true;
} public ResultSet executeQuery(String sql) {
ResultSet r;
try {
r = statemt.executeQuery(sql);
}
catch (Exception e) {
System.out.println("executeQueryERR:" + e.toString());
err = true;
return null;
}
err = false;
return r;
}
SQL="update INFOAIR_USERINFO set USERPSW='"+psw+"',RIGHT_ID='"+right_id+"' where USERNAME='"+name+"'";
String name = new String(request.getParameter("name").getBytes("ISO8859_1"));
String psw = new String(request.getParameter("psw").getBytes("ISO8859_1"));
String right_id = new String(request.getParameter("rank").getBytes("ISO8859_1"));
dbt.dbserverConnect();
String user = "updata INFOAIR_USERINFO set USERPSW='" + psw +"',RIGHT_ID='" + right_id + "'where USERNAME='" + name +"'";
m = dbt.modify(user);
dbt.dbserverDisConnect();
if(m==true)
{//
out.println("<script language=\"javascript\">");
out.println("window.close();");
out.println("</script>");
}
else response.sendRedirect("modify.jsp");改成这样了,还是不行啊!m返回的总是false.
请问修改语句是updata吗?改成update