com.microsoft.sqlserver.jdbc.SQLServerException: ',' 附近有语法错误。

star是小丸子 2012-12-30 12:58:46

com.microsoft.sqlserver.jdbc.SQLServerException: ',' 附近有语法错误。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(SQLServerStatement.java:642)
at org.apache.jsp.student.student_005fconf_jsp._jspService(student_005fconf_jsp.java:105)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:619)

代码如下：
<%@ page language="java" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML><BODY bgcolor=pink>
<%
request.setCharacterEncoding("utf-8") ;
// 接收参数
//String id = request.getParameter("studnetId").trim();
String name = request.getParameter("studentName").trim();
String sex = request.getParameter("studentSex").trim();
//int age = Integer.parseInt(request.getParameter("studentAge"));
String diploma =request.getParameter("studentDiploma").trim();
String school = request.getParameter("studentSchool").trim();
String major = request.getParameter("internshipMajor").trim();
String grade = request.getParameter("studentClass").trim();
String phone = request.getParameter("studentPhone").trim();
String email = request.getParameter("studentEmail").trim();
%>

<%!
String DBDRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver" ;
String DBURL = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=jobManagement" ;
String DBUSER = "meilingzi" ;
String DBPASSWORD = "123" ;
Connection conn = null ;
Statement stmt = null ;
//ResultSet rs = null ;
%>

<%

try
{
Class.forName(DBDRIVER) ;
}
catch(Exception e1)
{
e1.printStackTrace() ;
}
try{
conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD) ;
System.out.println("1");
stmt=conn.createStatement();
System.out.println("4");
//String sql = "insert into student(student_id,studnet_name,studnet_sex,studnet_age,studnet_diploma,studnet_school,studnet_grade,studnet_phone,studnet_email) values('"+id+"','"+name+"','"+sex+"','"+age+"','"+diploma+"','"+school+"','"+grade+"','"+phone+"','"+email+"') WHERE student_id='"+id+"'";
String sql="update student,major set studnet_name='"+name+"',studnet_sex='"+sex+"',studnet_diploma='"+diploma+"',studnet_school='"+school+"',studnet_grade='"+grade+"',studnet_phone='"+phone+"',studnet_email='"+email+"',major_name='"+major+"' where student.major_id = major.major_id";
//rs=stmt.executeUpdate(sql);
stmt.executeUpdate(sql);
System.out.println("2");
System.out.println("jfdjfso");
conn.close();
System.out.println("3");
}
catch(Exception e)
{
e.printStackTrace() ;
}
%>

</BODY>
</HTML>

...全文