//package com.james.test;
import java.sql.*;
//import org.apache.derby.jdbc.*;
import java.util.Properties;
class DerbyTestDBClient{
public static void main(String[] args){
DerbyTestDBClient testClient = new DerbyTestDBClient();
testClient.showZipCodes();
}
public void showZipCodes()
{
String sql = "select * from zipcodes";
String driver = "org.apache.derby.jdbc.EmbeddedDriver";
//String url = "jdbc:derby://127.0.0.1:1527/DerbyTestDB";
//String url = "jdbc:derby:DerbyTestDB;create=true";
String url = "jdbc:derby:E:/database/db-derby-10.5.1.1-bin/bin/DerbyTestDB";//实际环境中的db位置
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try{
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url);
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
while(rs.next()){
System.out.println("City : " + rs.getString(1));
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception e){
System.out.println("Exception: " + e);
e.printStackTrace();
}
}
}
java jdbc derby
最新推荐文章于 2023-03-24 16:27:34 发布