错误如下:
131110002
131110002
wjj
com.microsoft.sqlserver.jdbc.SQLServerException: 列名或所提供值的数目与表定义不匹配。
代码如下:
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.Random"%>
<%@ page import="java.util.Date"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
Insert title here
=tradeMoney){ Random tradeNum = new Random(1000); Date tradeDate = new Date(); String condition1 = "insert into trade values"+"("+"'" + tradeNum + "','" + loginID + "','" + tradeMoney + "','"+ tradeDate + "','O')"; stmt.executeUpdate(condition1); String condition7 = "insert into trade values"+"("+"'" + loginID + "','" + tradeNum + "','" + tradeMoney + "','"+ tradeDate + "','I')"; stmt.executeUpdate(condition7); String condition2 = "update balance set balancemoney=balancemoney-'" + tradeMoney + "' where loginID='" + loginID + "'"; stmt.executeUpdate(condition2); String condition8 = "update balance set balancemoney=balancemoney+'" + tradeMoney + "' where loginID='" + tradeNum + "'"; stmt.executeUpdate(condition8); out.print("转账成功"); } else{ out.print("余额不足"); } } } catch (SQLException sqle) { System.out.println(sqle.toString()); } %>
返回
数据库如下:


谢谢各位大神了,小学生在此衷心愿各位大神身体健康,美满幸福。
insert into 表名 values(),这种形式的语句需要每个参数和表中的字段都匹配上 而且顺序不能错