错误如下:
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());
}
%>
数据库如下:
谢谢各位大神了,小学生在此衷心愿各位大神身体健康,美满幸福。