Categories

See More
Popular Forum

MBA (4887) B.Tech (1769) Engineering (1486) Class 12 (1030) Study Abroad (1004) Computer Science and Engineering (988) Business Management Studies (865) BBA (846) Diploma (746) CAT (651) B.Com (648) B.Sc (643) JEE Mains (618) Mechanical Engineering (574) Exam (525) India (462) Career (452) All Time Q&A (439) Mass Communication (427) BCA (417) Science (384) Computers & IT (Non-Engg) (383) Medicine & Health Sciences (381) Hotel Management (373) Civil Engineering (353) MCA (349) Tuteehub Top Questions (348) Distance (340) Colleges in India (334)
See More

How to update table from GUI in Java Netbeans?

Course Queries Syllabus Queries

Max. 2000 characters
Replies

usr_profile.png

User

( 4 months ago )

 

I'm designing a GUI using Java Netbeans and am trying to insert values into the table from the GUI fields. It shows no error , but nothing is getting inserted. Here is my code :

Statement stmt = null;
try {

    String sql = "Insert into Elective (subject_code,topic,syllabus,credit,Expert_ID,startsession,endsession) values (?,?,?,?,?,?,?)";
    pst = conn.prepareStatement(sql);
    String subject = Subject_code.getSelectedItem().toString();
    pst.setString(1, subject);
    pst.setString(2, topic.getText());
    pst.setString(3, syllabus.getText());
    pst.setString(4, credit.getText());

    String Expert = Expert_ID.getSelectedItem().toString();
    pst.setString(5, Expert);

    int y1 = startsession.getYear();
    int y2 = endsession.getYear();
    pst.setInt(6, y1);
    pst.setInt(7, y2);
    //ResultSet executeQuery = pst.executeQuery();
    stmt = conn.createStatement();
    ResultSet rs = stmt.executeQuery("SELECT * FROM Elective;");
    while (rs.next()) {
        String subject_code1 = rs.getString("subject_code");
        String topic1 = rs.getString("topic");
        String syllabus1 = rs.getString("syllabus");
        String credit1 = rs.getString("credit");
        String Expert_ID1 = rs.getString("Expert_ID");
        int startsession1 = rs.getInt("startsession");
        int endsession1 = rs.getInt("endsession");
        System.out.println("Subject Code = " + subject_code1);
        System.out.println("Topic = " + topic1);
        System.out.println("Syllabus=" + syllabus1);
        System.
usr_profile.png

User

( 4 months ago )

you should use executeUpdate() to do updates to database instead of executeQuery() method and executeUpdate() doesn't return a ResultSet .

use

 pst.executeUpdate();

not

ResultSet executeQuery = pst.executeQuery();//not correct

don't know why you have commented that line.presumably that's why you don't get any error

what's your interest