启动:startNetworkServer.bat
客户端:ij.bat
连接:
connect 'jdbc:derby://localhost:1527/../data/airlinesDB';
connect 'jdbc:derby://localhost:1527/D:/dev/server/javadb/data/airlinesDB';
connect 'jdbc:derby://localhost:1527/airlinesDB';
connect 'jdbc:derby:d:/Derby_data/mydb;create=true;territory=zh_CN;user=root
;password=root';
显示所有表:show tables;
清除数据:truncate table APP.SMSS;
显示连接:show connections;
退出:exit
查看表结构: describe test
中文问题:
连接时加上;territory=zh_CN
链接:Apache Derby