《JAVA程序设计》实验报告(DOC)(10)

public class process { public static List list = new ArrayList(); public static int counter = 1; public static Random random = new Random(); public static void main(String[]args){ initTickets(); process st = new process(); for(int i = 1; i<= 5;i++){ st.new Solder().start(); } } private synchronized String getOneTicket(){ if(list.size()<=0) return null; return list.remove(0); } private static void initTickets(){ for(int i = 1 ;i <= 100 ; i++ ){ list.add(\第 \张票\ } } /** * 售票的类，专管售票 */ class Solder extends Thread{ public final int id = counter++; public Solder(){ this.setName(\售票窗口\ } @Override public void run() { while(!this.isInterrupted()){ String ticket = getOneTicket(); if(ticket==null){ System.out.println(this.getName()+\票已售空，明天请早\ break; } System.out.println(this.getName()+\卖出了 \ try { TimeUnit.MILLISECONDS.sleep(random.nextInt(5000)); } catch (InterruptedException e) { e.printStackTrace(); } } } } } 输出结果 《JAVA程序设计》实验报告10

姓名 杨仕琴 学号 54121022 日期 10.13 实验题目 用JavaDB创建数据库myDB,在其中建立一个employee表。并输入相应数据。（1）用JDBC编写程序，显示employee表中所有男员工记录；（2）用 用JDBC编写程序，向employee 表中增加一条数据：2001，邢雪花，女，650。（3）用JDBC编写程序，将no值为2001的salary改为900，显示结果。 package unit10; import java.sql.Connection; 程序初稿 import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class MydbDemo { public static void main(String[] args) throws Exception { Class.forName(\Connection cn = null; cn = DriverManager.getConnection(\ Statement st = cn.createStatement(); cn.setAutoCommit(false);// st.execute(\table employee(no varchar(4),name varchar(8),sex varchar(2),salary float)\ st.execute(\into employee values('1001','张强','男',675.20)\ st.execute(\into employee values('1004','李香','女',842.00)\ st.execute(\into employee values('1001','王大山','男',765.00)\ st.execute(\into employee values('1001','赵玉花','女',690.00)\ ResultSet rs1 = st.executeQuery(\* FROM employee System.out.println(\创建员工表，插入四条记录\// 列出四条记录 where sex='男'\ System.out.println(\筛选出男性员工\while (rs1.next()) { StringBuilder builder = new StringBuilder(rs1.getString(1)); builder.append(\builder.append(rs1.getString(2)); builder.append(\builder.append(rs1.getString(3)); builder.append(\builder.append(rs1.getFloat(\