要在-服务–中将 目标数据库 打开
package tdb;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class TDB {
public static void main(String[] args) {
TDB tdb = new TDB();
tdb.connect();
}
Connection conn ;
Statement st ;
public int connect(){
String data = "jdbc:derby://localhost:1527/softDB";
try
{
conn = DriverManager.getConnection(data,"softDB","softDB");
st = conn.createStatement();
Class.forName("org.apache.derby.jdbc.ClientDriver");
return 1 ;
}catch(SQLException s){
System.out.println("SQL Error : " + s.toString() );
System.out.println("SQL Error : " + s.getErrorCode() );
System.out.println("SQL Error : " + s.getSQLState() );
}
catch (Exception e){
System.out.println("Error :" + e.toString() + e.getMessage());
}
return 0;
}
}