布局
Java程序
Cs.java
在这里插入代码片
``import jdk.nashorn.internal.runtime.linker.LinkerCallSite;
import javax.xml.crypto.Data;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
import java.util.Scanner;
public class Cs {
static List<Drug>list=new ArrayList<>();
static PreparedStatement pst,pst1;
static Statement stat;
static ResultSet rs;
static Drug d=new Drug();
static String drugNum;
static String drugName;
static String drugSdata;
static String drugDdata;
public static void main(String[] args) {
while (true) {
System.out.println("---------欢迎来到药店数据管理系统-----------");
System.out.println("1:添加药品信息");
System.out.println("2:修改药品信息");
System.out.println("3:删除药品信息");
System.out.println("4:查询药品信息");
System.out.println("5:退出");
System.out.println("请输入你要进行的操作(1-4)");
Scanner sc = new Scanner(System.in);
String s = sc.nextLine();
switch (s) {
case "1":
add(list);
break;
case "2":
updata(list);
break;
case "3":
delect(list);
break;
case "4":
show(list);
case "5":
System.out.println("您已退出,谢谢使用");
System.exit(0);
break;
default:
System.out.println("您的操作错误,请重新输入");
break;
}
}
}
private static void show(List<Drug> list) {
try {
Connection conn=DBU1.getConn();
String sql="select * from drug1";
stat=conn.createStatement();
rs=stat.executeQuery(sql);
while (rs.next()){
System.out.println("药品名称\t"+rs.getString("drugNum")+"药品编号\t"+rs.getString("drugName")
+"药品生产日期\t"+rs.getString("drugSdata")+"药品保质期\t"+rs.getString("drugDdata"));