Skip to content

Instantly share code, notes, and snippets.

@greghelton
Created December 26, 2011 21:15
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save greghelton/1522128 to your computer and use it in GitHub Desktop.
Java: code to verify Java can connect to 1995 SQL Server Database
package old.school;
import java.sql.*;
/**
* run as follows:
* 1. javac OldSchoolJDBC.java
* 2. java OldSchoolJDBC
*/
public class OldSchoolJDBC {
Connection conn;
public OldSchoolJDBC() {}
public void connect() throws Exception {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc:odbc:windows-datasource-name",
"USERID", "PASSWORD");
}
public void query() throws Exception {
Statement stmt = conn.createStatement();
String qry = "SELECT * FROM sc_admin.abendcodesa4";
ResultSet rs = stmt.executeQuery(qry);
while (rs.next()) {
System.out.println(rs.getString(1));
}
}
public static void main(String[] args) {
try {
OldSchoolJDBC p = new OldSchoolJDBC();
p.connect();
p.query();
} catch (Exception e) {
e.printStackTrace();
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment