请问这是什么错误(数据源应该没问题)?java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]COUNT 栏位不正确

lci21 lci21 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
<%@page contentType="text/html;charset=GB2312"%>
<%@page import="java.sql.*,com.convert.Convert"%>
<%@include file="yz.jsp"%>
<HTML>
<HEAD>
</HEAD>
<BODY>
<%

String username=request.getParameter("username");
//out.println(username);
String dept=request.getParameter("dept");
String post=request.getParameter("post");
String contents=request.getParameter("contents");
String cmoney=request.getParameter("cmoney");
String timeper=request.getParameter("timeper");
String complete=request.getParameter("complete");
String behave=request.getParameter("behave");
String cdate=request.getParameter("cdate");

username=Convert.getString(username);
dept=Convert.getString(dept);
post=Convert.getString(post);
contents=Convert.getString(contents);
cmoney=Convert.getString(cmoney);
timeper=Convert.getString(timeper);
complete=Convert.getString(complete);
behave=Convert.getString(behave);
cdate=Convert.getString(cdate);
/*
out.println("(userid="+userid+")<br>");
out.println("(dept="+dept+")<br>");
out.println("(post="+post+")<br>");
out.println("(contents="+contents+")<br>");
out.println("(cmoney="+cmoney+")<br>");
out.println("(ctimeper="+timeper+")<br>");
out.println("(complete="+complete+")<br>");
out.println("(behave="+behave+")<br>");
out.println("(cdate="+cdate+")<br>");
out.println("(userid="+userid+")<br>");
*/
%>
<%
if((username.length()==0)||(contents.length()==0))
%>
<script language="vbscript">
msgbox "对不起,姓名和工作内容不得为空!",64,"提交失败"
location.href="javascript:history.back(1)"
</script>
<%
else{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:work_notes";
Connection con=DriverManager.getConnection(url,"lci","");
PreparedStatement insert_stm=con.prepareStatement("insert into notes values(?,?,?,?,?,?,?,?,?,?,?)");

insert_stm.setString(1,userid);

insert_stm.setString(2,dept);
insert_stm.setString(3,cdate);

insert_stm.setString(5,contents);

insert_stm.setString(6,cmoney);
insert_stm.setString(7,timeper);
insert_stm.setString(8,complete);
insert_stm.setString(9,behave);
//insert_stm.setString(9,"dremark");
//insert_stm.setString(10,"remark");
//insert_stm.setString(11,"");
out.println("hi1<br>");

try{
out.println("hi2<br>"); //调试时此处能输出hi2
insert_stm.executeUpdate();
out.println("hi2<br>"); //此处什么也没有输出
}catch(Exception e) {out.println(e);}
//con.close();

%>
<!--
<script language="vbscript">
msgbox "提交成功,谢谢!",64,"提交成功"
location.href="javascript:history.back(1)"
</script>
-->
<%
}catch(Exception e){}
}
%>
<P> </P>

</BODY>
</HTML>
...全文
评论 2
收藏 已收藏
分享
返回顶部
lci21
Web 开发 81,108 成员 341,721 内容