Re: MSSQL Server

/*
 * Created on 08/04/2005
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package joy.cadastros.bo;

import java.sql.*;

/**
 * @author amegale
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class test {
	
	private Connection conn;
	private PreparedStatement pstmt;
	private ResultSet rs;
	
	public void conecta(){
		try{
			Class.forName("org.gjt.mm.mysql.Driver");
			conn = DriverManager.getConnection("jdbc:mysql://localhost/BANCO_DE_DADOS?user=root&password=root");
		}
		catch(SQLException e){	
		}
		catch(ClassNotFoundException e){}
	}
	
	public void pesquisa(){
		this.conecta();
		
		try{
			pstmt = conn.prepareStatement("Select * from pelota where id = ?");
			pstmt.setInt(1 ,5); //substitui o interrogação :D
			rs = pstmt.executeQuery();
		}
		catch(SQLException e){}
	}

}