Guest User

Untitled

a guest
Nov 10th, 2017
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.64 KB | None | 0 0
  1. Exception in thread "main" java.lang.NoClassDefFoundError: javax/xml/bind/DatatypeConverter
  2.  
  3. public static void main(String[] args) {
  4. try
  5. {
  6. Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  7.  
  8. String userName = "sa";
  9. String password = "34erdfcV";
  10. String url = "jdbc:sqlserver://адрессервера"+";databaseName=имяБД";
  11. Connection con = (Connection) DriverManager.getConnection(url, userName, password);
  12. Statement s1 = ((java.sql.Connection) con).createStatement();
  13.  
  14.  
  15. ResultSet rs = s1.executeQuery("SELECT TOP (1000) [idBuildings]rn" +
  16. " ,[lat1]rn" +
  17. " ,[lon1]rn" +
  18. " ,[id2gis]rn" +
  19. " ,[lat2]rn" +
  20. " ,[lon2]rn" +
  21. " ,[route1]rn" +
  22. " ,[DistanceP]rn" +
  23. " ,[DistanceM]rn" +
  24. " ,[TimeP]rn" +
  25. " ,[TimeM]rn" +
  26. " ,[PolygonP]rn" +
  27. " ,[PolygonM]rn" +
  28. " ,[Radius]rn" +
  29. " FROM [ast_2gis].[dbo].[rn_allRoutesNew]");
  30.  
  31. String[] result = new String[20];
  32. if(rs!=null){
  33. while (rs.next()){
  34. for(int i = 0; i <result.length ;i++)
  35. {
  36. for(int j = 0; j <result.length;j++)
  37. {
  38. result[j]=rs.getString(i);
  39. System.out.println(result[j]);
  40. }
  41. }
  42. }
  43. }
  44.  
  45.  
  46.  
  47. } catch (Exception e)
  48. {
  49. e.printStackTrace();
  50. }
  51. }
Add Comment
Please, Sign In to add comment