图4-2-2 添加SQLjdbc4.jar库
在NetBeans中编写Java代码，实现连接
public static Connection getConnection(String driverClassName, String dbURL, String userName, String password) throws ClassNotFoundException, SQLException { //实现连接数据库 Connection con = null; Class.forName(driverClassName); con = DriverManager.getConnection(dbURL, userName, password); return con; } public static Connection linkDataBase() throws ClassNotFoundException, SQLException {//传递参数给连接函数 String mySQLDirver = \ String dbName = \ String userName = \ String password = \ Connection con = getConnection(mySQLDirver, dbName, userName, password); return con; } 表4-2-1 代码实现连接
4.3. 代码实现对数据库的操作
以下代码为在数据库中新建Service、Provider、ServiceRecord表，并为
其添加属性
String Service = \ + \// + \ + \ boolean execute = stmt.execute(Service); String ServiceRecord = \ + \ + \BINARY(31),\\BINARY(31),\ + \ + \ boolean stmt.execute(ServiceRecord); String Provider = \ + \ + CHAR(14),\ + CHAR(1),\ + \ boolean execute_Provider = stmt.execute(Provider); String Provider = \ + \ + CHAR(14),\ + CHAR(1),\\CHAR(10),\CHAR(10),\\CHAR(25),\CHAR(10),\\CHAR(10),\CHAR(10),\\CHAR(25),\CHAR(10),\execute_ServiceRecord = + \ boolean execute_Provider = stmt.execute(Provider); 表4-3-1在数据库中新建表
以下代码可以在任何表中插入数据，分别对各个表的元素类型做判断，可以把传过来的数据拆分，进行插入对应的表中。
if (Member.equals(\ for (int i = 0; i < table.length; i++) { if (table[i] == null) { break;//设置一个机制，如果table为空，则返回 } System.out.println(\ split1 = table[i].split(\把数组表table按“#”分割，然后赋值给split1 for (int n = 0; n < count; n++) { if (n == count - 1) {//最后一个的时候，则加括号 value = value + split1[n] + \ break; } value = value + \+ split1[n] + \+ \最后储存的类似 'zhangsan',12,34,6)的内容 } //System.out.println(value); insertSQL = insertSQL + value;//此时，inertSQL才完整保存着要执行的插入语句 int affects; //System.out.println(insertSQL); affects = stmt.executeUpdate(insertSQL); rs = stmt.executeQuery(querySQL); value = \赋空， insertSQL = insertSQL_temp; } // while (rs.next()) { // for (int p = 1; p <= count; p++) { // System.out.print(rs.getString(p)); // } // System.out.println(); // } } if (Member.equals(\ // Date date = new java.util.Date(); //java.sql.Date sqlDate = new java.sql.Date(date.getTime()); for (int i = 0; i < table.length; i++) { if (table[i] == null) { break;//设置一个机制，如果table为空，则返回 } split1 = table[i].split(\把数组表table按“#”分割，然后赋值给split1 for (int n = 0; n < count; n++) { if (n == count - 1) {//最后一个的时候，则加括号 SimpleDateFormat sim = new SimpleDateFormat(\ //String str = \ Date d = sim.parse(split1[n]); String date_str = sim.format(d); value = value + \+ date_str + \+ \ break; } if (n == 0) { SimpleDateFormat sim = new SimpleDateFormat(\ //String str = \ Date d = sim.parse(split1[n]); String date_str = sim.format(d); value = value + \+ date_str + \+ \ continue; } if (n == 2 || n == 3) { value = value + split1[n] + \ continue; } value = value + \+ split1[n] + \+ \最后储存的类似 'zhangsan',12,34,6)的内容 } System.out.println(value); insertSQL = insertSQL + value;//此时，inertSQL才完整保存着要执行的插入语句 int affects;