大家帮帮看看那里的问题?
我想将数据库的一个表里的数据存到另一个表里,语言JSP,数据库为SQL2000
代码:
<%
String sqlString= "update monTable set monTable.sort_number=qicaiTable.sort_number,monTable.e_name=qicaiTable.e_name,
monTable.e_size=qicaiTable.e_size,monTable.unit=qicaiTable.unit,monTable.endm=qicaiTable.amount from monTable,qicaiTable " ;
try
{ Connection con;
Statement sql;
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver ");
con=DriverManager.getConnection( "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=shangdianDB ", "sa ", " ");
sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
sql.executeUpdate(sqlString);
con.close();
}
catch(
SQLException e1)
{
out.print(e1);
}
%>
提示出错,
An error occurred at line: 10 in the jsp file: /shd/stat/mon.jsp
Generated servlet error:
String literal is not properly closed by a double-quote
org.apache.jasper.servlet.JspServletWrapper.handle
JspException(JspServletWrapper.java:510)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
小弟初学,请大家指点下,谢谢了!
------解决方案--------------------String sqlString= "update monTable set monTable.sort_number=qicaiTable.sort_number,monTable.e_name=qicaiTable.e_name,
monTable.e_size=qicaiTable.e_size,monTable.unit=qicaiTable.unit,monTable.endm=qicaiTable.amount from monTable,qicaiTable " ;
---------------------------------------------
String sqlString= "update monTable set " + "monTable.sort_number=qicaiTable.sort_number,monTable.e_name=qicaiTable.e_name, "
+ "monTable.e_size=qicaiTable.e_size,monTable.unit=qicaiTable.unit, "
+ "monTable.endm=qicaiTable.amount from monTable,qicaiTable " ;