我想将数据库的一个表里的数据存到另一个表里,语言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.handleJspException(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" ;
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.handleJspException(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)
小弟初学,请大家指点下,谢谢了!
解决方案 »
- java如何实现报表?
- jsp页面出NullPointerException
- 怎么把服务器端的用户信息先存储再发送到客户端?
- jc中的值传递,急
- 如果用户未登陆访问其他页面时就跳转到login.jsp页面,在web.xml中怎样配置?
- 如何判断客户端是否安装软件
- 高手帮忙啊
- 为什么我在数据库里增加了记录,但是在页面里显示的还是原来没有增加时的记录?怎样解决?
- 已有的jsp文件及javabean怎么放进jbuilder6里面调试
- 谁可以给我说清楚asp和servlet的区别?!!!!!!!!!!!!!!!!1!!!!!!!!!!!!!!
- 我用struts开发,现在想用链接来提交表单,应该怎么实现?
- 一个实现STRUTS的JAVABEAN的问题
第十行有问题
这两句应该在一行上,你分行了。
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" ;