java db derby==安装和使用,java连接使用

下载解压
Apache Derby: Downloads

 

 cd到bin目录，执行startNetworkServer.bat

  cd到bin目录，执行ij.bat

创建数据库并连接，注意这一串地址D:\develop\db-derby-10.14.2.0-bin\bin\firstdb要跟解压后的目录对得上，否则会说权限不足

Connect 'jdbc:derby://localhost:1527/D:\develop\db-derby-10.14.2.0-bin\bin\firstdb;user=root;password=root;create=true;' ;

 存放数据库内容的文件

 ====================

常用SQL:

CREATE TABLE mytable (
  id INT PRIMARY KEY,
  name VARCHAR(50),
  age INT
);

INSERT INTO mytable (id, name, age)
VALUES (1, 'John Doe', 25);

INSERT INTO mytable (id, name, age)
VALUES (2, 'Jane Smith', 30);

SELECT * FROM mytable;

UPDATE mytable
SET age = 26
WHERE id = 1;

==============================

java代码连接刚才创建的数据库

拷贝这三个作为依赖包

 

编写代码

 

package org.example;

import java.sql.*;

public class MyDatabaseDemo {
    public static void main(String[] args) throws ClassNotFoundException {
//        String dbUrl = "jdbc:derby://localhost:1527/D:\\develop\\db-derby-10.14.2.0-bin\\bin\\firstdb";
        String dbUrl = "jdbc:derby://localhost:1527/firstdb;user=root;password=root;create=true;";

        try (Connection connection = DriverManager.getConnection(dbUrl)) {
            // 创建Statement对象
            Statement statement = connection.createStatement();

            // 插入数据
            statement.executeUpdate("INSERT INTO mytable (id, name, age) VALUES (111, 'John Doe', 25)");

            // 查询数据
            ResultSet resultSet = statement.executeQuery("SELECT * FROM mytable");
            while (resultSet.next()) {
                int id = resultSet.getInt("id");
                String name = resultSet.getString("name");
                int age = resultSet.getInt("age");
                System.out.println("ID: " + id + ", Name: " + name + ", Age: " + age);
            }

            // 关闭资源
            resultSet.close();
            statement.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

执行成功