Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package lab_sbd;
- import java.io.IOException;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Connection;
- import java.sql.Statement;
- import com.ibm.as400.*;
- import com.ibm.as400.access.jdbcClient.*;
- import com.ibm.db2.jcc.DB2Driver;
- public class main {
- public static void main(String[] args) throws IOException, SQLException
- {
- String jdbcClassName="com.ibm.db2.jcc.DB2Driver";
- String url="jdbc:db2://10.0.2.15:50000/mydb";
- String user="db2admin";
- String password="db2admin";
- Connection con = null;
- try
- {
- //Load class into memory
- Class.forName(jdbcClassName);
- //Establish connection
- con = DriverManager.getConnection(url, user, password);
- Statement stmt = con.createStatement();
- System.out.println("conected");
- for (int i = 1; i<100098; ++i)
- {
- stmt.execute("insert into tablk (imiona, nazwiska , rok) values ('"+i+"jan', '"+i+"kowalski',"+i+" )");
- }
- }
- catch (ClassNotFoundException e)
- {
- e.printStackTrace();
- }
- catch (SQLException e)
- {
- e.printStackTrace();
- }
- finally
- {
- if(con!=null)
- {
- System.out.println("Connected successfully.");
- con.close();
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement