Advertisement
Guest User

sbd_ lab java2

a guest
Oct 25th, 2014
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.54 KB | None | 0 0
  1. package lab_sbd;
  2.  
  3. import java.io.IOException;
  4. import java.sql.DriverManager;
  5. import java.sql.PreparedStatement;
  6. import java.sql.ResultSet;
  7. import java.sql.SQLException;
  8. import java.sql.Connection;
  9. import java.sql.Statement;
  10.  
  11. import com.ibm.as400.*;
  12. import com.ibm.as400.access.jdbcClient.*;
  13. import com.ibm.db2.jcc.DB2Driver;
  14.  
  15. public class main {
  16.  
  17. public static void main(String[] args) throws IOException, SQLException
  18. {
  19.  
  20.  
  21. String jdbcClassName="com.ibm.db2.jcc.DB2Driver";
  22. String url="jdbc:db2://10.0.2.15:50000/mydb";
  23. String user="db2admin";
  24. String password="db2admin";
  25.  
  26. Connection con = null;
  27. try
  28. {
  29. //Load class into memory
  30. Class.forName(jdbcClassName);
  31. //Establish connection
  32. con = DriverManager.getConnection(url, user, password);
  33. Statement stmt = con.createStatement();
  34. System.out.println("conected");
  35. for (int i = 1; i<100098; ++i)
  36. {
  37. stmt.execute("insert into tablk (imiona, nazwiska , rok) values ('"+i+"jan', '"+i+"kowalski',"+i+" )");
  38. }
  39.  
  40. }
  41. catch (ClassNotFoundException e)
  42. {
  43. e.printStackTrace();
  44. }
  45. catch (SQLException e)
  46. {
  47. e.printStackTrace();
  48. }
  49. finally
  50. {
  51. if(con!=null)
  52. {
  53. System.out.println("Connected successfully.");
  54. con.close();
  55. }
  56. }
  57.  
  58.  
  59. }
  60.  
  61. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement