mysql資料庫__Jdbc直接操作__PreparedStatement__Database Backup

標籤：learn   cti   red   back   pre   class   void   nic   jdb   

一、代碼如下

private void BackupDatabase() {// TODO Auto-generated method stubjava.sql.PreparedStatement ps = null;java.sql.Connection cn = null;ResultSet rs = null;try {// Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");Class.forName("com.mysql.jdbc.Driver").newInstance();cn = DriverManager.getConnection("jdbc:mysql://localhost:3306/learn?user=root&password=&useUnicode=true&characterEncoding=UTF8");ps = cn.prepareStatement("backup database learn to disk=‘d:/12345.bak‘");int i= ps.executeUpdate();System.out.println(i);if(i>=1) {System.out.println("Database Backup：成功");}else {System.out.println("Database Backup：失敗");}} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();} finally {try {ps.close();cn.close();} catch (SQLException e) {e.printStackTrace();}}}

 

mysql資料庫__Jdbc直接操作__PreparedStatement__Database Backup