This shows you the differences between two versions of the page.
— |
javasqlserver [2014/10/25 21:52] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ==== JDBC to connect to SQL server ==== | ||
+ | <code lang="java"> | ||
+ | import java.sql.*; | ||
+ | |||
+ | public class ConnectURL { | ||
+ | |||
+ | public static void main(String[] args) { | ||
+ | |||
+ | // Create a variable for the connection string. | ||
+ | String connectionUrl = "jdbc:sqlserver://SC068568\\SQLEXPRESS;" + | ||
+ | "user=SA;" + | ||
+ | "password=oracle"; | ||
+ | |||
+ | System.out.println("connectionUrl : "+connectionUrl); | ||
+ | // Declare the JDBC objects. | ||
+ | Connection con = null; | ||
+ | Statement stmt = null; | ||
+ | ResultSet rs = null; | ||
+ | |||
+ | try { | ||
+ | // Establish the connection. | ||
+ | Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); | ||
+ | con = DriverManager.getConnection(connectionUrl); | ||
+ | |||
+ | // Create and execute an SQL statement that returns some data. | ||
+ | String SQL = "SELECT * FROM FDCA.dbo.Asset"; | ||
+ | stmt = con.createStatement(); | ||
+ | rs = stmt.executeQuery(SQL); | ||
+ | ResultSetMetaData rsmd = rs.getMetaData(); | ||
+ | for (int i=1; i<=rsmd.getColumnCount(); i++) { | ||
+ | System.out.print(rsmd.getColumnName(i)+","); | ||
+ | } | ||
+ | System.out.println(); | ||
+ | // System.out.println(rs.getRow()); | ||
+ | |||
+ | // Iterate through the data in the result set and display it. | ||
+ | while (rs.next()) { | ||
+ | System.out.println(rs.getRow() + " : " +rs.getString(1)+" "+rs.getString(2)); | ||
+ | } | ||
+ | } | ||
+ | |||
+ | // Handle any errors that may have occurred. | ||
+ | catch (Exception e) { | ||
+ | e.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) {} | ||
+ | } | ||
+ | } | ||
+ | } | ||
+ | </code> | ||
+ | ---- | ||
+ | * [[javainfo|Back to Java]] | ||