java联系人代码_java通讯录代码

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

import java.util.*;

public class AddressUI1{

public static void main(String[] args){

Scanner sc=new Scanner(System.in);

}

public String mainMenu() {

System.out.println("@请选择功能：1.查询 2.添加 3.修改 4.删除 0.退出");

String select =sc.nextLine();

AddressUI1 au = new AddressUI1();

boolean flag = true;

while (flag) {

String select=au.mainMenu();

switch (select.charAt(0)) {

case 1:

au.searchMenu();

break;

case 2:

au.addMenu();

break;

case 3:

au.alterMenu();

break;

case 4:

au.deleteMenu();

break;

case 0:

au.exitMenu();

default:

flag=false;

}

public void searchMenu() {

System.out.println("@请输入你要查询的姓名：");

String name=sc.nextLine();

Connection conn=null;

try {

conn = DBConnection1.getConnection();

Statement st =conn.createStatement();

String sql = "select * from tongxunlu where username='"+name+"'";

ResultSet rs = st.executeQuery(sql);

while (rs.next()) {

if(rs==null){

System.out.println("查无此人！");

}else{

System.out.println(rs.getString("username")+","

+rs.getString("sex")+","

+rs.getString("telephone")+","

+rs.getString("address"));

}

}

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}

return select;

}

public void addMenu() {

System.out.println("请输入姓名：");

String username = sc.nextLine();

System.out.println("性别：");

String sex = sc.nextLine();

System.out.println("手机电话：");

String telephone = sc.nextLine();

System.out.println("地址：");

String address = sc.nextLine();

String sql = "insert tongxunlu(username,sex,telephone,address) values(?,?,?,?)";

Connection conn = null;

try {

conn = DBConnection1.getConnection();

PreparedStatement pst = conn.prepareStatement(sql);

pst.setString(1, username);

pst.setString(2, sex);

pst.setString(3, telephone);

pst.setString(4, address);

int r = pst.executeUpdate();

if(r!=1){

System.out.println("添加失败!");

}else{

System.out.println("添加成功!");

}

pst.close();

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}

return select;

}

public void alterMenu(){

System.out.println("请输入要修改信息的姓名：");

String altername=sc.nextLine();

System.out.println("请输入要修改的性别：");

String sex = sc.nextLine();

System.out.println("请输入要修改的手机电话：");

String telephone = sc.nextLine();

System.out.println("请输入要修改的地址：");

String address = sc.nextLine();

String altersql="update tongxunlu set sex= ? where username='"+ altername + "'"+

"update tongxunlu set telephone= ? where username='"+ altername + "'"+

"update tongxunlu set address= ? where username='"+ altername + "'";

Connection conn =null;

try{

conn = DBConnection1.getConnection();

PreparedStatement ast = conn.prepareStatement(altersql);

ast.setString(1, sex);

ast.setString(2, telephone);

ast.setString(3, address);

int a = ast.executeUpdate();

if(a!=1){

System.out.println("修改失败!");

}else{

System.out.println("修改成功!");

}

ast.close();

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}

return select;

}

public void deleteMenu(){

System.out.println("请输入要删除信息的姓名：");

String deletename=sc.nextLine();

String deletesql="delete from tongxunlu where username='"+deletename+"'";

Connection conn =null;

try{

conn = DBConnection1.getConnection();

Statement qst = conn.Statement(deletesql);

System.out.println("确定要删除姓名为"+deletename+"的信息吗？");

String b =sc.nextLine();

String str=new String("yes");

boolean b1=b.equals(str);

if(b1){

int a = qst.executeUpdate();

if(a!=1){

System.out.println("删除失败!");

}else{

System.out.println("删除成功!");

}

qst.close();

}

else{

System.out.println("删除失败!");

}

}catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}

return select;

}

public void exitMenu(){

System.out.println("谢谢使用！O(∩_∩)O哈哈~");

finally{

DBConnection1.closeConnection(conn);

}

}

}

}

}

求大神改错！！！