Java连接SqlServer2008,执行备份和恢复
来源:互联网 发布:sql显示前10行 编辑:程序博客网 时间:2024/05/30 04:30
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.text.SimpleDateFormat;
public class SqlServer {
public SqlServer(){}
public static void main(String[] args) {
if(args.length==1){
System.out.println("Contect to dbserver");
try
{
String dburl = "jdbc:sqlserver://localhost:1433; DatabaseName=master";
String dburl2 = "jdbc:sqlserver://localhost:1433; DatabaseName=minioa";
Class.forName( "com.microsoft.sqlserver.jdbc.SQLServerDriver" );
Connection conn = DriverManager.getConnection(dburl, "sa", "password" );
Connection conn2 = DriverManager.getConnection(dburl2, "sa", "password" );
Statement st = conn.createStatement();
System.out.println("Contect to dbserver successed!");
//关闭MiniOA的数据库回话连接
ResultSet rs = st.executeQuery("SELECT spid FROM sysprocesses WHERE (dbid IN (SELECT dbid FROM sysdatabases WHERE name = 'minioa'))");
int spid = 0;
while(!rs.isClosed()){
rs.next();
spid = Integer.valueOf(String.valueOf(rs.getObject(1)));
st.executeUpdate("kill " + spid);
System.out.println("Kill contenction " + spid);
}
rs.close();
String path = System.getProperty("user.dir");
//在 当前目录备份数据库
if("backup".equals(args[0])){
st.executeUpdate("use master backup database minioa to disk='"+ path +"\\minioa.mdf'");
System.out.println("Backup completed!");
}
//在当前目录回复数据库
if("restore".equals(args[0])){
st.executeUpdate("use master restore database minioa from disk='"+ path +"\\minioa.mdf'");
System.out.println("Restore completed!");
}
conn.close();
}catch(Exception ex){System.out.println("Contect to dbserver faield!");ex.printStackTrace();}
}else
System.out.println("Please input parameter, backup or restore");
}
}
代码下载:
http://www.minioa.net/viewtopic.php?f=13&t=112
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.text.SimpleDateFormat;
public class SqlServer {
public SqlServer(){}
public static void main(String[] args) {
if(args.length==1){
System.out.println("Contect to dbserver");
try
{
String dburl = "jdbc:sqlserver://localhost:1433; DatabaseName=master";
String dburl2 = "jdbc:sqlserver://localhost:1433; DatabaseName=minioa";
Class.forName( "com.microsoft.sqlserver.jdbc.SQLServerDriver" );
Connection conn = DriverManager.getConnection(dburl, "sa", "password" );
Connection conn2 = DriverManager.getConnection(dburl2, "sa", "password" );
Statement st = conn.createStatement();
System.out.println("Contect to dbserver successed!");
//关闭MiniOA的数据库回话连接
ResultSet rs = st.executeQuery("SELECT spid FROM sysprocesses WHERE (dbid IN (SELECT dbid FROM sysdatabases WHERE name = 'minioa'))");
int spid = 0;
while(!rs.isClosed()){
rs.next();
spid = Integer.valueOf(String.valueOf(rs.getObject(1)));
st.executeUpdate("kill " + spid);
System.out.println("Kill contenction " + spid);
}
rs.close();
String path = System.getProperty("user.dir");
//在 当前目录备份数据库
if("backup".equals(args[0])){
st.executeUpdate("use master backup database minioa to disk='"+ path +"\\minioa.mdf'");
System.out.println("Backup completed!");
}
//在当前目录回复数据库
if("restore".equals(args[0])){
st.executeUpdate("use master restore database minioa from disk='"+ path +"\\minioa.mdf'");
System.out.println("Restore completed!");
}
conn.close();
}catch(Exception ex){System.out.println("Contect to dbserver faield!");ex.printStackTrace();}
}else
System.out.println("Please input parameter, backup or restore");
}
}
代码下载:
http://www.minioa.net/viewtopic.php?f=13&t=112
- Java连接SqlServer2008,执行备份和恢复
- 恢复sqlserver2008备份,恢复数据
- chapter9:执行备份和恢复
- 第 9 章:执行备份和恢复
- java mysql备份和恢复
- JAVA ODBC 连接SQLSERVER2008
- JAVA 连接 SQLServer2008
- java 连接sqlserver2008 demo
- java连接sqlserver2008数据库
- JAVA连接sqlserver2008 r2
- java连接SqlServer2008
- java连接SqlServer2008
- JAVA 连接SqlServer2008数据库
- Java连接SqlServer2008数据库
- java 连接 sqlServer2008 图文详解
- java 连接 sqlServer2008 图文详解
- java备份和恢复MySQL数据实例
- java Mysql 数据库备份和恢复
- Usaco 1.2.4 回文平方数(Palindromic Squares)
- 关于java的初始化顺序
- v8 js 转载!~简介!~
- ie php上传图片 判定类型
- Activity的四种加载模式-转载自www.ligoto.com网站
- Java连接SqlServer2008,执行备份和恢复
- SWT屏蔽控件的某鼠标或键盘事件
- C99的新特性
- 在Windows Server 2008下安装Oracle 10g
- 软件测试
- linux中显示中文乱码的问题
- 简易统计计算器——C++版
- KI码
- Usaco 1.5.2 回文质数(Prime Palindromes)