java - Data writing error -


i'm inserting data mysql database. unknown reason data not being inserted table. worked fine sqlite. here code:

try {              class.forname("com.mysql.jdbc.driver");                connection conn = drivermanager.getconnection(url, username, password);                string query1 = "insert project (uniqueid,name,address,startingdate,estcompletion,engname) values(?,?,?,?,?,?)";             string query2 = "insert engineerdata (uniqueid,name,password) values(?,?,?)";             string query3 = "insert " +tablename +" (uniqueid,category,item,estimatedquantity,unit,unitprice,totalprice,totalspent) values(?,?,?,?,?,?,?,?)";             string query4 = "insert projectimages (uniqueid, path) values(?,?)";              preparedstatement pst1=  conn.preparestatement(query1);             preparedstatement pst2 = conn.preparestatement(query2);             preparedstatement pst3 = conn.preparestatement(query3);             preparedstatement pst4 = conn.preparestatement(query4);              pst1.setint(1, uniqueid);             pst1.setstring(2, projectname.gettext());             pst1.setstring(3, address.gettext());             pst1.setstring(4, day1.gettext()+"/"+month1.gettext()+"/"+year1.gettext());             pst1.setstring(5, day2.gettext()+"/"+month2.gettext()+"/"+year2.gettext());             pst1.setstring(6, engineername.gettext());              pst2.setint(1, uniqueid);             pst2.setstring(2, engineername.gettext());             pst2.setstring(3, engineerpassword.gettext());              try{             (int j = 0; j < table.getrowcount(); j++ ){                  pst3.setint(1, uniqueid);                 pst3.setstring(2, table.getvalueat(j, 0).tostring());                 pst3.setstring(3, table.getvalueat(j, 1).tostring());                 pst3.setstring(4, table.getvalueat(j, 2).tostring());                 pst3.setstring(5, table.getvalueat(j, 3).tostring());                 pst3.setstring(6, table.getvalueat(j, 4).tostring());                 pst3.setstring(7, table.getvalueat(j, 5).tostring());                  pst3.setdouble(8, 0.0);                 pst3.execute();              }}catch(exception e3){                 /*joptionpane.showmessagedialog(null, e3);                  *                   */             }              pst4.setint(1, uniqueid);             pst4.setstring(2, null);              pst1.execute();             pst2.execute();             pst4.execute();              system.out.println(pst1.tostring());             system.out.println(pst2.tostring());              pst1.close();             pst2.close();             pst3.close();             pst4.close();                conn.close();                }

you should leave out auto generated column "uniqueid" , rewrite code. ex.

string query4 = "insert projectimages (path) values(?)";

another approach - passing null value auto generated column. ex.

string query4 = "insert projectimages (uniqueid, path) values(null,?)";

Comments

Post a Comment

Popular posts from this blog

Magento/PHP - Get phones on all members in a customer group -

i working on custom magento extension. working around adminhtml part , i've created custom form there. here form code: <?php class vivasindustries_smsnotification_block_adminhtml_sms_sendmass_edit_form extends mage_adminhtml_block_widget_form { public function _preparelayout() { $extensionpath = mage::getmoduledir('js', 'vivasindustries_smsnotification'); $head = $this->getlayout()->getblock('head'); $head->addjs('jquery.js'); $head->addjs('vivas.js'); return parent::_preparelayout(); } protected function _prepareform() { $form = new varien_data_form(array( 'id' => 'edit_form', 'action' => $this->geturl('*/*/save', array('id' => $this->getrequest()->get...
Read more

php - Bypass Geo Redirect for specific directories -

i'm trying bypass redirect specific url within site. wondering if might able help. the code below code use, original urls replaces example.com i'd able access http://example.com/admin without redirect occuring. is there way this, , there way using own ip? function country_geo_redirect() { $country = getenv('http_geoip_country_code'); if ($country == "us" ) { wp_redirect("http://usa.example.com/"); exit; } else if ($country == "gb" ) { wp_redirect("http://uk.example.com/"); exit; } } add_action('init', 'country_geo_redirect'); you can bypass redirection code if server found ip address. if ip address == <my ip address> ' nothing here else country_georedirect() end if
Read more

php - .htaccess mod_rewrite for dynamic url which has domain names -

i want convert url ex:( example.com/link.php?url=facebook.com ) ( example.com/facebook.com.php ) how can using .htaccess. or there other process make job easier ? i tried adding script .htaccess file options +followsymlinks rewriteengine on rewriterule url-(.*)\.htm$ link.php?url=$1 but converting url adding "url-" ( example.com/url-facebook.com.php ) i want remove "url-" , want make ( example.com/facebook.com.php ) rewriteengine on rewritecond %{the_request} ^get.*link\.php\?url\= [nc] rewritecond %{request_uri} !/system/.* [nc] rewriterule (.*?)link\.php\?url\=/*(.*) /$1$2 [r=301,ne,l] not sure how above work edit of used use remove index.php url
Read more