How to insert data in database using java?

Question

I've trying to insert data in db using my sql. string from where to getting data and inserting in db.

String is :

s=
1 kalim khan NIL    
2 ajay sharma NIL   
3 navneet gupta  NIL    
4 amar kumar srivastava NIL

I want that where spaces are more then 3 that should skiped and moved ahead

the code is following as:

StringTokenizer str = new StringTokenizer(htmlTableText);
   while(str.hasMoreElements()){
      for(int i=0;i<4;i++){
          int sno = Integer.parseInt(str.nextElement().toString());

        String fname = str.nextElement().toString();
        String lname = str.nextElement().toString();
        String price = str.nextElement().toString();
        Class.forName("com.mysql.jdbc.Driver");
        Connection  cn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mandi","root","");
         //insert them into the database
         PreparedStatement ps=cn.prepareStatement("insert into commoditywise  values(?,?,?,?)");
         ps.setInt(1,sno);
         ps.setString(2, fname);
         ps.setString(3, lname);
         ps.setString(4, price);
            int j =ps.executeUpdate();
            if(j==1)
            {
            System.out.println("data inserted");
            }
            else
            {
            System.out.println("not inserted");
            }
      }
   }

Thanks in advance

Small Tip: `StringTokenizer` is a legacy class. Try using the `String.split()` instead. — Rahul, Apr 04 '14 at 06:50
@user3496498 - [Here you go](http://stackoverflow.com/q/3481828/2024761). — Rahul, Apr 04 '14 at 06:55
Please describe the actual problem you have, don't make us guess. — Mark Rotteveel, Apr 04 '14 at 07:12
my actual prom is only this that where string is having more then three prob skip that string thats it — user3496498, Apr 04 '14 at 07:17

score 0 · Answer 1 · answered Apr 04 '14 at 06:56

0

Maybe StringTokenizer's count method can help you?

int count = str.countTokens();
if (count > 4) {
   continue;
}

Otherwise I would just insert the first strings until I get to the last name.

answered Apr 04 '14 at 06:56

Kristjan Veskimäe

992
5
16

JohnRose · Answer 2 · 2014-04-04T07:09:07.060

ps.setInt(1,sno);
ps.setString(2,fname);
ps.setString(3,lname);
ps.setString(4,price);

There is some error in these lines,

Solution: Use DTO ( Setter and Getter method class / bean class) to get sno,fname,lname,price values

try this here 1.dtoclassname= your bean class ( setter and setter method class)
2.getSno() = is method for getting value.

ps.setInt(1,dtoclassname.getSno());

do above said operations for other fields.

How to insert data in database using java?

2 Answers2