How to update file path with \\ in mysql using java?

Question

After updating the attachement field with new file, mysql file path cosists with no slashs. Could anyone show me the path to fix it?

This is my file attachment button:

private void attachActionPerformed(java.awt.event.ActionEvent evt){                                      
    JFileChooser chooser=new JFileChooser();
    chooser.showOpenDialog(null);
    File f=chooser.getSelectedFile();
    String file=f.getAbsolutePath();
    file_attach.setText(file); 
}

This is my update button code:

private void update_fieldsActionPerformed(java.awt.event.ActionEvent evt){  
    try{ 
        String add1=course_catergory.getSelectedItem().toString();
        String add2=code_course.getText();
        String add3=course_type.getSelectedItem().toString();
        String add4=course_name.getText();
        String add5=file_attach.getText();

        String sql="UPDATE course SET category='"+add1+"' ,course_code='"+add2+"' ,course_type='"+add3+
                "' ,course_name='"+add4+"' ,attach_file='"+add5+"' where  course_code='"+add2+"' ";

        pst=conn.prepareStatement(sql);
        pst.executeUpdate();
        JOptionPane.showMessageDialog(null, "Successfully updated.");

    }
    catch(Exception e){
        JOptionPane.showMessageDialog(null, e);
    }
    update_course_table();
}

Learn about prepared statements

Jens
– Jens

2016-07-20 08:59:55 +00:00
Commented Jul 20, 2016 at 8:59 — Jens
– Jens, Commented Jul 20, 2016 at 8:59
Ok. Thank you very much.

lakshi
– lakshi

2016-07-20 09:33:07 +00:00
Commented Jul 20, 2016 at 9:33 — lakshi
– lakshi, Commented Jul 20, 2016 at 9:33

Youcef LAIDANI · Accepted Answer · 2016-07-20 09:04:12Z

1

Use PreparedStatement with ? not like the native query, this is an exemple how to use it correctly:

try {
    String sql = "UPDATE course SET category = ?, course_code = ? ,course_type = ? ,course_name = ?, "
            + "attach_file=? where course_code = ? ";

    pst = conn.prepareStatement(sql);
    pst.setString(1, add1);
    pst.setString(2, add2);
    pst.setString(3, add3);
    pst.setString(4, add4);
    pst.setString(5, add5);
    pst.setString(6, add2);
    pst.executeUpdate JOptionPane.showMessageDialog(null, "Successfully updated.");

} catch (Exception e) {
    JOptionPane.showMessageDialog(null, e);
}

answered Jul 20, 2016 at 9:04

Youcef LAIDANI

60.3k21 gold badges111 silver badges178 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to update file path with \\ in mysql using java?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related