Advertisement
Guest User

Untitled

a guest
Mar 29th, 2017
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.01 KB | None | 0 0
  1. Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  2.  
  3. Connection conn = null;
  4. Statement statement = null;
  5. ResultSet rs = null;
  6. try{
  7. Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  8. String connectionUrl = "jdbc:sqlserver://<server_name>:1433;databaseName=<db_name>;integratedSecurity=true;user=<user>;password=<***>";
  9. conn = DriverManager.getConnection(connectionUrl);
  10. statement = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
  11. rs = statement.executeQuery(query1 + itemTag + query2);
  12. while(rs.next()){
  13. String number = rs.getString(1);
  14. tableItem.setText(7, number);
  15. break;
  16. }
  17. }catch (SQLException e) {
  18. e.printStackTrace();
  19. } catch (ClassNotFoundException e) {
  20. e.printStackTrace();
  21. }finally {
  22. if (rs != null) try { rs.close(); } catch(Exception e) {}
  23. if (statement != null) try { statement.close(); } catch(Exception e) {}
  24. if (conn != null) try { conn.close(); } catch(Exception e) {}
  25. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement