一、案例需求
这个嗖嗖移动大厅是一个简易版的移动大厅,需要做到用户注册,用户登录,查询话费余额,查询账单等功能。
二、功能分析
这是一个Java和数据结合的案例,那么我们在做功能的时候就需要搞清楚,实现这个案例需要几张表,这几张表之间的联系是什么,这个功能要做什么,需要哪几张表配合增删改查。比如做注册功能,那么我们首先要有一个存放号码的表,因为每个人的电话号码都是独有的,我们在注册的时候就需要改变卡的状态,这样下一个人选择号码就不能选择这个被人选择过的号码。我们还需要一个用户表,用于记录开卡人的姓名等重要信息,这就需要用到数据库中insert into...values语句。
三、源码
Dao层接口:
package jiujiu.dao;
import jiujiu.model.*;
import java.util.List;
public interface SosoDao {
List<Tb_mobole_card> login(String name,String password);//登录
List<Tb_card> emptyCard();//返回空卡集合
List<Tb_serpackage_type> combo();//查询套餐集合
int add(Tb_mobole_card tb_mobole_card);//添加用户数据
int append(Tb_recharge_record tb_recharge_record);//添加充值数据
int edit(String carnumber);//修改号码为已占用
List<Tb_serpackage> findserpackages();//查找套餐内容
List<Tb_mobole_card> bill(String username);//查询余额
List<Tb_serpackage> traiff(int id);//查询月租
List<Tb_monthly_consumption_records> monbill(String cardNumber,int month);//查询当月超出费用
List<Tb_consuminfo> consume(String cardnumber);//查询使用数据
int seralter(int serpackage,double money,String number);//更改用户表套餐
int top_up(double money,String number);//用户充值
int exituser(String number);//删除用户表中行
int recover(String number);//号码状态为0
int exitrecord(String number);//删除record表中的行
int exitconsuminfo(String number);//删除consuminfo表的行
int exitrecords(String number);//删除records表的行
int exitscene(int id);//删除scene表的行
}
Dao层实现类:
package jiujiu.dao.impl;
import jiujiu.dao.SosoDao;
import jiujiu.model.*;
import jiujiu.util.JDBCUtil;
import java.util.List;
public class SosoDaoImpl implements SosoDao {
@Override
public List<Tb_mobole_card> login(String name,String password) {
String sql="select * from Tb_mobole_card where username=? and password=?";
return JDBCUtil.executeQuery(sql,Tb_mobole_card.class,name,password);
}
@Override
public List<Tb_card> emptyCard() {
String sql="select * from Tb_card where status=0";
return JDBCUtil.executeQuery(sql,Tb_card.class);
}
@Override
public List<Tb_serpackage_type> combo() {
String sql="select * from Tb_serpackage_type";
return JDBCUtil.executeQuery(sql,Tb_serpackage_type.class);
}
@Override
public int add(Tb_mobole_card tb_mobole_card) {
String sql="insert into Tb_mobole_card(card_number,username,password,ser_package,money,status) values(?,?,?,?,?,?)";
return JDBCUtil.executeUpdate(sql,tb_mobole_card.getCard_number(),tb_mobole_card.getUsername(),tb_mobole_card.getPassword(),tb_mobole_card.getSer_package(),tb_mobole_card.getMoney(),tb_mobole_card.getStatus());
}
@Override
public int append(Tb_recharge_record tb_recharge_record) {
String sql="insert into Tb_recharge_record(amount,recharge_date,card_number) values (?,?,?)";
return JDBCUtil.executeUpdate(sql,tb_recharge_record.getAmount(),tb_recharge_record.getRecharge_date(),tb_recharge_record.getCard_number());
}
@Override
public int edit(String carnumber) {
String sql="update Tb_card set status=1 where cardNumber=?";
return JDBCUtil.executeUpdate(sql,carnumber);
}
@Override
public List<Tb_serpackage> findserpackages() {
String sql="select * from Tb_serpackage";
return JDBCUtil.executeQuery(sql,Tb_serpackage.class);
}
@Override
public List<Tb_mobole_card> bill(String username) {
String sql="select * from Tb_mobole_card where username=?";
return JDBCUtil.executeQuery(sql,Tb_mobole_card.class,username);
}
@Override
public List<Tb_serpackage> traiff(int id) {
String sql="select * from Tb_serpackage where id=?";
return JDBCUtil.executeQuery(sql,Tb_serpackage.class,id);
}
@Override
public List<Tb_monthly_consumption_records> monbill(String cardNumber,int month) {
String sql="select * from Tb_monthly_consumption_records where card_number=? and month(consume_date)=?";
return JDBCUtil.executeQuery(sql,Tb_monthly_consumption_records.class,cardNumber,month);
}
@Override
public List<Tb_consuminfo> consume(String cardnumber) {
String sql="select * from Tb_consuminfo where card_number=?";
return JDBCUtil.executeQuery(sql,Tb_consuminfo.class,cardnumber);
}
@Override
public int seralter(int serpackage,double money,String number) {
String sql="update Tb_mobole_card set ser_package=?,money=? where card_number=?";
return JDBCUtil.executeUpdate(sql,serpackage,money,number);
}
@Override
public int top_up(double money,String number) {
String sql="update Tb_mobole_card set money=? where card_number=?";
return JDBCUtil.executeUpdate(sql,money,number);
}
@Override
public int exituser(String number) {
String sql="delete from Tb_mobole_card where card_number=?";
return JDBCUtil.executeUpdate(sql,number);
}
@Override
public int recover(String number) {
String sql="update Tb_card set status=0 where cardNumber=?";
return JDBCUtil.executeUpdate(sql,number);
}
@Override
public int exitrecord(String number) {
String sql="delete from Tb_recharge_record where card_number=?";
return JDBCUtil.executeUpdate(sql,number);
}
@Override
public int exitconsuminfo(String number) {
String sql="delete from Tb_consuminfo where card_number=?";
return JDBCUtil.executeUpdate(sql,number);
}
@Override
public int exitrecords(String number) {
String sql="delete from Tb_monthly_consumption_records where card_number=?";
return JDBCUtil.executeUpdate(sql,number);
}
@Override
public int exitscene(int id) {
String sql="delete from Tb_scene where id=?";
return JDBCUtil.executeUpdate(sql,id);
}
}
service接口:
import jiujiu.model.*;
import java.util.List;
public interface SosoService {
Tb_mobole_card login(String name,String password);
List<Tb_card> emptyCard();
List<Tb_serpackage_type> combo();
int add(Tb_mobole_card tb_mobole_card);
int append(Tb_recharge_record tb_recharge_record);
int edit(String carnumber);
List<Tb_serpackage> findserpackages();
Tb_mobole_card bill(String username);
Tb_serpackage traiff(int id);
Tb_monthly_consumption_records monbill(String cardNumber,int month);
List<Tb_consuminfo> consume(String cardnumber);
int seralter(int serpackage,double money,String number);
int top_up(double money,String number);
int exituser(String number);
int recover(String number);
int exitrecord(String number);
int exitconsuminfo(String number);
int exitrecords(String number);
int exitscene(int id);
}
service实现类:
package jiujiu.service.impl;
import jiujiu.dao.impl.SosoDaoImpl;
import jiujiu.model.*;
import jiujiu.service.SosoService;
import jiujiu.util.JDBCUtil;
import java.util.List;
public class SosoServiceImpl implements SosoService {
SosoDaoImpl sosoDao=new SosoDaoImpl();
@Override
public Tb_mobole_card login(String name, String password) {
Tb_mobole_card user=null;
List<Tb_mobole_card> list=sosoDao.login(name,password);
for (Tb_mobole_card tb_mobole_card : list) {
user=tb_mobole_card;
}
return user;
}
@Override
public List<Tb_card> emptyCard() {
List<Tb_card> emcard=sosoDao.emptyCard();
return emcard;
}
@Override
public List<Tb_serpackage_type> combo() {
List<Tb_serpackage_type> setmeal=sosoDao.combo();
return setmeal;
}
@Override
public int add(Tb_mobole_card tb_mobole_card) {
return sosoDao.add(tb_mobole_card);
}
@Override
public int append(Tb_recharge_record tb_recharge_record) {
return sosoDao.append(tb_recharge_record);
}
@Override
public int edit(String carnumber) {
return sosoDao.edit(carnumber);
}
@Override
public List<Tb_serpackage> findserpackages() {
List<Tb_serpackage> fserpackage=sosoDao.findserpackages();
return fserpackage;
}
@Override
public Tb_mobole_card bill(String username) {
List<Tb_mobole_card> billq=sosoDao.bill(username);
Tb_mobole_card moboleCard = billq.get(0);
return moboleCard;
}
@Override
public Tb_serpackage traiff(int id) {
List<Tb_serpackage> straiff=sosoDao.traiff(id);
Tb_serpackage serpackage= null;
for (Tb_serpackage tb_serpackage : straiff) {
serpackage=tb_serpackage;
break;
}
return serpackage;
}
@Override
public Tb_monthly_consumption_records monbill(String cardNumber,int month) {
List<Tb_monthly_consumption_records> monbillq=sosoDao.monbill(cardNumber,month);
Tb_monthly_consumption_records monthly=null;
for (Tb_monthly_consumption_records tb_monthly_consumption_records : monbillq) {
monthly=tb_monthly_consumption_records;
}
return monthly;
}
@Override
public List<Tb_consuminfo> consume(String cardnumber) {
List<Tb_consuminfo> consuminfos=sosoDao.consume(cardnumber);
return consuminfos;
}
@Override
public int seralter(int serpackage,double money, String number) {
return sosoDao.seralter(serpackage,money,number);
}
@Override
public int top_up(double money, String number) {
return sosoDao.top_up(money,number);
}
@Override
public int exituser(String number) {
return sosoDao.exituser(number);
}
@Override
public int recover(String number) {
return sosoDao.recover(number);
}
@Override
public int exitrecord(String number) {
return sosoDao.exitrecord(number);
}
@Override
public int exitconsuminfo(String number) {
return sosoDao.exitconsuminfo(number);
}
@Override
public int exitrecords(String number) {
return sosoDao.exitrecords(number);
}
@Override
public int exitscene(int id) {
return sosoDao.exitscene(id);
}
}
view:
package jiujiu.view;
import jiujiu.model.*;
import jiujiu.service.impl.SosoServiceImpl;
import jiujiu.util.DateUtil;
import java.util.Date;
import java.util.List;
import java.util.Scanner;
public class SosoView {
Scanner scanner=new Scanner(System.in);
SosoServiceImpl sososervice=new SosoServiceImpl();
List<Tb_serpackage> serpackages=null;
Tb_serpackage serpackage=null;
List<Tb_consuminfo> consuminfoList=null;
//全局用户,表示登录成功对象
Tb_mobole_card tb_mobole_card=null;
public static void main(String[] args) {
new SosoView().firstinit();
}
public void firstinit(){
System.out.println("******************欢迎使用嗖嗖移动业务大厅******************");
System.out.println("1.用户登录 2.用户注册 3.使用嗖嗖 4.话费充值 5.资费说明 6.退出系统");
System.out.print("请选择:");
int change=scanner.nextInt();
switch (change){
case 1:
login();
break;
case 2:
register();
break;
case 3:
break;
case 4:
topUp();
firstinit();
break;
case 5:
description();
break;
case 6:
System.out.println("欢迎下次光临!");
System.exit(0);
break;
}
}
public void secondinit(){
System.out.println("******************嗖嗖移动用户菜单******************");
System.out.println("1.本月账单查询\n2.套餐余量查询\n3.打印消费详单\n4.套餐变更\n5.办理退网");
System.out.println("请输入(输入1~5选择功能,其他键返回上一级):");
int change=scanner.nextInt();
switch (change){
case 1:
billQuery();
secondinit();
break;
case 2:
inventory();
secondinit();
break;
case 3:
details();
secondinit();
break;
case 4:
alter();
secondinit();
break;
case 5:
quit();
firstinit();
break;
default:
firstinit();
break;
}
}
void login(){
System.out.println("请输入用户名:");
String name=scanner.next();
System.out.println("请输入密码:");
String password=scanner.next();
tb_mobole_card=sososervice.login(name,password);
if (tb_mobole_card!=null){
if (tb_mobole_card.getStatus()!=1){
System.out.println("登录成功");
secondinit();
}
else {
System.out.println("该卡号被禁用");
firstinit();
}
}else {
System.out.println("账号或密码错误");
firstinit();
}
}
void register(){
System.out.println("*****请选择卡号******");
List<Tb_card> card=sososervice.emptyCard();
for (int i=0;i<card.size();i++){
System.out.println((i+1)+"."+card.get(i).getCardNumber()+"\t");
if ((i+1)%3==0){
System.out.println("");
}
}
System.out.println("请选择你的卡号:");
int id=scanner.nextInt();
String cardNumber = card.get(id - 1).getCardNumber();
serpackages=sososervice.findserpackages();
// for (int i=0;i<serpackages.size();i++){
// System.out.println((i+1)+"."+serpackages.get(i).getType());
// }
List<Tb_serpackage_type> meal=sososervice.combo();
for (int i=0;i<meal.size();i++){
System.out.println(meal.get(i).getId()+"."+meal.get(i).getName()+"\t");
}
System.out.println("请选择套餐:");
int change=scanner.nextInt();
System.out.println("请输入姓名:");
String username=scanner.next();
System.out.println("请输入密码:");
String password=scanner.next();
System.out.println("请输入预存话费金额:");
double prepaid=scanner.nextDouble();
Tb_serpackage tb_serpackage=serpackages.get(change-1);
double v=prepaid-tb_serpackage.getPrice();
out:while (true){
if (v>0){
Tb_mobole_card mobole_card=new Tb_mobole_card(card.get(id-1).getId(),cardNumber,username,password,change,v,0);
int insert=sososervice.add(mobole_card);
Tb_recharge_record tb_recharge_record=new Tb_recharge_record(card.get(id-1).getId(),prepaid,new Date(),cardNumber);
int record=sososervice.append(tb_recharge_record);
int updated=sososervice.edit(cardNumber);
if (insert==1&&record==1&&updated==1){
System.out.println("注册成功!");
System.out.println("卡号:"+cardNumber+"用户名:"+username+"当前余额:"+v+"元");
System.out.println(tb_serpackage);
firstinit();
}
else {
System.out.println("注册失败!");
}
firstinit();
break out;
}
else {
System.out.println("您预存的话费不足以支付本月套餐资费,请重新充值:");
prepaid=scanner.nextDouble();
v=prepaid-tb_serpackage.getPrice();
}
}
}
void billQuery(){
System.out.println("*********本月账单查询********");
System.out.println("您的卡号:"+tb_mobole_card.getCard_number()+",当月账单");
serpackage=sososervice.traiff(tb_mobole_card.getSer_package());
System.out.println("套餐资费:"+serpackage.getPrice());
Tb_monthly_consumption_records monbill = sososervice.monbill(tb_mobole_card.getCard_number(), DateUtil.getCurrentMonth());
double v=monbill.getConsum_amount();
System.out.println("合计:"+(serpackage.getPrice()+v));
System.out.println("账户余额:"+sososervice.bill(tb_mobole_card.getUsername()).getMoney());
}
void inventory(){
System.out.println("**********套餐余量查询**********");
System.out.println("您的卡号:"+tb_mobole_card.getCard_number()+",套餐内剩余:");
serpackages=sososervice.findserpackages();
Tb_serpackage tb_serpackage=serpackages.get(tb_mobole_card.getSer_package()-1);
Tb_monthly_consumption_records monbill = sososervice.monbill(tb_mobole_card.getCard_number(), DateUtil.getCurrentMonth());
int s=tb_serpackage.getTalk_time()-monbill.getReal_talk_time();
int t=tb_serpackage.getSms_count()-monbill.getReal_SMS_count();
int l=tb_serpackage.getFlow()-monbill.getReal_flow();
if (s<0){
System.out.println("通话时长:0分钟");
}else {
System.out.println("通话时长:"+s+"分钟");
}
if (t<0){
System.out.println("短信条数:0条");
}else {
System.out.println("短信条数:"+t+"条");
}
if (l<0){
System.out.println("上网流量:0G");
}else {
System.out.println("上网流量:"+(l/1024)+"G"+(l%1024)+"M");
}
}
void details(){
System.out.println("**********消费详情查询***********");
System.out.println("请输入本年需要查询的月份(1-12):");
int month=scanner.nextInt();
System.out.println("序号\t类型\t数据\t日期");
consuminfoList=sososervice.consume(tb_mobole_card.getCard_number());
if (consuminfoList!=null){
for (int i=0;i<consuminfoList.size();i++){
System.out.println((i+1)+"\t"+consuminfoList.get(i).getType()+"\t"+consuminfoList.get(i).getConsum_data()+"\t"+consuminfoList.get(i).getConsume_date());
}
}else {
System.out.println("对不起,该卡号不存在消费记录!");
}
}
void description(){
System.out.println("******套餐说明******");
System.out.println("序号\t套餐名称\t通话时长(分/月)\t短信条数(条/月)\t上网流量(G/月)");
List<Tb_serpackage_type> type=sososervice.combo();
serpackages=sososervice.findserpackages();
for (int i=0;i<type.size();i++){
System.out.println(type.get(i).getId()+type.get(i).getName()+serpackages.get(i).getTalk_time()+serpackages.get(i).getSms_count()+(serpackages.get(i).getFlow()/1024));
}
}
void alter(){
System.out.println("******套餐变更******");
List<Tb_serpackage_type> meal=sososervice.combo();
for (int i=0;i<meal.size();i++){
System.out.println(meal.get(i).getId()+"."+meal.get(i).getName()+"\t");
}
System.out.println("请选择(序号):");
int change=scanner.nextInt();
serpackages=sososervice.findserpackages();
Tb_serpackage tb_serpackage=serpackages.get(change-1);
double price=tb_mobole_card.getMoney()-tb_serpackage.getPrice();
if (tb_mobole_card.getSer_package()==change){
System.out.println("您已经是改套餐的用户,无需更换!");
}else{
if (tb_mobole_card.getMoney()<tb_serpackage.getPrice()){
System.out.println("对不起,您的余额不足以支付新套餐本月资费,请充值后办理变更套餐业务!");
}else {
sososervice.seralter(change,price,tb_mobole_card.getCard_number());
System.out.println("更换套餐成功!"+meal.get(change-1).getName()+":通话时长:"+tb_serpackage.getTalk_time()+"分钟/月,短信条数:"+tb_serpackage.getSms_count()+"条/月,上网流量:"+(tb_serpackage.getFlow()/1024)+"GB/月,月租:"+tb_serpackage.getPrice()+"元/月");
}
}
}
void topUp(){
System.out.println("********话费充值*********");
System.out.print("请输入要充值账号:");
String name=scanner.next();
System.out.print("请输入充值金额:");
int m=scanner.nextInt();
tb_mobole_card = sososervice.bill(name);
sososervice.top_up((m+tb_mobole_card.getMoney()),tb_mobole_card.getCard_number());
}
void quit(){
System.out.println("********办理退网*******");
String num=tb_mobole_card.getCard_number();
sososervice.recover(tb_mobole_card.getCard_number());
sososervice.exituser(tb_mobole_card.getCard_number());
sososervice.exitrecord(tb_mobole_card.getCard_number());
sososervice.exitconsuminfo(tb_mobole_card.getCard_number());
sososervice.exitrecords(tb_mobole_card.getCard_number());
sososervice.exitscene(tb_mobole_card.getSer_package());
System.out.println("卡号"+num+"办理退网成功!");
}
void use(){
}
}
model类代码结合自己的表格,写好gettersetter语句。构建函数就可以。
四、总结
这个案例主要训练的是三层架构思想,代码规范,易懂。基本上理清楚思路,清除表的结构和作用,这个案例就没有什么太大的问题。