正删改查数据库系统
public class demo1 {
private static Scanner sc=new Scanner(System.in);
public static void main(String[] args) throws Exception {
while(true){
System.out.println("1.查询所有学生数据");
System.out.println("2.增加一条学生数据");
System.out.println("3.修改一条学生数据");
System.out.println("4.删除一条学生数据");
String alreadyIn= sc.nextLine();
if("1".equals(alreadyIn)){
System.out.println("-----------------------------------------------------------");
System.out.println("查询ok!\n\n所有数据如下:\n 学号 | 姓名 | 性别 | 住址 | 成绩");
findAll();
}else if("2".equals(alreadyIn)){
System.out.println("-----------------------------------------------------------");
add();
System.out.println("\n添加数据后数据如下:\n\n 学号 | 姓名 | 性别 | 住址 | 成绩");
findAll();
}else if("3".equals(alreadyIn)){
System.out.println("-----------------------------------------------------------");
update();
System.out.println("修改后数据如下:\n 学号 | 姓名 | 性别 | 住址 | 成绩");
findAll();
}else if("4".equals(alreadyIn)){
System.out.println("-----------------------------------------------------------");
del();
System.out.println("删除操作后数据如下:\n 学号 | 姓名 | 性别 | 住址 | 成绩");
findAll();
}else if("-1".equals(alreadyIn)){
System.out.println("-----------------------------------------------------------");
System.out.println("退出虚拟机ok");
System.exit(0);
}else{
System.err.println("Illegal input,try again");
}
}
}
private static void del() {
System.out.println("正在进行删除数据操作!请谨慎!");
System.out.println("按照学号删除数据,请输入要删除的学生信息的学号:");
String id=sc.nextLine();
Connection con = null;
PreparedStatement pr = null;
ResultSet rs = null;
try {
con=JdbcUtil.getCon();
String sql="delete from stu where stuid=?";
pr=con.prepareStatement(sql);
pr.setString(1, id);
int delRs=pr.executeUpdate();
System.out.println("\n删除操作完成!\n影响行数"+delRs);
} catch (Exception e) {
}finally{
JdbcUtil.close(con, pr, rs);
}
}
private static void update() {
System.out.println("修改操作中……");
System.out.println("请输入要修改的学生编号:");
String stuid = sc.nextLine();
System.out.println("请输入要修改的姓名:");
String name = sc.nextLine();
System.out.println("请输入要修改的性别:");
String gender = sc.nextLine();
Connection con = null;
PreparedStatement pr = null;
ResultSet rs = null;
try {
con = JdbcUtil.getCon();
String sql = "update stu set name=?,gender=? where stuid=?";
pr = con.prepareStatement(sql);
pr.setString(1, name);
pr.setString(2, gender);
pr.setString(3, stuid);
int rows = pr.executeUpdate();
if (rows > 0) {
System.out.println("\n数据修改成功!\n影响行数:"+rows);
}
} catch (Exception e) {
e.printStackTrace();
}
}
private static void add() {
System.out.println("正在进行增加数据操作……");
System.err.println("This system modification is only allowed to change the studentundefineds name and gender.");
System.out.println("输入新生学号:");
String stuid=sc.nextLine();
System.out.println("输入新生姓名:");
String name=sc.nextLine();
System.out.println("输入新生性别:");
String gender=sc.nextLine();
System.out.println("输入新生住址:");
String addr=sc.nextLine();
System.out.println("输入新生转学成绩:");
double score=Double.parseDouble(sc.nextLine());
Connection con=null;
PreparedStatement pr=null;
ResultSet rs=null;
try {
con=JdbcUtil.getCon();
String sql="insert into stu values(?,?,?,?,?)";
pr=con.prepareStatement(sql);
pr.setString(1, stuid);
pr.setString(2, name);
pr.setString(3, gender);
pr.setString(4, addr);
pr.setDouble(5, score);
int upRs= pr.executeUpdate();
System.out.println("\n数据添加已完成!\n影响行数:"+upRs);
} catch (Exception e) {
}
}
private static void findAll() {
Connection con=null;
Statement sta=null;
ResultSet rs=null;
try {
con=JdbcUtil.getCon();
sta=con.createStatement();
String sql="select * from stu order by stuid";
ResultSet selRs = sta.executeQuery(sql);
while(selRs.next()){
String stuid = selRs.getString("stuid");
String name = selRs.getString("name");
String sex = selRs.getString("gender");
String address = selRs.getString("addr");
double score = selRs.getDouble("score");
System.out.println(stuid+" | "+name+" | "+sex+" | "+address+" | "+score);
}
System.out.println("\n-----------------------------------------------------------\n");
} catch (Exception e) {
}
}
}
下载cj_db数据库
下载JdbcUtil.java