也写了几百行代码了,做个小教程,各位可以一起练练,纯servlet+jsp原生态。因为接下去要开始学习JAVAEE的三大框架,想在这之前把基础的大部分东西再手写一遍,要下乡基层劳动才知道用框架的好处啊~
先写些编码之前的东西
首先是服务器,http://blog.csdn.net/hhooong/article/details/50651840
接着是开发工具,我是用myeclipse10,jdk1.7 tomcat7.0 mysql
数据库建表语句:
create table hotel(
hotel_no int primary key auto_increment,
hotel_name varchar(30) not null,
hotel_addr varchar(50) not null,
hotel_phone varchar(30),
hotel_room_count int default 0
) ENGINE=InnoDB DEFAULT CHARSET= utf8;
create table room(
room_id int primary key auto_increment,
room_no varchar(10) not null,
room_type char(1) not null,
room_equip varchar(20) not null,
room_status char(1) not null,
room_memo varchar(200),
hotel_no int not null,
constraint FK_ROOM_HOTEL FOREIGN KEY (hotel_no) references hotel(hotel_no)
)ENGINE=InnoDB DEFAULT CHARSET= utf8;
create table user(
user_id int primary key auto_increment,
user_name varchar(10) not null,
user_passwd varchar(10) not null
)ENGINE=InnoDB DEFAULT CHARSET= utf8;
先来三张表,搞个简单版后,后面可能心血来潮还会改动
接下来是项目结构
然后开始是连接池的配置,这边用的是
Proxool连接池,可能需要用到几个jar包,在这里下载http://download.csdn.net/detail/hhooong/9432440
然后开始是连接池的配置
<?xml version="1.0" encoding="utf-8"?>
<something-else-entirely>
<proxool>
<alias>hotelsys-ds</alias>
<driver-url>jdbc:mysql://XXXXX:3306/Hotel</driver-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<driver-properties>
<property name="user" value="root"/>
<property name="password" value=""/>
</driver-properties>
<maximum-connection-count>100</maximum-connection-count>
<minimum-connection-count>10</minimum-connection-count>
<proxool.simultaneous-build-throttle>10</proxool.simultaneous-build-throttle>
<house-keeping-sleep-time>90000</house-keeping-sleep-time>
<prototype-count>5</prototype-count>
<test-before-use>true</test-before-use>
<house-keeping-test-sql>select now()</house-keeping-test-sql>
</proxool>
</something-else-entirely>