You probably already found a solution, but you can download a jar file containing the SQL driver here:
http://jtds.sourceforge.net/
Here is some source code that uses that database driver to obtain a basic connection to an SQLServer. This particular connection allows you to scroll around in a resultset:
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class ConnectToDBScroll
{
private Connection conn=null;
public ConnectToDBScroll(){
try{conn = getConnection();
}catch (SQLException ex)
{
while (ex != null)
{
ex.printStackTrace();
ex = ex.getNextException();
}
}catch (IOException ex)
{
ex.printStackTrace();
}
}
public void closeConnection(){
try{
conn.close();
System.out.println("Connection Closed");
}catch (SQLException ex){
while (ex != null)
{ex.printStackTrace();
ex = ex.getNextException();
}
}
}
public ResultSet runQuery(String theQuery){
ResultSet rs = null;
try
{
Statement stat = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSI TIVE,ResultSet.CONCUR_READ_ONLY);
rs = stat.executeQuery(theQuery);
}
catch (SQLException ex)
{
while (ex != null)
{
ex.printStackTrace();
ex = ex.getNextException();
}
}
return rs;
}
// This is used to update a Table with a new row.
public boolean makeUpdate(String theQuery)
{
boolean check = false;
try
{
Connection conn = getConnection();
Statement stat = conn.createStatement();
int x = stat.executeUpdate(theQuery);
if(x > 0)
check = true;
conn.close();
}
catch (SQLException ex)
{
while (ex != null)
{
ex.printStackTrace();
ex = ex.getNextException();
}
}
catch (IOException ex)
{
ex.printStackTrace();
}
return check;
}
/* Gets a connection from the properties specified
in the file database.properties and returns the
database connection
*/
//this is for mysql, sqlserver below
//jdbc.drivers=com.mysql.jdbc.Driver
//jdbc.url=jdbc:mysql://servername.domain.prefix:port/databasename
//jdbc.username=yourusername
//jdbc.password=yourpassword
public static Connection getConnection()
throws SQLException, IOException
{
try{
Class.forName("net.sourceforge.jtds.jdbc.Driver");
}
catch (Exception ex) {
System.out.println("failed");
}
//jdbc:jtds:<server_type>://<server>[:<port>][/<database>][;<property>=<value>[;...]]
String url = "jdbc:jtds:sqlserver://server:port/database;User=username;Password=password";
Connection conn = DriverManager.getConnection(url);
return DriverManager.getConnection(url);
}
}
As for the gui part, you have to build that yourself. There is probably a Java API that does this for you. The easiest thing to do is to use an Object[][] to hold the Resultset data. You can use that Object[][] to build a TableModel, and then use that TableModel to build a JTable. You can then use the JTable in a GUI. You could also find an API that does this for you.