Advertisement
Guest User

Untitled

a guest
Jun 26th, 2017
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.67 KB | None | 0 0
  1. package st.dbtest;
  2.  
  3. import java.sql.*;
  4.  
  5. public class AppSelect {
  6.     public static void main(String[] args) throws ClassNotFoundException, SQLException {
  7.         Class.forName("com.sybase.jdbc4.jdbc.SybDriver");
  8.         Connection sourceConn = DriverManager.getConnection("jdbc:sybase:Tds:DESKTOP-KHT818A:5000/cenveo", "sa", "desktop");
  9.         String selectTableSQL = "sp_configure 'enable file access'";
  10.         Statement statement = sourceConn.createStatement();
  11.         ResultSet rs = statement.executeQuery(selectTableSQL);
  12.         while (rs.next()) {
  13.             System.out.print(rs.getString("Config Value"));
  14.         }
  15.  
  16.         sourceConn.close();
  17.     }
  18. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement