我一运行就很长时间在打开浏览器,根本没结果,一直就处于打开浏览器的情况中<%@ page contentType="text/html; charset=gb2312" language="java"import="java.sql.*,java.io.*"%>
<%@ page import="DBcon.dbconn"%>
<jsp:useBean id="DBcon"scope="page"class="DBcon.dbconn"/>
以下是插入Ms SQL Server2000数据库的数据:
<%Connection conn = null;
conn = DBcon.getConn() ;
try{
String sql="backup database publish to disk='C:\Tomcat 5.5\webapps\myapp\backupDB\pub_bak.dat'"; st=con.createStatement();
rs=st.executeQuery(sql); }
catch(SQLException e){ System.out.println(e.toString());}
catch(Exception e){ System.out.println(e.toString());}
conn.close();
%>
<%@ page import="DBcon.dbconn"%>
<jsp:useBean id="DBcon"scope="page"class="DBcon.dbconn"/>
以下是插入Ms SQL Server2000数据库的数据:
<%Connection conn = null;
conn = DBcon.getConn() ;
try{
String sql="backup database publish to disk='C:\Tomcat 5.5\webapps\myapp\backupDB\pub_bak.dat'"; st=con.createStatement();
rs=st.executeQuery(sql); }
catch(SQLException e){ System.out.println(e.toString());}
catch(Exception e){ System.out.println(e.toString());}
conn.close();
%>
在输入文件路径按Enter运行后,页面维持输入文件路径之前的样子,一直在打开中
-------------------------------------------------------------
新手,如有不对,请指点!
我太粗心了
修改后
<%@ page contentType="text/html; charset=gb2312" language="java"import="java.sql.*,java.io.*"%>
<%@ page import="DBcon.dbconn"%>
<jsp:useBean id="DBcon"scope="page"class="DBcon.dbconn"/>
以下是插入Ms SQL Server2000数据库的数据:
<%
ResultSet rs = null;
Connection conn = null;
conn = DBcon.getConn() ;
try{
String sql="backup database publish to disk='C:\Tomcat 5.5\webapps\myapp\backupDB\pub_bak.dat'";
rs=DBcon.executeQuery(sql); }
catch(SQLException e){ System.out.println(e.toString());}
catch(Exception e){ System.out.println(e.toString());}
conn.close();
%>错误提示
org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 5 in the jsp file: /Example/backup.jsp
Generated servlet error:
Invalid escape sequence (valid ones are \b \t \n \f \r \" \' \\ )
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)
<%@ page contentType="text/html; charset=gb2312" language="java"import="java.sql.*,java.io.*"%>
<%@ page import="DBcon.dbconn"%>
<jsp:useBean id="DBcon"scope="page"class="DBcon.dbconn"/>
以下是插入Ms SQL Server2000数据库的数据:
<%
ResultSet rs = null;
Connection conn = null;
conn = DBcon.getConn() ;
rs=DBcon.executeQuery
("backup database publishtodisk='C:\\mydb.bak'withname='pubbak'");
%>
但是我想这样如果真 (数据库连接1.执行SQL (“BACKUP DATABASE 数据库名 TO DISK = '备份数据库名称' WITH INIT”) = 真)
信息框 (“数据库备份成功”, 0, )
返回 ()
如果假结束
信息框 (“备份失败”, 0, )怎么写?