Monday, 26 August 2013

MS Access doesn't shows updates record changes through java program. While record are update Successfully

MS Access doesn't shows updates record changes through java program. While
record are update Successfully

import java.sql.*;
public class Test {
Connection con;
Statement st;
PreparedStatement pst;
ResultSet rs;
public void connectDB() {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:adilDSN");
System.out.println("Database Connected");
} catch (Exception e) {
System.out.println(e);
}
}
public void showData() {
connectDB();
System.out.println("hi");
try {
String sql = "select * from std";
System.out.println("hi");
pst = con.prepareStatement(sql);
System.out.println("hi");
rs = pst.executeQuery();
System.out.println(rs.toString());
while (rs.next()) {
System.out.println("hi");
String name = rs.getString(1);
String id = rs.getString(2);
System.out.println(name + id);
}
} catch (Exception e) {
System.out.println(e);
}
}
public void insertData() {
connectDB();
try {
String sql = "Select * from person";
String sql1 = "INSERT INTO std ( stdId, stdName,stdAddress )
VALUES('9', 'jawad','mardan')";
pst = con.prepareStatement(sql1);
/*
PreparedStatement pStmt = con.prepareStatement
(sql,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs = pStmt.executeQuery();
rs.moveToInsertRow();
rs.updateString("ID","10");
rs.updateString("address","Karachi");
rs.insertRow( );
System.out.println("row inserted");
*/
int i = pst.executeUpdate();
System.out.println(i + "record updated");
con.commit();
} catch (Exception e) {
System.out.println(e);
}
}
public static void main(String args[]) {
Test t = new Test();
t.showData();
t.insertData();
t.showData();
}
}

No comments:

Post a Comment