请问这是什么错误(数据源应该没问题)?java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]COUNT 栏位不正确
<%@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>
<%@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>
...全文
相关推荐
Microsoft SQL Server JDBC Driver 2.0
Microsoft SQL Server JDBC Driver 2.0 提供两个类库文件:sqljdbc.jar 和 sqljdbc4.jar。
Microsoft SQL Server 2005 JDBC Driver
SQL Server 2005 JDBC 驱动 压缩包内包含三个jar文件,分别是三个版本,我用的sqljdbc1.2.jar,使用的时候需要注意的是2000与2005的url和驱动全限定名是不同的
JSP用JDBC-ODBC连接SQL Server和Mysql和JDBC驱动连接各种数据库
JSP用JDBC-ODBC连接SQL Server和Mysql和JDBC驱动连接各种数据库
Microsoft SQL Server 2000 Driver for JDBC在MyEclipse中的使用方法
Microsoft SQL Server 2000 Driver for JDBC在MyEclipse中的使用方法
JDBC连接SQL Server2008具体步骤
1:详细介绍了通过eclipse或myeclipse通过jdbc驱动连接SQL Server2008数据库的步骤, 2:如何配置ODBC数据源 3:如何配置SQL Server2008来使Myeclipse连接数据库成功 4:遇到sa用户登录失败的解决办法。 全部属于个人遇到的实际问题和解决办法,解决广大java初学者遇到的问题。


Web 开发
