如何在eclipse中配置javadb? [英] How to configure javadb in eclipse?
本文介绍了如何在eclipse中配置javadb?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我试过一个关于数据库的简单代码,但它给我这个错误 - >错误:没有找到适合的驱动程序jdbc:derby:CoffeeDB; create = true
package Practice;
import java.sql.*;
public class Practice {
public static void main(String[]args)throws Exception{
final String DB_URL = "jdbc:derby:CoffeeDB;create=true";
try{
Connection conn = DriverManager.getConnection(DB_URL);
Statement stmt = conn.createStatement();
String sql = ("CREATE TABLE Coffee(Description CHAR(25),Prod Num CHAR(10) NOT NULL PRIMARY KEY,Price DOUBLE)");
stmt.execute(sql);
sql = "INSERT INTO Coffee VALUES('Bolivian Dark','14-001',8.95)";
stmt.executeUpdate(sql);
sql = "INSERT INTO Coffee VALUES('Bolivian Medium','14-002',8.95)";
stmt.executeUpdate(sql);
sql = "INSERT INTO Coffee VALUES('Brazilian Dark','15-001',7.95)";
stmt.executeUpdate(sql);
sql = "INSERT INTO Coffee VALUES('Brazilian Medium','15-002',7.95)";
stmt.executeUpdate(sql);
sql = "INSERT INTO Coffee VALUES('Brazilian Decaf','15-003',8.55)";
stmt.executeUpdate(sql);
sql = "INSERT INTO Coffee VALUES('Central American Dark','16-001',9.95)";
stmt.executeUpdate(sql);
sql = "INSERT INTO Coffee VALUES('Central American Medium','16-002',9.95)";
stmt.executeUpdate(sql);
sql = "INSERT INTO Coffee VALUES('Sumatra Dark','17-001',7.95)";
stmt.executeUpdate(sql);
sql = "INSERT INTO Coffee VALUES('Sumatra Decaf','17-002',8.95)";
stmt.executeUpdate(sql);
sql = "INSERT INTO Coffee VALUES('Sumatra Medium','17-003',7.95)";
stmt.executeUpdate(sql);
sql = "INSERT INTO Coffee VALUES('Sumatra Organic Dark','17-004',11.95)";
stmt.executeUpdate(sql);
sql = "INSERT INTO Coffee VALUES('Kona Medium','18-001',18.45)";
stmt.executeUpdate(sql);
sql = "INSERT INTO Coffee VALUES('Kona Dark','18-002',18.45)";
stmt.executeUpdate(sql);
sql = "INSERT INTO Coffee VALUES('French Roast Dark','19-001',9.65)";
stmt.executeUpdate(sql);
sql = "INSERT INTO Coffee VALUES('Galapagos Medium','20-001',6.85)";
stmt.executeUpdate(sql);
sql = "INSERT INTO Coffee VALUES('Guatemalan Dark','21-001',9.95)";
stmt.executeUpdate(sql);
sql = "INSERT INTO Coffee VALUES('Guatemalan Decaf','21-002',10.45)";
stmt.executeUpdate(sql);
sql = "INSERT INTO Coffee VALUES('Guatemalan Medium','21-003',9.95)";
stmt.executeUpdate(sql);
String sqlStatement = "SELECT Description FROM Coffee";
ResultSet result = stmt.executeQuery(sqlStatement);
System.out.println("Coffees found in the Database");
System.out.println("-----------------------------");
while(result.next()){
System.out.println(result.getString("Description"));
}
conn.close();
}catch(Exception ex){
System.out.println("ERROR: " + ex.getMessage());
}
}
}
我一步一步的如何配置这个过程?
推荐答案
Download the driver Derby driver, if I remeber correcly it is the derby.jar (add it to class path)
在连接注册驱动程序之前
Before connecting register the driver
Driver driver = (Driver) Class.forName("org.apache.derby.jdbc.EmbeddedDriver")
.newInstance();
DriverManager.registerDriver(driver);
metodo抛出Class.forName异常
You need to do try catch or have your metodo throw the Class.forName exception
更多信息,请查看 SQLException:找不到适用于jdbc:derby:// localhost:1527的驱动程序
这篇关于如何在eclipse中配置javadb?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文