Conexión con Base de Datos (MySQL,PostgreSQL, DB2)

Libreria

DataBase.jar by Leyer

http://www.mediafire.com/?b0nr1k7rxv14hj5

Soporte

= “com.mysql.jdbc.Driver”;

= “COM.ibm.db2.jdbc.app.DB2Driver”;

= “org.postgresql.Driver”;

Ejemplo:

import java.sql.ResultSet;
import java.sql.SQLException;
import com.leyer.database.DataBase;

public class Test extends DataBase{

	public Test(String jdbc, String url, String user, String password) {
		super(jdbc, url, user, password);
		if(openConnection()){
			String stringSql = "insert into prueba (user,password) values ('usuario','123456');";
			executeUpdate(stringSql);
			closeConnection();
		}
		openConnection();
			String stringSql = "SELECT * FROM prueba;";
			ResultSet r = executeQuery(stringSql);
			try {
				while(r.next()){
					System.out.println(r.getString(2));
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			closeConnection();
	}
	public static void main(String[] args) {
		new Test(DataBase.MYSQL, "//localhost/BD", "root", "mysqladmin");
	}
}