
<meta http-equiv=“refresh” content=“3;URL=install/index.html”/>
您还没有安装JEECMS,3秒钟之后手动跳转到安装页面。<br/>
如果您的浏览器长时间没有反应,请直接点击<a href=“install/index.html”>JEECMS安装</a>。
install/index.html:一般是同意安装页
<script type=“text/javascript”>
function formSubmit() {
if(document.getElementById(‘license_agree’).checked==false){
alert(‘请同意我们的协议‘);
return false;
}
document.getElementById(‘license_form’).submit();
}
</script>
<form id=“license_form” action=“install_params.jsp” method=“post”>
<input type=“button” class=“btn” onclick=“formSubmit();” value=“下一步 >”/>
进入安装和参数页:
<form action=“install_setup.jsp” method=“post” onsubmit=“return formSubmit();”>
<tr>
<td height=“30″ align=“right”>域名:</td>
<td align=“left”><input name=“domain” type=“text” class=“input” value=“<%=request.getServerName()%>“/></td>
<td align=“left”>系统已经评估出您的域名,请勿改动</td>
</tr>
<tr>
<td height=“30″ align=“right”>部署路径:</td>
<td align=“left”><input name=“cxtPath” type=“text” class=“input” value=“<%=request.getContextPath()%>“/></td>
<td align=“left”>系统即将测试出您的推进模式,请勿改动</td>
</tr>
安装:
<%@page contentType=“text/html; charset=gbk” language=“java” import=“com.jeecms.core.util.*,java.util.*”%>
<%
String dbFileName = “/install/db/jeecms-db-2.4.2-final.sql”;
String initFileName = “/install/db/jeecms-init-2.4.2-final.sql”;
//创建
if (“true”.equals(isCreateDb)) {
Install.createDb(dbHost, dbPort, dbName, dbUser, dbPassword);
} else {
Install.changeDbCharset(dbHost, dbPort, dbName, dbUser, dbPassword);
}
//创建表
if (“true”.equals(isCreateTable)) {
String sqlPath = application.getRealPath(dbFileName);
List<String> sqlList = Install.readSql(sqlPath);
Install.createTable(dbHost, dbPort, dbName, dbUser, dbPassword,
sqlList);
}
//初始化数据
if (“true”.equals(isInitData)) {
String initPath = application.getRealPath(initFileName);
List<String> initList = Install.readSql(initPath);
Install.createTable(dbHost, dbPort, dbName, dbUser, dbPassword,
initList);
}
//更新配置
Install.updateConfig(dbHost, dbPort, dbName, dbUser, dbPassword,
domain, cxtPath, port);
//处理配置文件
String dbXmlPath = application.getRealPath(dbXmlFileName);
Install
.dbXml(dbXmlPath, dbHost, dbPort, dbName, dbUser,
dbPassword);
//处理web.xml
String webXmlFromPath = application.getRealPath(webXmlFrom);
String webXmlToPath = application.getRealPath(webXmlTo);
Install.webXml(webXmlFromPath, webXmlToPath);
//在Util里面
/**
*安装类
*
*@author admin
*
*/
publicclass Install {
publicstaticvoid dbXml(String fileName, String dbHost, String dbPort,
String dbName, String dbUser, String dbPassword) throws Exception {
String s = FileUtils.readFileToString(new File(fileName));
s = s.replaceFirst(“DB_HOST”, dbHost);
s = s.replaceFirst(“DB_PORT”, dbPort);
s = s.replaceFirst(“DB_NAME”, dbName);
s = s.replaceFirst(“DB_USER”, dbUser);
s = s.replaceFirst(“DB_PASSWORD”, dbPassword);
FileUtils.writeStringToFile(new File(fileName), s);
}
publicstatic Connection getConn(String dbHost, String dbPort,
String dbName, String dbUser, String dbPassword) throws Exception {
Class.forName(“com.mysql.jdbc.Driver”).newInstance();
String connStr = “jdbc:mysql://” + dbHost + “:” + dbPort + “/” + dbName
+ “?user=” + dbUser + “&password=” + dbPassword
+ “&characterEncoding=GBK”;

Connection conn = DriverManager.getConnection(connStr);
return conn;
}
publicstaticvoid webXml(String fromFile, String toFile) throws Exception {
FileUtils.copyFile(new File(fromFile), new File(toFile));
}
/**
*创建
*
*@paramdbHost
*@paramdbName
*@paramdbPort
*@paramdbUser
*@paramdbPassword
*@throwsException
*/
publicstaticvoid createDb(String dbHost, String dbPort, String dbName,
String dbUser, String dbPassword) throws Exception {
Class.forName(“com.mysql.jdbc.Driver”).newInstance();;
String connStr = “jdbc:mysql://” + dbHost + “:” + dbPort + “?user=”
+ dbUser + “&password=” + dbPassword + “&characterEncoding=GBK”;
Connection conn = DriverManager.getConnection(connStr);
Statement stat = conn.createStatement();
String sql = “drop database if exists “ + dbName;
stat.execute(sql);
sql = “create database “ + dbName
+ ” CHARACTER SET GBK”;
stat.execute(sql);
stat.close();
conn.close();
}
publicstaticvoid changeDbCharset(String dbHost, String dbPort,
String dbName, String dbUser, String dbPassword) throws Exception {
Connection conn = getConn(dbHost, dbPort, dbName, dbUser, dbPassword);
Statement stat = conn.createStatement();
String sql = “ALTER DATABASE “ + dbName
+ ” CHARACTER SET GBK”;
stat.execute(sql);
stat.close();
conn.close();
}
/**
*创建表
*
*@paramdbHost
*@paramdbName
*@paramdbPort
*@paramdbUser
*@paramdbPassword
*@paramsqlList
*@throwsException
*/
publicstaticvoid createTable(String dbHost, String dbPort, String dbName,
String dbUser, String dbPassword, List<String> sqlList)
throws Exception {
Connection conn = getConn(dbHost, dbPort, dbName, dbUser, dbPassword);
Statement stat = conn.createStatement();
本文来自电脑杂谈,转载请注明本文网址:
https://www.pc-fly.com/a/ruanjian/article-121307-1.html
丑得我不要不要的作