JDBConnection.java类代码:
public boolean executeUpdate(String sql) { if (con == null) {
creatConnection();
}
try {
Statement stmt = con.createStatement();
int iCount = stmt.executeUpdate(sql);
System.out.println("操作成功,所影响的记录数为" + String.valueOf(iCount));
} catch (SQLException e) {
System.out.println(e.getMessage());
System.out.println("executeUpdaterError!");
}
return true;
}
update.jsp页面代码:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="Css/Css.css" type="text/css" rel="stylesheet">
<jsp:useBean id="sql" scope="request" class="com.JDBConnection"/>
<html>
<head>
<title>Insert title here</title>
</head>
<body>
<%
String account=request.getParameter("account");
String sex=request.getParameter("sex");
String age=request.getParameter("age");
String profession=request.getParameter("profession");
String sql="update tb_userInfo set account='"+account+"',sex='"+sex+"',age='"+age+"',profession='"+profession+"' where id='"+request.getParameter("id")+"'";
sql.executeUpdate(sql);
%>
</body>
</html>
请问这段修改数据库代码对吗?要怎么修改?谢谢!!
public boolean executeUpdate(String sql) { if (con == null) {
creatConnection();
}
try {
Statement stmt = con.createStatement();
int iCount = stmt.executeUpdate(sql);
System.out.println("操作成功,所影响的记录数为" + String.valueOf(iCount));
} catch (SQLException e) {
System.out.println(e.getMessage());
System.out.println("executeUpdaterError!");
}
return true;
}
update.jsp页面代码:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="Css/Css.css" type="text/css" rel="stylesheet">
<jsp:useBean id="sql" scope="request" class="com.JDBConnection"/>
<html>
<head>
<title>Insert title here</title>
</head>
<body>
<%
String account=request.getParameter("account");
String sex=request.getParameter("sex");
String age=request.getParameter("age");
String profession=request.getParameter("profession");
String sql="update tb_userInfo set account='"+account+"',sex='"+sex+"',age='"+age+"',profession='"+profession+"' where id='"+request.getParameter("id")+"'";
sql.executeUpdate(sql);
%>
</body>
</html>
请问这段修改数据库代码对吗?要怎么修改?谢谢!!
解决方案 »
- 再次问及<base href="<%=basePath%>">路径改变的问题
- SQL语句告诉快来啊 !12580求救!!!
- mysql数据库换新的了,怎么hibernate查出来的数据还是原来的?
- 从数据库中取出的文章排版问题
- 一个tomcat启动问题;
- 大姐求助:如果在<tr></tr>中嵌入一数据库表?
- js高手帮忙看一下,为什么运行后报错 text1未定义?谢谢
- 各位大哥,请问谁知道在哪里下载SQL Server?
- CachedRowSet怎样实现分页?
- 如何实现JSP+ORACLE的BS系统的全文检索功能?
- 求救!!怎样配置MyEclipse6.0+sqlServer2000+Hibernate
- [找骂+散分]网吧零售系统(续1)--详细设计与不完全实现
还有程序代码写得很糟糕 ..
记得关闭连接 ..