Guest User

MMSQL connection java code

a guest
Mar 6th, 2017
48
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.69 KB | None | 0 0
  1. import java.sql.DriverManager;
  2. import java.sql.Connection;
  3. import java.sql.ResultSet;
  4. import java.sql.SQLException;
  5. import java.sql.Statement;
  6.  
  7. public class Main {
  8.  
  9.     public static void main(String[] args) throws SQLException, ClassNotFoundException {
  10.         Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); 
  11.         Connection conn = DriverManager.getConnection("jdbc:sqlserver://HOSP_SQL1.company.com;user=name;password=abcdefg;database=Test");
  12.         System.out.println("test");
  13.         Statement sta = conn.createStatement();
  14.         String Sql = "select * from testing_table";
  15.         ResultSet rs = sta.executeQuery(Sql);
  16.         while (rs.next()) {
  17.             System.out.println(rs.getString("txt_title"));
  18.         }
  19.     }
  20. }
Add Comment
Please, Sign In to add comment