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