myeclipse 连接 derby

xiaoxiao2024-04-19  20

首先得把MYECLIPSE自带的JDK的DERBY数据库的JAR文件给导入工程,反正没事把几个都导进来,如下: derby.jar,derbyclient.jar,derbynet.jar,derbyrun.jar,derbytools.jar. myelipse  里 的DB Browser已经自带了myeclipse derby,直接启动服务,然后在app 的table建表,如videoinfo. 写连接数据的类,如下。

import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import org.apache.derby.impl.sql.compile.StaticClassFieldReferenceNode; public class DBmanager { public static void main(String[] args) throws Exception { Class.forName("org.apache.derby.jdbc.ClientDriver"); Connection conn = java.sql.DriverManager.getConnection( "jdbc:derby://localhost:1527/MyEclipse", "classiccars", "classiccars"); Statement stmt = conn.createStatement(); ResultSet rs = stmt .executeQuery("select v.id, v.name,v.videopath from app.videoinfo v"); while (rs.next()) { System.out.print(rs.getString("id") + "; " + rs.getString("name")); System.out.println(" "); } rs.close(); stmt.close(); conn.close(); } }

 测试成功

 

相关资源:myeclipse本地方式连接Derby
转载请注明原文地址: https://www.6miu.com/read-5015089.html

最新回复(0)