IT Program/Android Programming

How to Connect Database in Microsoft SQL?

Theo Kim 2011. 8. 6. 14:58


The programming which is related database in Android is same with JAVA programming.

1. To Include JDBC driver for Microsoft SQL in Android Project.
    (File Name : sqljdbc4.jar)
 



2. To confirm the driver.
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

3. To connect the Microsoft Server.
Connection con = DriverManager.getConnection(connectionUrl);

4. To do something.
Statement stmt = con.createStatement();
String SQL = "SELECT * FROM ...";
stmt.executeQuery(SQL);