Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.Statement;
- import com.microsoft.sqlserver.jdbc.SQLServerDriver;
- public class SqlConnections {
- public static void main(String[] args) {
- try
- {
- //Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
- DriverManager.registerDriver( new SQLServerDriver() );
- String userName = "xxx";
- String password = "xxx";
- String url = "jdbc:sqlserver://server=10.xxx.xx.xx\SQLEXPRESS;database=BTP_NYA";
- Connection con = DriverManager.getConnection(url, userName, password);
- Statement s1 = con.createStatement();
- ResultSet rs = s1.executeQuery("SELECT TOP 1 * FROM [BTP_TEST].[xx].[ers]");
- String[] result = new String[20];
- } catch (Exception e)
- {
- e.printStackTrace();
- }
- }
- }
Add Comment
Please, Sign In to add comment