Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 993 views

    IP Project

    Uploaded by

    AnjanYadav
    This document describes code for an army database application. It includes code for importing necessary Java libraries, adding new records to the database table, and displaying records from the table. The code samples show how to connect to a MySQL database, execute SQL queries, validate user input, and add or retrieve data from the soldiers table. It also includes standard sections like bibliography, acknowledgements, and a declaration statement.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd

    IP Project

    Uploaded by

    AnjanYadav
    993 views15 pages
    This document describes code for an army database application. It includes code for importing necessary Java libraries, adding new records to the database table, and displaying records from the table. The code samples show how to connect to a MySQL database, execute SQL queries, validate user input, and add or retrieve data from the soldiers table. It also includes standard sections like bibliography, acknowledgements, and a declaration statement.

    Original Description:

    army database

    Copyright

    © © All Rights Reserved

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document describes code for an army database application. It includes code for importing necessary Java libraries, adding new records to the database table, and displaying records from the table. The code samples show how to connect to a MySQL database, execute SQL queries, validate user input, and add or retrieve data from the soldiers table. It also includes standard sections like bibliography, acknowledgements, and a declaration statement.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    993 views15 pages

    IP Project

    Uploaded by

    AnjanYadav
    This document describes code for an army database application. It includes code for importing necessary Java libraries, adding new records to the database table, and displaying records from the table. The code samples show how to connect to a MySQL database, execute SQL queries, validate user input, and add or retrieve data from the soldiers table. It also includes standard sections like bibliography, acknowledgements, and a declaration statement.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    You are on page 1of 15

    ARMY DATABASE

    Design:

    SOURCE CODE:
    Import Statements:
    import java.sql.DriverManager;
    import com.mysql.jdbc.Connection;
    import com.mysql.jdbc.Statement;
    import java.sql.ResultSet;

    import javax.swing.table.DefaultTableModel;
    import javax.swing.JOptionPane;

    Code for Adding New Record:


    String name,salary,dob,pension,designation;
    name=jTextField1.getText();
    if(name.isEmpty())
    JOptionPane.showMessageDialog(this,
    "Name not Entered");
    salary=jTextField2.getText();
    if(salary.isEmpty())
    JOptionPane.showMessageDialog(this,
    "Salary not Entered");
    dob=jTextField3.getText();
    if(dob.isEmpty())
    JOptionPane.showMessageDialog(this,
    "D.O.B. not Entered");
    pension=jTextField4.getText();

    if(pension.isEmpty())
    JOptionPane.showMessageDialog(this,
    "Pension not Entered");
    designation=jTextField5.getText();
    if(name.isEmpty())
    JOptionPane.showMessageDialog(this,
    "Designation not Entered");

    else
    {
    try
    {
    Class.forName("java.sql.DriverManager");
    Connection con=(Connection)
    DriverManager.getConnection
    ("jdbc:mysql://localhost:3306/IndianArmy","ro
    ot","1234");

    Statement stmt=(Statement)
    con.createStatement();
    ResultSet
    rs=stmt.executeQuery("SELECT
    SoldiersName, Salary, dob, Pension,
    Designation FROM soldier WHERE
    SoldiersName=name");

    int Found=0;
    while(rs.next())
    {
    String name1=rs.getString("Name");
    String
    salary1=rs.getString("Salary");
    String dob1=rs.getString("dob");
    String
    pension1=rs.getString("pension");
    String
    designation1=rs.getString("Designation");

    if( name.equals(namet))
    {
    Found++;
    jTextField2.setText(""+Salary);
    jTextField3.setText(""+D.O.B.);
    jTextField4.setText(""+Pension);
    jTextField5.setText(""+Designation);
    break;
    }
    else
    {
    continue;
    }

    }
    if(Found==0)

    JOptionPane.showMessageDialog(this,"Sorry
    No such name in contact list");
    }
    catch(Exception e)
    {
    JOptionPane.showMessageDialog(this,
    e.getMessage());
    }
    }
    }
    Code For Display:
    private void
    jRadioButton1ActionPerformed(java.awt.event
    .ActionEvent evt) {
    DefaultTableModel model=
    (DefaultTableModel)
    jTable1.getModel();
    try

    {
    Class.forName("java.sql.DriverManager");
    Connection con=(Connection)
    DriverManager.getConnection
    ("jdbc:mysql://localhost:3306/cbse1",
    "root","1234");
    Statement stmt=(Statement)
    con.createStatement();
    String Tname;
    if(jRadioButton1.isSelected())
    Tname="soldier";
    else
    Tname="Official";
    String query="SELECT * FROM
    "+Tname+";";
    ResultSet rs=stmt.executeQuery(query);
    while(rs.next())
    {

    String name=rs.getString("name");
    String Salary=rs.getString("Salary");
    String D.O.B.=rs.getString("D.O.B.");
    String
    Pension=rs.getString("Pension");
    String
    Designation=rs.getString("Designation");
    model.addRow(new Object[] {name,
    Salary, D.O.B., Pension, Designation});
    }
    }
    catch(Exception e)
    {
    JOptionPane.showMessageDialog(this,
    e.getMessage());
    }
    }

    private void
    jRadioButton2ActionPerformed(java.awt.event
    .ActionEvent evt) {
    DefaultTableModel model=
    (DefaultTableModel)
    jTable1.getModel();
    int rows=model.getRowCount();
    if(rows>0)
    {

    for(int i=0; i<rows;i++)


    model.removeRow(0);

    }
    }

    Output

    BIBLIOGRAPHY
    1)Sumita Arora Informatics
    Practices Class 12 Text Book
    2)NCERT Text Book
    3)Vikas Gupta Informatics
    Practices Class 12 Text Book

    ACKNOWLEDGEMENT
    I wish to express my deep
    gratitude and sincere thanks to
    Principal,
    Mr.Prasad, Shree Skanda Central
    School, Uttarhalli, Bangalore.I
    sincerely appreciate this
    magnanimity by taking me into
    there fold for which I shall remain
    indebted to them.
    I extend my hearty thanks to Mrs.
    Priya and Mrs.Ramya, I.P.
    lecturers, who guided me to the
    successful completion of this
    project. I take this opportunity to
    express my deep sense of

    gratitude for his invaluable


    guidance, constant
    encouragement, constructive
    comments, sympathetic attitude
    and immense motivation, which
    has sustained my efforts at all
    stages of this project work.
    I cant forget to offer my sincere
    thanks to my classmates who
    helped me to carry out this
    project work successfully & for
    their valuable advice & support,
    which I received from them time
    to time.

    DECLARATION

    I do hereby declare that this


    project work has been
    originally carried under the
    guidance and supervision of
    Mrs.Priya and Mrs.Ramya ,
    Shree Skanda Central Public
    School, Banglore.

    INFORMATICS PRACTICES

    ARMY DATABASE

    You might also like