mysql
在mysql中增加数据库db9980,加入User,Domain,UserDomain表,数据库适配器的sql语句中注意大小写
drop database if exists db9980;
create database db9980;
use db9980;
drop table if exists User;
create table User
(
userid int unsigned not null AUTO_INCREMENT,
loginid int unsigned,
password varchar(20),
groupid int unsigned,
name varchar(30),
email varchar(40),
phone varchar(20),
info text,
primary key (userid)
);
drop table if exists Domain;
create table Domain
(
domainid int unsigned not null AUTO_INCREMENT,
name varchar(30),
level smallint,
ip varchar(20),
port varchar(10),
primary key (domainid)
);
drop table if exists UserDomain;
create table UserDomain
(
id int unsigned not null AUTO_INCREMENT,
userid int unsigned,
domainid int unsigned,
primary key (id)
);
insert into User (loginid, password) values('1','1');
select * from User limit 0, 5000;
insert into Domain (name, level, ip, port) values('luliang', 1, '10.58.2.2', '1099');
----------------------
tomcat
在catalina.sh中增加一行:
JAVA_OPTS="-Djava.security.policy=/home/apache-tomcat-5.5.23/client.policy"
环境变量设置:
export JAVA_HOME=/usr/java/jre1.5.0_04
export BASEDIR=/home
#/apache-tomcat-5.5.23
export CATALINA_HOME=/home/apache-tomcat-5.5.23
DAEMON_HOME=/home/apache-tomcat-5.5.23/bin/jsvc-src
TOMCAT_USER=tomcat
# for multi instances adapt those lines.
#TMP_DIR=/var/tmp
#PID_FILE=/var/run/jsvc.pid
CATALINA_BASE=/home/apache-tomcat-5.5.23
CATALINA_OPTS=
#CATALINA_OPTS="-Djava.library.path=/home/jfclere/jakarta-tomcat-connectors/jni/native/.libs"
export CLASSPATH=$JAVA_HOME/lib/tools.jar:$CATALINA_HOME/bin/commons-daemon.jar:$CATALINA_HOME/bin/bootstrap.jar