Programacion

Conectar base de datos con java
package beastieux.gui;

import java.sql.Connection;
import java.sql.DriverManager;import java.sql.Statement;
import java.sql.ResultSet;
import javax.sql.rowset.CachedRowSet;
import com.sun.rowset.CachedRowSetImpl;/**
*
* @author beastieux
*/
public class Ejm12_ConectarDataBase {

public CachedRowSetFunction(String sql)
{
try
{
Class.forName("Driver");String url = "jdbc:motor:servidor:puerto/basededatos";
Connection con = DriverManager.getConnection(url, "usuario","contraseña");Statement s = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);ResultSet rs= s.executeQuery(sql);

CachedRowSet crs = new CachedRowSetImpl();crs.populate(rs);

rs.close();
s.close();con.close();

return crs;

}
catch(Exception e){
System.out.println(e.getMessage());
}

return null;
}...