import java.sql.*;


public class BD {
	private String driver;
	private String connString;
	private String user;
	private String pass;
	private Statement stmt;
	
	public BD(String driver, String conStr, String user, String pass) {
		this.driver = driver;
		this.connString = conStr;
		this.user = user;
		this.pass = pass;
	}

	public void connect() {
		try {
			Class.forName(driver);
			Connection con = DriverManager.getConnection(connString,user,pass);
			stmt = con.createStatement();					
		} catch(Exception ex) {
			System.out.println("eroare la connect:"+ex.getMessage());
		}
	}

	public void showData() {
		try {
			//System.out.println("stmt="+stmt);
			ResultSet rs = stmt.executeQuery("select * from Carti");
			//System.out.println("rs="+rs);
			while(rs.next()) {
				System.out.println(rs.getInt("codc")+"  "+rs.getString("titlu")+"  "+rs.getString("autor"));
			}
		} catch(Exception ex) {
			System.out.println("eroare la showData:"+ex.getMessage());
		}

	}


	public static void main(String args[]) {
		//BD bd = new BD("sun.jdbc.odbc.JdbcOdbcDriver","jdbc:odbc:mybd","di29850","di29850");
		BD bd = new BD("sun.jdbc.odbc.JdbcOdbcDriver","jdbc:odbc:bd1","","");
		bd.connect();
		bd.showData();	
	}
}