[[javasqlserver]]
Differences
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]] | ||
