首页 > 代码库 > Goods Step01:工具类的编写
Goods Step01:工具类的编写
1.导包和配置文件:
/WebContent/WEB-INF/lib
activation.jar
c3p0-0.9.2-pre1.jar
c3p0-oracle-thin-extras-0.9.2-pre1.jar
commons-beanutils-1.8.3.jar
commons-collections-3.0.jar
commons-dbutils-1.4.jar
commons-fileupload-1.2.2.jar
commons-io-1.4.jar
commons-lang-2.1.jar
commons-logging-1.1.1.jar
mail.jar
mchange-commons-0.2.jar
mysql-connector-java-5.1.39-bin.jar
config
c3p0-config.xml
log4j.properties
2.工具类的编写src
cn.anstone.util.jdbc
2.1 JdbcUtils.java
2.2 TxQueryRunner.java
cn.anstone.util.mail
2.3 Mail.java
2.4 MailUtils.java
2.5 AttachBean.java
cn.anstone.util.vcode
2.6 VerifyCode.java
2.7 VerifyCodeServlet.java
cn.anstone.util.filter
2.8 EncodingFilter.java
2.9 GetRequest.java
2.10 LoginFilter.java
cn.anstone.util
2.11 CommonUtils.java
2.12 DateConverter.java
2.13 BaseServlet.java
3.测试工具类test
-- ----------------------------
-- 根据cn.anstone.util中的实体类创建数据表
-- ----------------------------
3.1 test.sql
/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50714
Source Host : localhost:3306
Source Database : test
Target Server Type : MYSQL
Target Server Version : 50714
File Encoding : 65001
Date: 2016-12-04 10:42:57
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `t_address`
-- ----------------------------
DROP TABLE IF EXISTS `t_address`;
CREATE TABLE `t_address` (
`addrId` varchar(40) NOT NULL,
`province` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`district` varchar(255) DEFAULT NULL,
`street` varchar(255) DEFAULT NULL,
PRIMARY KEY (`addrId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_address
-- ----------------------------
INSERT INTO `t_address` VALUES (‘424544‘, ‘湖南省‘, ‘张家界市‘, ‘永定区‘, ‘张家界学院‘);
INSERT INTO `t_address` VALUES (‘427000‘, ‘湖南省‘, ‘张家界市‘, ‘永定区‘, ‘吉首大学‘);
-- ----------------------------
-- Table structure for `t_user`
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
`userId` varchar(40) NOT NULL,
`UserName` varchar(40) DEFAULT NULL,
`age` int(20) DEFAULT NULL,
`sex` varchar(20) DEFAULT NULL,
`addrId` varchar(40) DEFAULT NULL,
PRIMARY KEY (`userId`),
UNIQUE KEY `USER_NAME` (`UserName`),
KEY `FK_AddrId_1` (`addrId`),
CONSTRAINT `FK_AddrId_1` FOREIGN KEY (`addrId`) REFERENCES `t_address` (`addrId`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO `t_user` VALUES (‘1001‘, ‘黑崎一护‘, ‘100‘, ‘男‘, ‘427000‘);
INSERT INTO `t_user` VALUES (‘1003‘, ‘石田雨龙‘, ‘33‘, ‘男‘, ‘427000‘);
INSERT INTO `t_user` VALUES (‘1004‘, ‘黑崎一心‘, ‘26‘, ‘男‘, ‘424544‘);
INSERT INTO `t_user` VALUES (‘1005‘, ‘朽木白哉‘, ‘26‘, ‘男‘, ‘424544‘);
3.2 cn.anstone.util
Address.java
CommonUtilsTest.java
JdbcUtilsTest.java
MailUtilsTest.java
TxQueryRunnerTest.java
User.java
3.3 cn.anstone.servlet
AServlet.java
LoginServlet.java
3.4 /WebContent/test
form.jsp
index.jsp
Goods Step01:工具类的编写