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();
}
}
}
JavaDb入门(1)
最新推荐文章于 2024-03-06 11:24:03 发布