分类:
2008-03-07 10:26:22
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=sha";
String user="sa";
String password="123456";
Connection conn= DriverManager.getConnection(url,user,password);
try{
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql="backup database sha to disk='d:\\xncback.dat'";
stmt.executeQuery(sql);
}
catch(SQLException e){ System.out.println(e.toString());}
catch(Exception e){ System.out.println(e.toString());}
%>