[maab]

here i insert in database without any problem but i want when select from database (select user_id from e_user where email= the same email i inserted it )

void insert()
{
   try
        {
            String sql="Insert into e_user (user_id, user_name, membership_no, email,                      
           user_degree, password) values(user_userid_seq.NEXTVAL,?,?,?,?,?)";
            Connection connection = 
         DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "imes", "imes");
            PreparedStatement pst = connection.prepareStatement(sql);  
            pst.setString(1, txtname.getText());
            pst.setString(2, txtmembership.getText());
            pst.setString(3, txtemail.getText());
            pst.setString(4, cbdegree.getSelectedItem().toString());
            pst.setString(5, txtpass.getText());
            pst.execute();
            
            JOptionPane.showMessageDialog(null, "saved");
            
             new Cases().setVisible(true);
              Statement select =  connection.createStatement();
          ResultSet result = select.executeQuery("select user_id from e_user where email= ? ");
            while(result.next())
            {
                int id = result.getInt("user_id");
                JOptionPane.showMessageDialog(null, "Your id is" + id);
            }
            select.close();
            result.close();
            connection.close();
        }
        catch(SQLException | HeadlessException e)
                {
                    JOptionPane.showMessageDialog(null, e);
                }
}

This post has been edited by macosxnerd101: 03 July 2012 - 03:25 PM
Reason for edit:: Please use a descriptive title

[pbl]

what is user_userid_seq.NEXTVAL supposed to be ?

what is email = ?
("select user_id from e_user where email= ? ");

[maab]

user_userid_seq.NEXTVAL is sequence column of the table
email =? is wrong but i want select user_id where email = what i inserted but i don't know how can i do

[pbl]

is it is done just after the insert it will be what is in txtemail.getText()

[g00se]

Try closing 'pst' immediately after execute

This post has been edited by g00se: 04 July 2012 - 04:00 PM

[RCR]

Hi,

To help the forum do you mind re-formatting your text better next time? It's extremely hard to interpret what you're saying. Besides that, I believe this is your problem:

PreparedStatement pst = connection.prepareStatement(sql); 
            pst.setString(1, txtname.getText());
            pst.setString(2, txtmembership.getText());
            [b]String email[/b] = pst.setString(3, txtemail.getText()); //Just set email for one considering that was you problem.
            pst.setString(4, cbdegree.getSelectedItem().toString());
            pst.setString(5, txtpass.getText());
            pst.execute();
             
            JOptionPane.showMessageDialog(null, "saved");
             
           new Cases().setVisible(true);
           Statement select =  connection.createStatement();
           ResultSet result = select.executeQuery("select user_id from e_user where email= " [b]+ email[/b]);

Hope this could help your problem

Also is there a way to edit my posts??

[macosxnerd101]

Quote

Also is there a way to edit my posts??

Not until you hit a certain number of posts. More on our editing policies:

http://www.dreaminco...-to-edit-times/