Reply to thread

Message

<blockquote data-quote="B.Chat" data-source="post: 28491969" data-attributes="member: 578035">(මේ ජවා ටිකේ රතුපාටින් තියෙන ටික මම Add කරා&nbsp; Duplicate නවත්තන්න. ඒත් ඒ ටික වැඩ නෑ. Error එකක් එන්නෙත් නෑ හැබැයි. මේකේ වැරැද්ද හොයා ගන්න පුලුවන් නම් කියන්න වැඩ්ඩෙක්. MySQL Table Name - categoryMySQL Table Field Names&nbsp; - id, category, statusText fields on JFrame - txtcat , status(combobox) )private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; //Add a category , add button &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; String category = txtcat.getText();&nbsp; &nbsp; &nbsp; &nbsp; String status=txtstatus.getSelectedItem().toString();&nbsp; &nbsp; &nbsp; &nbsp; //Duplicate check - not work&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; String dup = &quot;SELECT category FROM category where category = '&quot;+category+&quot;'&quot;;if(dup.equals(category)){JOptionPane.showMessageDialog(null,&quot;Category Name is already existed! Please enter new one&quot;);}else{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Class.forName(&quot;com.mysql.cj.jdbc.Driver&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; con1=DriverManager.getConnection(&quot;jdbc:mysql://localhost/possystem&quot;,&quot;root&quot;,&quot;&quot;); &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; pst = con1.prepareStatement(&quot;INSERT INTO&nbsp; category (category,status) VALUES (?,?)&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; pst.setString(1, category);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; pst.setString(2,status);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; pst.executeUpdate();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; JOptionPane.showMessageDialog(null,&quot;Category Added&quot; );&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; table_update();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; txtcat.setText(&quot;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; txtstatus.setSelectedIndex(1);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; txtcat.requestFocus();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } catch (ClassNotFoundException ex) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Logger.getLogger(category.class.getName()).log(Level.SEVERE, null, ex);&nbsp; &nbsp; &nbsp; &nbsp; } catch (SQLException ex) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Logger.getLogger(category.class.getName()).log(Level.SEVERE, null, ex);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }</blockquote>

[QUOTE="B.Chat, post: 28491969, member: 578035"] [COLOR=rgb(84, 172, 210)](මේ ජවා ටිකේ රතුපාටින් තියෙන ටික මම Add කරා Duplicate නවත්තන්න. ඒත් ඒ ටික වැඩ නෑ. Error එකක් එන්නෙත් නෑ හැබැයි. මේකේ වැරැද්ද හොයා ගන්න පුලුවන් නම් කියන්න වැඩ්ඩෙක්. MySQL Table Name - category MySQL Table Field Names - id, category, status Text fields on JFrame - txtcat , status(combobox) )[/COLOR] private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) { //Add a category , add button String category = txtcat.getText(); String status=txtstatus.getSelectedItem().toString(); //Duplicate check - not work [COLOR=rgb(235, 107, 86)] String dup = "SELECT category FROM category where category = '"+category+"'"; if(dup.equals(category)){ JOptionPane.showMessageDialog(null,"Category Name is already existed! Please enter new one"); } else{[/COLOR] try { Class.forName("com.mysql.cj.jdbc.Driver"); con1=DriverManager.getConnection("jdbc:mysql://localhost/possystem","root",""); pst = con1.prepareStatement("INSERT INTO category (category,status) VALUES (?,?)"); pst.setString(1, category); pst.setString(2,status); pst.executeUpdate(); JOptionPane.showMessageDialog(null,"Category Added" ); table_update(); txtcat.setText(""); txtstatus.setSelectedIndex(1); txtcat.requestFocus(); } catch (ClassNotFoundException ex) { Logger.getLogger(category.class.getName()).log(Level.SEVERE, null, ex); } catch (SQLException ex) { Logger.getLogger(category.class.getName()).log(Level.SEVERE, null, ex); } } [/QUOTE]

Verification

Dawasata paya keeyak thibeda?

Search

Latest ads

Reply to thread