想更新mysql数据库中表money的中用户00的money列,不知道哪里不对
想更新mysql数据库中表money的中用户00的money列,不知道哪里不对
//设置提交表单的中文编码
request.setCharacterEncoding("GBK");
//获取用户输入表单
//准备插入语句
String insertquery = "UPDATE money SET money = money+5000 WHERE username ='00' ";
try
{
//获取数据库链接
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost/wow?user=root&password=root");
//创建statement
stmt = conn.createStatement();
//执行查询
rs = stmt.executeQuery(query);
//执行上面的sql
stmt.executeUpdate(insertquery);
}
catch(ClassNotFoundException e)
{
out.print(e.getMessage());
}
finally
{
//关闭数据库链接
stmt.close();
conn.close();
}
%>
展开