import java.sql.*; public class Student { public static void main(String[] args) { Connection dbConnection = null; String dbUrl = "jdbc:derby:C:\\Sun\\SDK\\javadb\\bin\\student;"+ "user=profesor;password=parolaprofesor"; try{ Class.forName("org.apache.derby.jdbc.EmbeddedDriver"); //incarca driver JDBC pt JavaDB } catch(ClassNotFoundException e) { e.printStackTrace(); System.out.println("Eroare incarcare driver!\n" + e); } try{ dbConnection=DriverManager.getConnection(dbUrl); Statement stmt= dbConnection.createStatement(); ResultSet rs = stmt.executeQuery( " SELECT * FROM student"); while (rs.next()) { System.out.println ( rs.getString ("nume") + "," + rs.getString ("prenume") + "," + rs.getString ("email")); } stmt.close(); } catch(SQLException e) { e.printStackTrace(); } } }Programul se execută precizând în linia de comandă pentru maşina virtuală Java calea către driverul Java DB pentru SQL(derby.jar):
java -classpath .;C:\Sun\SDK\javadb\lib\derby.jar Student
No comments:
Post a Comment