Como criar uma conexão com o Postgres?

Segue um modelo que uso para uma pequena aplicação em postgres
Lembro que a porta padrão é a 5432

No netbeans acredito que é só colocar a url no lugar certo que ele faz a conexao.

public class ConnectionFactory {

public static Connection getConnection () throws SQLException {
	try {
		Class.forName("org.postgresql.Driver");
		return DriverManager.getConnection("jdbc:postgresql://10.100.12.1:5432/banco","usuario", "senha");
		                                    
	}catch ( ClassNotFoundException e){
		throw new SQLException ( e.getMessage());
	}
}

}

Talvez esse link possa ajudar, Albama:
http://www.guj.com.br/posts/list/78569.java#416181

Espero ter ajudado. 8)

Galera agradeço pela ajuda…
Porem como tinha dito sou novato não sei muita coisa mesmo o meu codigo ta assim aonde eu coloco o codigo que você me passou.

/*

• Page1.java
• Created on 16/10/2008, 13:52:55
  */

package protocoloweb;

import com.sun.rave.web.ui.appbase.AbstractPageBean;

import com.sun.webui.jsf.component.Body;

import com.sun.webui.jsf.component.Button;

import com.sun.webui.jsf.component.Form;

import com.sun.webui.jsf.component.Head;

import com.sun.webui.jsf.component.Html;

import com.sun.webui.jsf.component.Label;

import com.sun.webui.jsf.component.Link;

import com.sun.webui.jsf.component.Page;

import com.sun.webui.jsf.component.TextField;

import javax.faces.FacesException;

import java.sql.*;

/**

• Page bean that corresponds to a similarly named JSP page. This

• class contains component definitions (and initialization code) for

• all components that you have defined on this page, as well as

• lifecycle methods and event handlers where you may add behavior

• to respond to incoming events.

• @author h-marques
  */
  public class Page1 extends AbstractPageBean {
  //

  /**

  • Automatically managed component initialization. WARNING:

  • This method is automatically generated, so any user-specified code inserted
  • here is subject to being replaced.
    */
    private void _init() throws Exception {
    }

  private Page page1 = new Page();

  public Page getPage1() {
  
  return page1;
  
  }
  

  public void setPage1(Page p) {
  
  this.page1 = p;
  
  }
  

  private Html html1 = new Html();

  public Html getHtml1() {
  
  return html1;
  
  }
  

  public void setHtml1(Html h) {
  
  this.html1 = h;
  
  }
  

  private Head head1 = new Head();

  public Head getHead1() {
  
  return head1;
  
  }
  

  public void setHead1(Head h) {
  
  this.head1 = h;
  
  }
  

  private Link link1 = new Link();

  public Link getLink1() {
  
  return link1;
  
  }
  

  public void setLink1(Link l) {
  
  this.link1 = l;
  
  }
  

  private Body body1 = new Body();

  public Body getBody1() {
  
  return body1;
  
  }
  

  public void setBody1(Body b) {
  
  this.body1 = b;
  
  }
  

  private Form form1 = new Form();

  public Form getForm1() {
  
  return form1;
  
  }
  

  public void setForm1(Form f) {
  
  this.form1 = f;
  
  }
  
  private Button btnVerifica = new Button();
  

  public Button getBtnVerifica() {
  
  return btnVerifica;
  
  }
  

  public void setBtnVerifica(Button b) {
  
  this.btnVerifica = b;
  
  }
  
  private Label lbllcodigo = new Label();
  

  public Label getLbllcodigo() {
  
  return lbllcodigo;
  
  }
  

  public void setLbllcodigo(Label l) {
  
  this.lbllcodigo = l;
  
  }
  
  private TextField txcodigo = new TextField();
  

  public TextField getTxcodigo() {
  
  return txcodigo;
  
  }
  

  public void setTxcodigo(TextField tf) {
  
  this.txcodigo = tf;
  
  }
  
  private Label lblstatus = new Label();
  

  public Label getLblstatus() {
  
  return lblstatus;
  
  }
  

  public void setLblstatus(Label l) {
  
  this.lblstatus = l;
  
  }
  

  //

  /**

  • Construct a new Page bean instance.

  */

  public Page1() {
  }

  /**

  • Callback method that is called whenever a page is navigated to,

  • either directly via a URL, or indirectly via page navigation.

  • Customize this method to acquire resources that will be needed

  • for event handlers and lifecycle methods, whether or not this

  • page is performing post back processing.

  • Note that, if the current request is a postback, the property

  • values of the components do not represent any

  • values submitted with this request. Instead, they represent the

  • property values that were saved for this view when it was rendered.

    
    */
    @Override
    public void init() {
    // Perform initializations inherited from our superclass
    super.init();
    // Perform application initialization that must complete
    // before managed components are initialized
    // TODO - add your own initialiation code here

    // 
    
    // Initialize automatically managed components
    
    // <em>Note</em> - this logic should NOT be modified
    
    try {
    
    _init();
    
    } catch (Exception e) {
    
    log(“Page1 Initialization Failure”, e);
    
    throw e instanceof FacesException ? (FacesException) e: new FacesException(e);
    
    }
    

    //
    // Perform application initialization that must complete
    // after managed components are initialized
    // TODO - add your own initialization code here
    }

  /**

  • Callback method that is called after the component tree has been

  • restored, but before any event processing takes place. This method
  • will only be called on a postback request that
  • is processing a form submit. Customize this method to allocate
  • resources that will be required in your event handlers.
    */
    @Override
    public void preprocess() {
    }

  /**

  • Callback method that is called just before rendering takes place.

  • This method will only be called for the page that
  • will actually be rendered (and not, for example, on a page that
  • handled a postback and then navigated to a different page). Customize
  • this method to allocate resources that will be required for rendering
  • this page.
    */
    @Override
    public void prerender() {
    }

  /**

  • Callback method that is called after rendering is completed for

  • this request, if init() was called (regardless of whether
  • or not this was the page that was actually rendered). Customize this
  • method to release resources acquired in the init(),
  • preprocess(), or prerender() methods (or
  • acquired during execution of an event handler).
    */
    @Override
    public void destroy() {
    }

  /**

  • Return a reference to the scoped data bean.

  • @return reference to the scoped data bean
    */
    protected SessionBean1 getSessionBean1() {
    return (SessionBean1) getBean(“SessionBean1”);
    }

  /**

  • Return a reference to the scoped data bean.

  • @return reference to the scoped data bean
    */
    protected RequestBean1 getRequestBean1() {
    return (RequestBean1) getBean(“RequestBean1”);
    }

  /**

  • Return a reference to the scoped data bean.

  • @return reference to the scoped data bean
    */
    protected ApplicationBean1 getApplicationBean1() {
    return (ApplicationBean1) getBean(“ApplicationBean1”);
    }

  public class ConnectionFactory {

}
public String btnVerifica_action() {

return null;
}

}

Eu te sugiro dar uma olhada no Hibernate. Facilita muito a vida do desenvolvedor.