java swing开发好关系软数据库代码基本信息.docVIP

package com.kehuglxt.swing1; import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.Statement; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Date; import java.util.List; import com.java2012.Style.Book; import com.java2012.shujuku.Updutebook; public class Khshujujdbc { Connection conn = null; public Connection getconn() { try { Class.forName(com.mysql.jdbc.Driver); } catch (ClassNotFoundException e) { // TODO: handle exception e.printStackTrace(); } String url = jdbc:mysql://127.0.0.1:3306/kuhuguangxi; String useName = root; String password = admin; try { conn = DriverManager.getConnection(url, useName, password); if (conn != null) { System.out.println(连接数据库成功); } } catch (Exception e) { // TODO: handle exception e.printStackTrace(); } return conn; } public List getDatabuse() { List list = new ArrayList(); conn = getconn(); PreparedStatement prStatement; String mysql1 = show databases; try { prStatement = conn.prepareStatement(mysql1); ResultSet resultset = prStatement.executeQuery(); while (resultset.next()) { list.add(resultset.getString(1)); } } catch (Exception e) { // TODO: handle exception e.printStackTrace(); } return list; } public boolean mysqldump(String database, String path) { try { Process p = Runtime.getRuntime().exec( cmd.exe /c mysqldump -h127.0.0.1 -uroot -padmin + database + + path + ); // 定义进行数据备份的语句 StringBuffer out1 = new StringBuffer(); // 定义字符串缓冲对象 byte[] b = new byte[1024]; // 定义字节数组 for (int i; ((i = p.getInputStream().read(b))) != -1;) { // 将数据写入到指定文件中 out1.append(new String(b, 0, i)); // 向流中追加数据 } } catch (IOException e) { e.printStackTrace(); return false; } return true; } public boolean mysql(String database, String path) { try { Process p = Runtime.getR