软件演讲.pptxVIP

数据库设计在数据库中插入表 String Provider = CREATE TABLE Provider ( + number BINARY(31), + Name CHAR(25), + Street CHAR(25),+City CHAR(10),+State CHAR(14), + Zip CHAR(10),+Email CHAR(10),+Status CHAR(1), + ); boolean execute_Provider = stmt.execute(Provider);Provider ( number BINARY(31), Name CHAR(25),Street CHAR(25),City CHAR(10),State CHAR(14),Zip CHAR(10),Email CHAR(10),Status CHAR(1),)删除数据 String deleteSQL = DELETE FROM + Member + where + rsmd.getColumnLabel(2) + !=‘~; //控制 使member表的第一列 不为~的数据删除 int affects; affects = stmt.executeUpdate(deleteSQL); rs = stmt.executeQuery(querySQL);读取数据 while (rs.next()) { Data[j] = ; for (int i = 1; i = count; i++) { if (i == count) { Data[j] = Data[j] + rs.getString(i); break; } Data[j] = Data[j] + rs.getString(i) + #; //System.out.println(steve: +Data[j]); } System.out.println(steve: + Data[j]); j++;Return Data;插入数据元素INSERT INTO ServiceRecord(ServiceRecord.submissionDate,ServiceRecord.serviceCode,ServiceRecord.providerNumber,ServiceRecord.memberNumber,ServiceRecord.serviceDate) VALUES ( 09-06-2015 12:00:00, steve,34.9,34,09-06-2015) for (int i = 1; i = count; i++) {//构造插入字符串 title[i - 1] = rsmd.getColumnLabel(i);//把列属性存储到title数组，第一列的属性对应的是title的第0个元素 if (i == count) { attribute = attribute + Member + . + title[i - 1] + );//最后一个属性，故需要加括号 break; } attribute = attribute + Member + . + title[i - 1] + ,;//之前的都加, // System.out.print(title + \t); }