<%@ page language="java" contentType="text/html; charset=GBK"
pageEncoding="GBK"%>
<%@ page import="java.sql.*"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<title>Insert title here</title>
</head>
<body><%
try{
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/test?user=root&password=admin";
Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
request.setCharacterEncoding("gbk");
String id = request.getParameter("id");
String name = request.getParameter("name");
String sex = request.getParameter("sex");
String grade = request.getParameter("grade");//String id = new String(request.getParameter("id").getBytes("ISO8859-1"),"GBK");
//String name = new String(request.getParameter("name").getBytes("ISO8859-1"),"GBK");
//String sex = new String(request.getParameter("sex").getBytes("ISO8859-1"),"GBK");
//String grade = new String(request.getParameter("grade").getBytes("ISO8859-1"),"GBK");String sql = "update user set id = '"+id+"',name='"+name+"',sex='"+sex+"',grade="+grade+" where id='"+id+"'";if(stmt.execute(sql))
out.println("数据修改成功!");
else out.println("数据类型错误或未知错误!"); stmt.close();
conn.close();
}catch(SQLException e){
out.println("丫的又错了……");
} %>
<strong><font face="微软雅黑"><br><a href="manager.jsp">点击此处返回管理页面!</a></font>
</strong>
</body>
</html>
pageEncoding="GBK"%>
<%@ page import="java.sql.*"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<title>Insert title here</title>
</head>
<body><%
try{
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/test?user=root&password=admin";
Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
request.setCharacterEncoding("gbk");
String id = request.getParameter("id");
String name = request.getParameter("name");
String sex = request.getParameter("sex");
String grade = request.getParameter("grade");//String id = new String(request.getParameter("id").getBytes("ISO8859-1"),"GBK");
//String name = new String(request.getParameter("name").getBytes("ISO8859-1"),"GBK");
//String sex = new String(request.getParameter("sex").getBytes("ISO8859-1"),"GBK");
//String grade = new String(request.getParameter("grade").getBytes("ISO8859-1"),"GBK");String sql = "update user set id = '"+id+"',name='"+name+"',sex='"+sex+"',grade="+grade+" where id='"+id+"'";if(stmt.execute(sql))
out.println("数据修改成功!");
else out.println("数据类型错误或未知错误!"); stmt.close();
conn.close();
}catch(SQLException e){
out.println("丫的又错了……");
} %>
<strong><font face="微软雅黑"><br><a href="manager.jsp">点击此处返回管理页面!</a></font>
</strong>
</body>
</html>
解决方案 »
- dwr框架技术?
- 初学struts2帮帮忙!!!helloworld程序我的struts2为什么总是出现404错误!!!
- struts2.0显示日期的标签问题
- hibernateTemplate好像不能删除主键不为Id的数据,求解决?
- 大侠请进!!!
- 使用Class类和Method类怎样获取一个类的某一个有参数的静态方法并激活它?
- JSP调用存储过程返回的结果集为什么不支持last(),beforefirst(),absoulte()等方法.
- 请教一问题:jsp中作用"范围"(page, session, application)之间有什么区别?
- 在线等:怎样显示一个不带菜单、工具栏等的简洁页面?
- 哪有ms sql server的支持中文gb2312的jdbc驱动程序,要免费的,不能是试用版?
- 如何添加和删除xml文件?
- servlte无法使用的问题
out.println("数据修改成功!");
else out.println("数据类型错误或未知错误!");
由上面那段代码应该是sql语句出了问题,楼主最好控制台打印出sql语句放进数据库检查下
String name = request.getParameter("name");
String sex = request.getParameter("sex");
String grade = request.getParameter("grade");
或者是数据库字段和这里的不一致
或者dedug下...
把那条插入的sql复制到数据库中
执行这条sql看有问题不?
String sql = "update user set id = '"+id+"',name='"+name+"',sex='"+sex+"',grade='"+grade+"' where id='"+id+"'";