課程
/后端開發(fā)
/Java
/JDBC之 “ 對岸的女孩看過來”
有誰知道視圖層具體實(shí)現(xiàn)如何修改的功能,關(guān)于字段為Null時(shí),該怎么修改?
2018-09-26
源自:JDBC之 “ 對岸的女孩看過來” 2-9
正在回答
package view;
import java.io.*;
import java.sql.SQLException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.*;
import action.GodessAction;
import model.Godess;
public class View {
private static final String CONTEXT="歡迎來到女神禁區(qū):\n" +
"下面是女神禁區(qū)的功能列表:\n" +
"[MAIN/M]:主菜單\n" +
"[QUERY/Q]:查看全部女神的信息\n" +
"[GET/G]:查看某位女神的詳細(xì)信息\n" +
"[ADD/A]:添加女神信息\n" +
"[UPDATE/U]:更新女神信息\n" +
"[DELETE/D]:刪除女神信息\n" +
"[SEARCH/S]:查詢女神信息(根據(jù)姓名、手機(jī)號來查詢)\n" +
"[EXIT/E]:退出女神禁區(qū)\n" +
"[BREAK/B]:退出當(dāng)前功能,返回主菜單";
private static final String OPERATION_MAIN="MAIN";
private static final String OPERATION_QUERY="QUERY";
private static final String OPERATION_GET="GET";
private static final String OPERATION_ADD="ADD";
private static final String OPERATION_UPDATE="UPDATE";
private static final String OPERATION_DELETE="DELETE";
private static final String OPERATION_SEARCH="SEARCH";
private static final String OPERATION_EXIT="EXIT";
private static final String OPERATION_BREAK="BREAK";
public static void main(String[] args) {
System.out.println(CONTEXT);
Scanner scan = new Scanner(System.in);
Godess g = new Godess();
GodessAction ga = new GodessAction();
String previous = null;
Integer step=1;
while(scan.hasNext()) {
String input = scan.next().toString();
System.out.println("你輸入的值為:"+input);?
if(OPERATION_EXIT.equals(input.toUpperCase())||OPERATION_EXIT.substring(0, 1).equals(input.toUpperCase())) {
System.out.println("你已成功退出!");
break;
}else if(OPERATION_UPDATE.equals(input.toUpperCase())||OPERATION_UPDATE.substring(0, 1).equals(input.toUpperCase())) {
Godess gu= new Godess();
gu.setUser_name("小蘭");
gu.setAge(30);
gu.setSex(0);
gu.setBirthday(new Date());
gu.setMobile("15648790987");
gu.setEmail("xiaolan@163.com");
gu.setIsdel(1);
? ? ? ? gu.setId(3);
try {
ga.update(gu);
System.out.println("你已成功修改!");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}else if(OPERATION_DELETE.equals(input.toUpperCase())||OPERATION_DELETE.substring(0, 1).equals(input.toUpperCase())) {
System.out.println("輸入要?jiǎng)h除的女神id:");
Integer id = scan.nextInt();
ga.delete(id);
System.out.println("你已成功刪除!");
}else if(OPERATION_QUERY.equals(input.toUpperCase())||OPERATION_QUERY.substring(0, 1).equals(input.toUpperCase())) {
List<Godess> gds = ga.queryAll();
System.out.println("查詢成功,查詢結(jié)果如下:");
for(Godess gd:gds) {
System.out.println("姓名:"+gd.getUser_name()+" "+"年齡:"+gd.getAge());
System.out.println("查詢失敗");
}else if(OPERATION_ADD.equals(input.toUpperCase())||
OPERATION_ADD.substring(0, 1).equals(input.toUpperCase())||OPERATION_ADD.equals(previous)) {
previous = "ADD";
if(step==1) {
System.out.println("請輸入女神的[姓名]");
}else if(step==2) {
g.setUser_name(input);
System.out.println("請輸入女神的[年齡]");
}else if(step==3) {
g.setAge(Integer.valueOf(input));
System.out.println("請輸入女神的[性別]");
}else if(step==4) {
g.setSex(Integer.valueOf(input));
System.out.println("請輸入女神的[生日] 格式為yyyy-mm-dd");
}else if(step==5) {
SimpleDateFormat sd = new SimpleDateFormat("yyyy-mm-dd");
Date birthday = null;
birthday = sd.parse(input);
g.setBirthday(birthday);
System.out.println("請輸入女神的[郵箱]");
} catch (ParseException e) {
System.out.println("你輸入的生日格式有誤,請重新輸入");
step = 4;
}else if(step == 6) {
g.setEmail(input);
System.out.println("請輸入女神的[手機(jī)號]");
}else if(step==7){??
g.setMobile(input);
System.out.println("請輸入女神的[是否刪除標(biāo)志]");
}else {
g.setIsdel(Integer.valueOf(input));
ga.add(g);
System.out.println("新增女神成功");
System.out.println("新增女神失敗");
step++;
}else{
舉報(bào)
一起領(lǐng)略JDBC的奧秘,為進(jìn)一步學(xué)習(xí)集成框架打下良好的基礎(chǔ)
4 回答關(guān)于修改女神信息的問題
1 回答視圖層新增女神失敗
1 回答視圖層修改信息 輸入null的問題
2 回答修改女神屬性方法的While循環(huán)問題
4 回答關(guān)于search 查詢女神信息代碼 問題
Copyright ? 2025 imooc.com All Rights Reserved | 京ICP備12003892號-11 京公網(wǎng)安備11010802030151號
購課補(bǔ)貼聯(lián)系客服咨詢優(yōu)惠詳情
慕課網(wǎng)APP您的移動(dòng)學(xué)習(xí)伙伴
掃描二維碼關(guān)注慕課網(wǎng)微信公眾號
2018-11-05
package view;
import java.io.*;
import java.sql.SQLException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.*;
import action.GodessAction;
import model.Godess;
public class View {
private static final String CONTEXT="歡迎來到女神禁區(qū):\n" +
"下面是女神禁區(qū)的功能列表:\n" +
"[MAIN/M]:主菜單\n" +
"[QUERY/Q]:查看全部女神的信息\n" +
"[GET/G]:查看某位女神的詳細(xì)信息\n" +
"[ADD/A]:添加女神信息\n" +
"[UPDATE/U]:更新女神信息\n" +
"[DELETE/D]:刪除女神信息\n" +
"[SEARCH/S]:查詢女神信息(根據(jù)姓名、手機(jī)號來查詢)\n" +
"[EXIT/E]:退出女神禁區(qū)\n" +
"[BREAK/B]:退出當(dāng)前功能,返回主菜單";
private static final String OPERATION_MAIN="MAIN";
private static final String OPERATION_QUERY="QUERY";
private static final String OPERATION_GET="GET";
private static final String OPERATION_ADD="ADD";
private static final String OPERATION_UPDATE="UPDATE";
private static final String OPERATION_DELETE="DELETE";
private static final String OPERATION_SEARCH="SEARCH";
private static final String OPERATION_EXIT="EXIT";
private static final String OPERATION_BREAK="BREAK";
public static void main(String[] args) {
System.out.println(CONTEXT);
Scanner scan = new Scanner(System.in);
Godess g = new Godess();
GodessAction ga = new GodessAction();
String previous = null;
Integer step=1;
while(scan.hasNext()) {
String input = scan.next().toString();
System.out.println("你輸入的值為:"+input);?
if(OPERATION_EXIT.equals(input.toUpperCase())||OPERATION_EXIT.substring(0, 1).equals(input.toUpperCase())) {
System.out.println("你已成功退出!");
break;
}else if(OPERATION_UPDATE.equals(input.toUpperCase())||OPERATION_UPDATE.substring(0, 1).equals(input.toUpperCase())) {
Godess gu= new Godess();
gu.setUser_name("小蘭");
gu.setAge(30);
gu.setSex(0);
gu.setBirthday(new Date());
gu.setMobile("15648790987");
gu.setEmail("xiaolan@163.com");
gu.setIsdel(1);
? ? ? ? gu.setId(3);
try {
ga.update(gu);
System.out.println("你已成功修改!");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}else if(OPERATION_DELETE.equals(input.toUpperCase())||OPERATION_DELETE.substring(0, 1).equals(input.toUpperCase())) {
System.out.println("輸入要?jiǎng)h除的女神id:");
Integer id = scan.nextInt();
try {
ga.delete(id);
System.out.println("你已成功刪除!");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}else if(OPERATION_QUERY.equals(input.toUpperCase())||OPERATION_QUERY.substring(0, 1).equals(input.toUpperCase())) {
try {
List<Godess> gds = ga.queryAll();
System.out.println("查詢成功,查詢結(jié)果如下:");
for(Godess gd:gds) {
System.out.println("姓名:"+gd.getUser_name()+" "+"年齡:"+gd.getAge());
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println("查詢失敗");
}
}else if(OPERATION_ADD.equals(input.toUpperCase())||
OPERATION_ADD.substring(0, 1).equals(input.toUpperCase())||OPERATION_ADD.equals(previous)) {
previous = "ADD";
if(step==1) {
System.out.println("請輸入女神的[姓名]");
}else if(step==2) {
g.setUser_name(input);
System.out.println("請輸入女神的[年齡]");
}else if(step==3) {
g.setAge(Integer.valueOf(input));
System.out.println("請輸入女神的[性別]");
}else if(step==4) {
g.setSex(Integer.valueOf(input));
System.out.println("請輸入女神的[生日] 格式為yyyy-mm-dd");
}else if(step==5) {
SimpleDateFormat sd = new SimpleDateFormat("yyyy-mm-dd");
Date birthday = null;
try {
birthday = sd.parse(input);
g.setBirthday(birthday);
System.out.println("請輸入女神的[郵箱]");
} catch (ParseException e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println("你輸入的生日格式有誤,請重新輸入");
step = 4;
}
g.setBirthday(birthday);
}else if(step == 6) {
g.setEmail(input);
System.out.println("請輸入女神的[手機(jī)號]");
}else if(step==7){??
g.setMobile(input);
System.out.println("請輸入女神的[是否刪除標(biāo)志]");
}else {
g.setIsdel(Integer.valueOf(input));
try {
ga.add(g);
System.out.println("新增女神成功");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println("新增女神失敗");
}
}
step++;
}else{
System.out.println("新增女神失敗");
}
}
}
}