Java Configuration SQL2012

1, download the JDBC driver, install;

2. Right-click Src file build configuration path add Sqljdbc4.jar add external jar file

3. Re-Test

Package test;

Import java.sql.Connection;
Import Java.sql.DriverManager;
Import Java.sql.ResultSet;
Import java.sql.Statement;
Import java.sql.*;

public class Test_sql {

public static void Main (string[] args) {
Connection con = null;
Statement stmt = null;
ResultSet rs = null;

try {
Class.forName ("Com.microsoft.sqlserver.jdbc.SQLServerDriver");
SYSTEM.OUT.PRINTLN ("Load driver succeeded");
con = DriverManager
. getconnection (
"Jdbc:sqlserver://192.168.1.2:1433;databasename=dscfp2p",
"SA", "ABcd123");
SYSTEM.OUT.PRINTLN ("Connection succeeded");
String sql = "SELECT * from T_bankinfo";
stmt = Con.createstatement ();
rs = stmt.executequery (SQL);
while (Rs.next ()) {
System.out.println (rs.getstring (2) + "T" + rs.getstring (3)
+ "\ T" + rs.getstring (4) + "\ T" + rs.getstring (5));
}

} catch (Exception ex) {
System.out.println ("Connection failed");
Ex.printstacktrace ();

} finally {
if (rs! = null)
try {
Rs.close ();
} catch (Exception e) {

}
if (stmt! = null)
try {
Stmt.close ();
} catch (Exception e) {

}
if (con! = null)
try {
Con.close ();
} catch (Exception e) {

}
}
}
}

Java Configuration SQL2012