Add multiple rows in sql using java

Question

I know an easy way to add one row to sql database using netbeans.

Here is the method:

Class.forName("com.mysql.jdbc.Driver"); Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/zeeshan", "root","sHaNi97426"); Statement stmt = (Statement)conn.createStatement(); String insert = "INSERT INTO clients VALUES('"+hostname+"');"; stmt.executeUpdate(insert); 

Now I want to add some rows to the sql database. For example, in the code below:

 Process p = Runtime.getRuntime().exec("tasklist.exe"); BufferedReader s = new BufferedReader(new InputStreamReader(p.getInputStream())); while ((s.readLine()) != null) { System.out.print(s.readLine()); } 

I want to add each row in sql until s.readLine() becomes null .

Please help me.

Answer 1

You are doing it wrong! With your current code, you will get the missing alternate lines as you call readLine() twice, but only print it for the first time.

In addition, if you want to insert multiple rows into your database, you should look at Batch .

Here is the JAVA Doc addBatch() :

Adds this SQL command to the current command list for this Statement object. The commands in this list can be executed as a package by calling the executeBatch method.

You should do something like this:

 String input = null; while ((input = s.readLine()) != null) { stmt.addBatch(input); } 

Here is how you can execute the package:

 int[] result = stmt.executeBatch();