📄 1179.html
字号:
`SOLVER` varchar(64) NOT NULL default '0',<br>
`SOLVER_METHOD` text NOT NULL,<br>
`OLD_CODE` text NOT NULL,<br>
`NEW_CODE` text NOT NULL,<br>
`REFERENCE_ID` int(11) unsigned NOT NULL default '0',<br>
`FILENAME` varchar(40) NOT NULL default '',<br>
`PRODUCTION_CODE` varchar(40) NOT NULL default '',<br>
`PROJECT_CODE` varchar(40) NOT NULL default '',<br>
`MODULE_CODE` varchar(40) NOT NULL default '',<br>
PRIMARY KEY (`ID`)<br>
) ;<br>
<br>
CREATE TABLE `PERMISSION` (<br>
`ACTOR_NAME` varchar(20) NOT NULL default '',<br>
`FIELDNAME` varchar(20) NOT NULL default '',<br>
`PERMISSION` int(11) unsigned NOT NULL default '0'<br>
); <br>
<br>
CREATE TABLE `PERSONNEL` (<br>
`ID` varchar(64) NOT NULL default '',<br>
`PASSWORD` varchar(20) NOT NULL default '',<br>
`TNAME` varchar(20) NOT NULL default '',<br>
`DESCRIPTION` varchar(200) NOT NULL default '',<br>
`MAIL` varchar(64) default '',<br>
`NUMBER` varchar(4) NOT NULL default '',<br>
`PHONE` varchar(11) NOT NULL default '',<br>
PRIMARY KEY (`ID`)<br>
); <br>
<br>
CREATE TABLE `PROJECT` (<br>
`NAME` varchar(20) NOT NULL default '',<br>
`CODE` varchar(40) NOT NULL default '',<br>
`DESCRIPTION` varchar(200) NOT NULL default '',<br>
`TYPE` int(11) NOT NULL default '0',<br>
`FPROJECT` varchar(40) NOT NULL default '',<br>
PRIMARY KEY (`CODE`)<br>
); <br>
<br>
CREATE TABLE `TEAM` (<br>
`PERSONNEL_ID` varchar(64) NOT NULL default '',<br>
`PROJECT_CODE` varchar(40) NOT NULL default '',<br>
`ACTOR_NAME` varchar(20) NOT NULL default '',<br>
`DESCRIPTION` varchar(200) NOT NULL default ''<br>
); <br>
6. Java环境的安装及配置<br>
6.1.Java环境的安装<br>
安装j2sdk<br>
shell> rpm -ivh j2sdk-1_4_0-fcs-linux-i386.rpm<br>
6.2.Java 环境的配置<br>
24.Java及Resin环境变量的设置<br>
shell> vi /etc/profile<br>
在文件后加上如下几句：<br>
export JAVA_HOME=/usr/java/j2sdk1.4.0<br>
export RESIN_HOME=/usr/local/resin<br>
export CLASSPATH=$CLASSPATH:$JAVA_HOME/lib:$JAVA_HOME/jre/lib<br>
export<br>
PATH=$PATH:$JAVA_HOME/bin:$JAVA_HOME/jre/bin:/usr/local/mysql/bin:/usr/local/apache/bin:/usr/local/resin/bin<br>
2．重启机器以使环境变量的设置生效<br>
shell>reboot<br>
7. Resin的安装及配置<br>
7.1.Resin的安装<br>
shell>tar xvfz resin-2.1.6.tar.gz -C /usr/local<br>
shell>cd /usr/local<br>
shell>mv resin-2.1.6 resin<br>
shell>cd resin<br>
shell>./configure -with-apache=/usr/local/apache<br>
shell>make<br>
shell>make install<br>
7.2.Resin的配置<br>
25.为了使reisn能自动启动及关闭，需要做以下几步：<br>
shell>cd /etc/rc.d/init.d<br>
shell>cp /usr/local/resin/contrib/init.resin resin<br>
shell>chkconfig resin reset <br>
因为resin启动较慢，在自动启动时需要停留一会以免别的自启动程序将其弄崩溃，则需要改动/etc/rc.d/init.d/resin文件，在fi行后加上加上一句sleep 15，可以用如下语句实现：<br>
shell>sed 's/ fi/&<br>
sleep 15/' resin > resin.bak<br>
shell>mv –f resin.bak resin<br>
shell>chmod +x resin<br>
26. 修改resin的设置使其可以和Apache连接，其将在Apache的htdocs目录下加入 WEB-INF目录。<br>
shell>cd /usr/local/resin/conf<br>
shell>vi resin.conf<br>
将<doc-dir>doc</doc-dir>改为<doc-dir>/usr/local/apache/htdocs</doc-dir><br>
27. 在resin的库中加入最新的MySQL的JDBC包<br>
shell>cp /root/itssetup/ mysql-connector-java-2.0.14-bin.jar /usr/local/resin/lib<br>
28. 修改resin的设置使其可以和MySQL连接<br>
shell>cd /usr/local/resin/conf<br>
shell>vi resin.conf<br>
在其中加入以下几行：<br>
<resource-ref><br>
<res-ref-name>jdbc/itdb</res-ref-name><br>
<res-type>javax.sql.DataSource</res-type><br>
<init-param driver-name="org.gjt.mm.mysql.Driver"/><br>
<init-param url="jdbc:mysql://192.168.18.235:3306/itdb"/><br>
<init-param user="root"/><br>
<init-param password="123456"/><br>
<init-param max-connections="20"/><br>
<init-param max-idle-time="30"/><br>
</resource-ref><br>
29.启动resin<br>
shell>/etc/rc.d/init.d/resin start<br>
8.Apache动态加载JSP模块<br>
shell>cd /usr/local/apache/conf<br>
shell>vi httpd.conf<br>
30.Resin安装后在Apache中加载了caucho模块，添加了LoadModule和AddModule两句话，我们需要将AddModule mod_caucho.c这句注掉，前面加＃，因为高版本apache只需要LoadModule就已经加载模块了。<br>
31.在最后加上如下几句：<br>
<IfModule mod_caucho.c><br>
CauchoConfigFile /usr/local/resin/conf/resin.conf<br>
</IfModule> <br>
32.重启Apache<br>
shell>/etc/rc.d/init.d/apache restart<br>
9.数据库数据的备份<br>
为了防止数据的误操作引起的数据丢失或崩溃，创建后台任务每天凌晨2点备份数据库数据：<br>
33.在用户weiqiong目录下创建子目录itdb1，itdb2，itdb3，itdb4，itdb5，itdb6和itdb0，分别备份一个星期的数据库：<br>
shell>mkdir /home/weiqiong/itdb1<br>
shell>mkdir /home/weiqiong/itdb2<br>
shell>mkdir /home/weiqiong/itdb3<br>
shell>mkdir /home/weiqiong/itdb4<br>
shell>mkdir /home/weiqiong/itdb5<br>
shell>mkdir /home/weiqiong/itdb6<br>
shell>mkdir /home/weiqiong/itdb0<br>
34.创建后台任务文件：<br>
shell> vi itscron<br>
文件内容如下：<br>
0 2 * * 1 rm –f /home/weiqiong/itdb1/*.*<br>
10 2 * * 1 cp /usr/local/mysql/var/itdb/*.* /home/weiqiong/itdb1<br>
0 2 * * 2 rm –f /home/weiqiong/itdb2/*.*<br>
10 2 * * 2 cp /usr/local/mysql/var/itdb/*.* /home/weiqiong/itdb2<br>
0 2 * * 3 rm –f /home/weiqiong/itdb3/*.*<br>
10 2 * * 3 cp /usr/local/mysql/var/itdb/*.* /home/weiqiong/itdb3<br>
0 2 * * 4 rm –f /home/weiqiong/itdb4/*.*<br>
10 2 * * 4 cp /usr/local/mysql/var/itdb/*.* /home/weiqiong/itdb4<br>
0 2 * * 5 rm –f /home/weiqiong/itdb5/*.*<br>
10 2 * * 5 cp /usr/local/mysql/var/itdb/*.* /home/weiqiong/itdb5<br>
0 2 * * 6 rm –f /home/weiqiong/itdb6/*.*<br>
10 2 * * 6 cp /usr/local/mysql/var/itdb/*.* /home/weiqiong/itdb6<br>
0 2 * * 7 rm –f /home/weiqiong/itdb0/*.*<br>
10 2 * * 7 cp /usr/local/mysql/var/itdb/*.* /home/weiqiong/itdb0<br>
35.创建后台任务：<br>
shell> crontab itscron<br>
shell>crontab –l<br>
10.jsp的Web页面<br>
在/usr/local/apache/htdocs目录下创建目录images放图象，创建manage目录放后台管理页面。将前台的页面放在/usr/local/apache/htdocs目录下，将后台管理页面放在/usr/local/apache/htdocs/manage目录下，将JAVA需要用的类放在/usr/local/apache/htdocs/WEB-INF目录下。<br>
这样就可以通过键入http://192.168.18.235访问前台程序，通过键入http://192.168.18.235/manage访问后台管理程序。<br>
</FONT><br>
</TD>
</TR>
<TR>
<TD colSpan=2><FONT
class=middlefont></FONT><BR>
<FONT
class=normalfont>全文结束</FONT> </TD>
</TR>
<TR>
<TD background="images/dot.gif" tppabs="http://www.linuxhero.com/docs/images/dot.gif" colSpan=2
height=10></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></DIV></TD>
<TD vAlign=top width="20%"
background="images/line.gif" tppabs="http://www.linuxhero.com/docs/images/line.gif" rowSpan=2>
<DIV align=center>
<table class=tableoutline cellspacing=1 cellpadding=4
width="100%" align=center border=0>
<tr class=firstalt>
<td noWrap background="images/bgline.gif" tppabs="http://www.linuxhero.com/docs/images/bgline.gif" colspan=2 height=21>
<font class=normalfont><b>所有分类</b></font></td>
</tr>
<tr class=secondalt> <td noWrap width=27%> <font class=normalfont>1:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type1.html" tppabs="http://www.linuxhero.com/docs/type1.html">非技术类</a></font></td> </tr> </table></td></tr><tr class=firstalt> <td noWrap width=27%> <font class=normalfont>2:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type2.html" tppabs="http://www.linuxhero.com/docs/type2.html">基础知识</a></font></td> </tr> </table></td></tr><tr class=secondalt> <td noWrap width=27%> <font class=normalfont>3:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type3.html" tppabs="http://www.linuxhero.com/docs/type3.html">指令大全</a></font></td> </tr> </table></td></tr><tr class=firstalt> <td noWrap width=27%> <font class=normalfont>4:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type4.html" tppabs="http://www.linuxhero.com/docs/type4.html">shell</a></font></td> </tr> </table></td></tr><tr class=secondalt> <td noWrap width=27%> <font class=normalfont>5:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type5.html" tppabs="http://www.linuxhero.com/docs/type5.html">安装启动</a></font></td> </tr> </table></td></tr><tr class=firstalt> <td noWrap width=27%> <font class=normalfont>6:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type6.html" tppabs="http://www.linuxhero.com/docs/type6.html">xwindow</a></font></td> </tr> </table></td></tr><tr class=secondalt> <td noWrap width=27%> <font class=normalfont>7:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type7.html" tppabs="http://www.linuxhero.com/docs/type7.html">kde</a></font></td> </tr> </table></td></tr><tr class=firstalt> <td noWrap width=27%> <font class=normalfont>8:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type8.html" tppabs="http://www.linuxhero.com/docs/type8.html">gnome</a></font></td> </tr> </table></td></tr><tr class=secondalt> <td noWrap width=27%> <font class=normalfont>9:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type9.html" tppabs="http://www.linuxhero.com/docs/type9.html">输入法类</a></font></td> </tr> </table></td></tr><tr class=firstalt> <td noWrap width=27%> <font class=normalfont>10:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type10.html" tppabs="http://www.linuxhero.com/docs/type10.html">美化汉化</a></font></td> </tr> </table></td></tr><tr class=secondalt> <td noWrap width=27%> <font class=normalfont>11:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type11.html" tppabs="http://www.linuxhero.com/docs/type11.html">网络配置</a></font></td> </tr> </table></td></tr><tr class=firstalt> <td noWrap width=27%> <font class=normalfont>12:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type12.html" tppabs="http://www.linuxhero.com/docs/type12.html">存储备份</a></font></td> </tr> </table></td></tr><tr class=secondalt> <td noWrap width=27%> <font class=normalfont>13:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type13.html" tppabs="http://www.linuxhero.com/docs/type13.html">杂项工具</a></font></td> </tr> </table></td></tr><tr class=firstalt> <td noWrap width=27%> <font class=normalfont>14:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type14.html" tppabs="http://www.linuxhero.com/docs/type14.html">编程技术</a></font></td> </tr> </table></td></tr><tr class=secondalt> <td noWrap width=27%> <font class=normalfont>15:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type15.html" tppabs="http://www.linuxhero.com/docs/type15.html">网络安全</a></font></td> </tr> </table></td></tr><tr class=firstalt> <td noWrap width=27%> <font class=normalfont>16:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type16.html" tppabs="http://www.linuxhero.com/docs/type16.html">内核技术</a></font></td> </tr> </table></td></tr><tr class=secondalt> <td noWrap width=27%> <font class=normalfont>17:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type17.html" tppabs="http://www.linuxhero.com/docs/type17.html">速度优化</a></font></td> </tr> </table></td></tr><tr class=firstalt> <td noWrap width=27%> <font class=normalfont>18:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type18.html" tppabs="http://www.linuxhero.com/docs/type18.html">apache</a></font></td> </tr> </table></td></tr><tr class=secondalt> <td noWrap width=27%> <font class=normalfont>19:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type19.html" tppabs="http://www.linuxhero.com/docs/type19.html">email</a></font></td> </tr> </table></td></tr><tr class=firstalt> <td noWrap width=27%> <font class=normalfont>20:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type20.html" tppabs="http://www.linuxhero.com/docs/type20.html">ftp服务</a></font></td> </tr> </table></td></tr><tr class=secondalt> <td noWrap width=27%> <font class=normalfont>21:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type21.html" tppabs="http://www.linuxhero.com/docs/type21.html">cvs服务</a></font></td> </tr> </table></td></tr><tr class=firstalt> <td noWrap width=27%> <font class=normalfont>22:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type22.html" tppabs="http://www.linuxhero.com/docs/type22.html">代理服务</a></font></td> </tr> </table></td></tr><tr class=secondalt> <td noWrap width=27%> <font class=normalfont>23:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type23.html" tppabs="http://www.linuxhero.com/docs/type23.html">samba</a></font></td> </tr> </table></td></tr><tr class=firstalt> <td noWrap width=27%> <font class=normalfont>24:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type24.html" tppabs="http://www.linuxhero.com/docs/type24.html">域名服务</a></font></td> </tr> </table></td></tr><tr class=secondalt> <td noWrap width=27%> <font class=normalfont>25:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type25.html" tppabs="http://www.linuxhero.com/docs/type25.html">网络过滤</a></font></td> </tr> </table></td></tr><tr class=firstalt> <td noWrap width=27%> <font class=normalfont>26:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type26.html" tppabs="http://www.linuxhero.com/docs/type26.html">其他服务</a></font></td> </tr> </table></td></tr><tr class=secondalt> <td noWrap width=27%> <font class=normalfont>27:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type27.html" tppabs="http://www.linuxhero.com/docs/type27.html">nfs</a></font></td> </tr> </table></td></tr><tr class=firstalt> <td noWrap width=27%> <font class=normalfont>28:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type28.html" tppabs="http://www.linuxhero.com/docs/type28.html">oracle</a></font></td> </tr> </table></td></tr><tr class=secondalt> <td noWrap width=27%> <font class=normalfont>29:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type29.html" tppabs="http://www.linuxhero.com/docs/type29.html">dhcp</a></font></td> </tr> </table></td></tr><tr class=firstalt> <td noWrap width=27%> <font class=normalfont>30:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type30.html" tppabs="http://www.linuxhero.com/docs/type30.html">mysql</a></font></td> </tr> </table></td></tr><tr class=secondalt> <td noWrap width=27%> <font class=normalfont>31:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type31.html" tppabs="http://www.linuxhero.com/docs/type31.html">php</a></font></td> </tr> </table></td></tr><tr class=firstalt> <td noWrap width=27%> <font class=normalfont>32:</font> </td><td noWrap width=73%> <table width=100% border=0> <tr> <td><font class=normalfont><a href="type32.html" tppabs="http://www.linuxhero.com/docs/type32.html">ldap</a></font></td> </tr> </table></td></tr> </table>
</DIV></TD></TR>
<TR vAlign=top>
<TD width="80%">
<DIV align=center><BR>
</DIV>
</TD></TR></TBODY></TABLE></TD></TR>
</TABLE></TD></TR>
</TABLE>
<TABLE cellSpacing=0 cellPadding=4 width="100%" bgColor=#eeeeee
border=0><TBODY>
<TR>
<TD width="50%">
<P><FONT class=middlefont>版权所有 © 2004 <A
href="mailto:bjchenxu@sina.com">linux知识宝库</A><BR>
违者必究. </FONT></P>
</TD>
<TD width="50%">
<DIV align=right><FONT class=middlefont>Powered by: <A
href="mailto:bjchenxu@sina.com">Linux知识宝库</A> Version 0.9.0 </FONT></DIV>
</TD></TR></TBODY></TABLE>
<CENTER></CENTER></TD></TR>
</TABLE></CENTER></BODY></HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -