java 自动创建数据库,安装web项目的类.docVIP

java 自动创建数据库,安装web项目的类 package com.jeecms.cms; import static mon.web.Constants.UTF8; import java.io.BufferedReader; import java.io.File; import java.io.FileInputStream; import java.io.InputStreamReader; import java.sql.Connection; import java.sql.DriverManager; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import mons.io.FileUtils; import mons.lang.StringUtils; /** * 安装类 * * @author liufang * */ public class Install { public static void dbXml(String fileName, String dbHost, String dbPort, String dbName, String dbUser, String dbPassword) throws Exception { String s = FileUtils.readFileToString(new File(fileName)); s = StringUtils.replace(s, DB_HOST, dbHost); s = StringUtils.replace(s, DB_PORT, dbPort); s = StringUtils.replace(s, DB_NAME, dbName); s = StringUtils.replace(s, DB_USER, dbUser); s = StringUtils.replace(s, DB_PASSWORD, dbPassword); FileUtils.writeStringToFile(new File(fileName), s); } public static Connection getConn(String dbHost, String dbPort, String dbName, String dbUser, String dbPassword) throws Exception { Class.forName(com.mysql.jdbc.Driver); Class.forName(com.mysql.jdbc.Driver).newInstance(); String connStr = jdbc:mysql:// + dbHost + : + dbPort + / + dbName + ?user= + dbUser + password= + dbPassword + characterEncoding=utf8; Connection conn = DriverManager.getConnection(connStr); return conn; } public static void webXml(String fromFile, String toFile) throws Exception { FileUtils.copyFile(new File(fromFile), new File(toFile)); } /** * 创建数据库 * * @param dbHost * @param dbName * @param dbPort * @param dbUser * @param dbPassword * @throws Exception */ public static void createDb(String dbHost, String dbPort, String dbName, String dbUser, String dbPassword) throws Exception { Class.forName(com.mysql.jdbc.Driver); Class.forName(com.mysql.jdbc.Driver).newInstance(); String connStr = jdbc:mysql:// + dbHost + : + dbPort + ?user= + dbUser +