新建包,管理代码
建库,建表
1 DROP TABLE IF EXISTS `t_user`; 2 CREATE TABLE `t_user` ( 3 `t_id` int(11) NOT NULL AUTO_INCREMENT, 4 `t_username` varchar(20) NOT NULL, 5 `t_password` varchar(8) NOT NULL, 6 PRIMARY KEY (`t_id`) 7 ) 8 9 -- ---------------------------- 10 -- Records of t_user 11 -- ---------------------------- 12 INSERT INTO `t_user` (t_username,t_password) VALUES ( 'lisi', '123456'); 13 INSERT INTO `t_user` (t_username,t_password) VALUES ( 'wanger', '654321'); 14 INSERT INTO `t_user` (t_username,t_password) VALUES ( '李四', '123123'); 15 INSERT INTO `t_user` (t_username,t_password) VALUES ( '王二', '321321');