JavaDb入门（1）

hxg1026

package org.hank;import java.sql.Connection;import java.sql.DriverManager;import java.sql.Statement;public class JavaDBDemo {static Connection conn;public static void main(String[] args) {String driver = "org.apache.derby.jdbc.EmbeddedDriver";String connectionURL = "jdbc:derby:myDatabase;create=true";String createString = "CREATE TABLE Employee (NAME VARCHAR(32) NOT NULL, ADDRESS VARCHAR(50) NOT NULL)";//String dropTableStr = "Drop table CONTACTS";try {Class.forName(driver);} catch (java.lang.ClassNotFoundException e) {e.printStackTrace();}try {conn = DriverManager.getConnection(connectionURL);// 执行创建数据库Statement stmt = conn.createStatement();stmt.executeUpdate(createString);// 新增表记录//PreparedStatement psInsert = conn.prepareStatement("insert into Employee values (?,?)");//psInsert.setString(1, "hank");//psInsert.setString(2, "123");////psInsert.executeUpdate();//          // 查询表记录//Statement stmt2 = conn.createStatement();//ResultSet rs = stmt2.executeQuery("select * from Employee");//int num = 0;//while (rs.next()) {//System.out.println(++num + ": Name: " + rs.getString(1)//+ "\n Address:" + rs.getString(2));//}//// 删除表记录//PreparedStatement del = conn.prepareStatement("Delete from Employee");//del.executeUpdate();//rs.close();} catch (Exception e) {e.printStackTrace();}}}