Acceder Registrarme

Conexión JDBC a base de datos SqlServer en Java


Por: Kevin Arnold Arias Figueroa Publicado el: 2017-06-30 02:57:59
public class Conexion
{
	public static Connection getConnection()
	{
		Connection connection=null;
		String databaseName="dbpersona";
		String user="sa";
		String password="030191";
		
		try
		{
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			String connectionString="jdbc:sqlserver://localhost;databaseName="+databaseName+";user="+user+";password="+password+";";
			connection=DriverManager.getConnection(connectionString);
		}
		catch(ClassNotFoundException ex)
		{			
			connection=null;
		}
		catch(SQLException ex)
		{			
			connection=null;
		}
		catch(Exception ex)
		{			
			connection=null;
		}
		
		return connection;
	}
}