samedi 26 septembre 2015

Im trying to insert a rows in sqlite embedded db in java. after inserting changes are visible in that program alone

Im trying to insert a rows in sqlite embedded db in java. after inserting changes are visible in that program alone. I cant see the changes in sqlite manager. when i try to insert a row in sqlite manager values that inserted which is shown in program gets deleted. and showing those row which i inserted using sqlite manager. please help..

connection class

import java.net.URL;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;


public class HsqlConn {

//public static void main(String[] args) {
 public static Connection hconn = null;
 public static Statement hstmt = null; 
 public static PreparedStatement pst = null;
public static void hConnectDb(){

try{
    Class.forName("org.sqlite.JDBC");
    ClassLoader classLoader =   Thread.currentThread().getContextClassLoader();
    URL resource = classLoader.getResource("PS/PSDB.sqlite");
    hconn = DriverManager.getConnection("jdbc:sqlite::resource:"+resource);
}
catch(Exception se){
  //Handle errors for JDBC
  se.printStackTrace();
}



}
}

main class using that db

private void jButton8ActionPerformed(java.awt.event.ActionEvent evt) {                                         
    // TODO add your handling code here:
    try{
        hConnectDb();
        String sql1 = "Insert into Bill (billNo,date,principal,principalText,custId,dueDate) values (?,?,?,?,?,?)";
        pst = hconn.prepareStatement(sql1);
        pst.setString(1,BillNoField.getText());
        pst.setString(2,dateField1.getText());
        pst.setString(3,PrincipalField.getText());
        pst.setString(4,PrincipaTextField.getText());
        pst.setString(5,custIdField.getText());
        pst.setString(6,dueDateField.getText());
        pst.executeUpdate();
        pst.close();
        hconn.close();
        JOptionPane.showMessageDialog(null, "saved");
    }
    catch(Exception e){
        JOptionPane.showMessageDialog(null, e);
    }
}  

Aucun commentaire:

Enregistrer un commentaire