Swings and JDBC

Ads
 

Swings and JDBC

Hi.. I am vinay.. I am developing a small application using swings and mysql. I am sending part of the code here..

The problem is i need to update the mysql fields with values which are gettin from dynamiclly created JTextfields... but i am not getting how i can fetch those particular values and update database with those value.....

Please help me..

My work is paused here... please

Here the code....

package kp;

import java.awt.*; import java.util.regex.*;

import java.awt.event.*;

import javax.swing.*;

import java.io.*; import java.net.*; import java.util.*; import java.sql.*; import java.lang.*; public class attend extends JFrame{

private JLabel jLabel1;
private JButton jButton1;
private JTextField jTextField2;
private JPanel contentPane;
private JTextField jTextField1;
final Vector columnNames = new Vector();
final Vector data = new Vector();
Vector row;
final Object g=new Vector();

public attend()
{
        super();

    initializeComponent();

    this.setVisible(true);
}

private void initializeComponent()
{
    jLabel1 = new JLabel();
    jButton1 = new JButton();
    jTextField1 = new JTextField(20);
    //jTextField1.setName("att");
    contentPane = (JPanel)this.getContentPane();
    contentPane.setBackground(Color.pink);
    jLabel1.setText("ATTENDANCE");


    jButton1.setText("Submit");


    try{
        Connection con = null;
        Class.forName("com.mysql.jdbc.Driver");
        con = DriverManager.getConnection("jdbc:mysql://localhost/vinay", "root", "admin");
        Statement st = con.createStatement();
        ResultSet rs= st.executeQuery("Select * from student");
        ResultSetMetaData md = rs.getMetaData();
        int columns = md.getColumnCount();
        for (int i = 1; i <= columns; i++) 
        {
        columnNames.addElement( md.getColumnName(i) );
        }
        while (rs.next()) {
        row = new Vector(columns);
        for (int i = 1; i <= columns; i++) 
        {
            row.addElement( rs.getObject(i));
            if(i==4)
            {
                row.addElement(jTextField1);
            }

        }
        data.addElement( row );
        //

        }
        String k=jTextField1.getText();
        System.out.println(k);
        rs.close();
        st.close();
        }
        catch(Exception e) {}
        JTable table = new JTable(data, columnNames);
        JScrollPane scrollPane = new JScrollPane( table );
    contentPane.setLayout(null);
    addComponent(contentPane, scrollPane, 5,110,200,200);
addComponent(contentPane, jLabel1, 50,1,345,37);
addComponent(contentPane, jButton1, 220,300,100,28);
this.setTitle("Class Attendance");
this.setLocation(new Point(66, 48));
this.setSize(new Dimension(438, 384));

jButton1.addActionListener(new ActionListener() {
    public void actionPerformed(ActionEvent e)
    {
        Vector z=new Vector();
        //System.out.println(data.get(2));
        //System.out.println(row.elementAt(3));
            //g=data.get(4);
            //System.out.println(g);
        try{
            int i;
            String sql=null;
            Connection con = null;
            //ResultSet rs=null;
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://localhost/vinay", "root", "admin");
            if(con!=null)
            {
            System.out.println("connectin established");
            }
            Statement st = con.createStatement();
            for(i=3;i>0;i-=3)
            {
                System.out.println(row.get(i));
                 String a=(String) row.get(i);
                Pattern p=Pattern.compile("^p");
                Matcher m=p.matcher(a);
                if(m.find())
                {
            sql="update student set attend='"+a+"'";
            System.out.println(sql);
            st.executeUpdate(sql);
                }
            }

            st.close();
            con.close();
            }
            catch(Exception e1) {}
        }


});
}

private void addComponent(Container container,Component c,int x,int y,int width,int height)
{
    c.setBounds(x,y,width,height);
    container.add(c);
}

}

View Answers

February 3, 2011 at 12:33 PM

Hi Friend,

Please visit the following link:

Add Edit Delete Application

Hope that it will be helpful for you.

Thanks

Ads









Related Tutorials/Questions & Answers:
Swings and JDBC
Swings and JDBC  Hi.. I am vinay.. I am developing a small application using swings and mysql. I am sending part of the code here.. The problem is i...("com.mysql.jdbc.Driver"); con = DriverManager.getConnection("jdbc:mysql://localhost/vinay
SWINGS
SWINGS  WHAT ARE THE DIFFERENCES BETWEEN AWT AND SWINGS
Advertisements
JSP & Swings
JSP & Swings  How to integrate jsp and swings
swings question
swings question  how to change the background color with the help of color values by using swings
java code using swings
java code using swings  code that should be able to enter data of student details using all swings into the access database using jdbc connectivity
swings for webnms
swings for webnms  if i am expanding node of jtree then i want to collapse previous expanding node of jtree in swings how is it possible
Swings & JSP
Swings & JSP  Hai all, Can we use Swing components in a JSP?? Suppose if we enter details in a swing dialog box..and If we want the result in a JSP..is that possible??? Thank you
Java Swings
Java Swings  I am doing one project on java Swings, in this i have created one jframe where i defined some JButtons and Jcombobox's, here i need to insert one JTable with headers(IN CURRENT JFrame only).pls help me urgently
swings header
swings header   have a string1 it contains 3 parts,for example "123456 service hello" and string2 contains text "change request " like this. and the string3 should contain "123456 +(second string)+ hello" "second string can
swings
swings
swings
Image Movement using Swings
Image Movement using Swings  How to move image using Swings
how to create frame in swings
how to create frame in swings  how to create frame in swings
JDBC
JDBC  why we use batch in jdbc
jdbc
jdbc  display the records using index in jdbc
jdbc
jdbc  Hai , Give a steps for jdbc connectivity
JDBC
JDBC  How to add set of queries in a single query in JDBC
jdbc
jdbc   how to write program to save data and retrieve data from the form in Java
jdbc
jdbc  why do we need to load jdbc drivers before connecting to database
JDBC
JDBC  how to set classpath for eclipse, java, where to copy jdbc connector
JDBC
JDBC  in class.forname which driver name we are writing for the connection from jdbc to sqlserver 2008
jdbc
jdbc  is it possible to use doget & dopost method with jdbc to call in a servlet programe
Jdbc
Jdbc  A java program with jdbc connectivity with insert,delete,update options for name,regno,mark1,mark2,total
JDBC
JDBC  can u send me the code of jdbc how to join two tables that are in relation
jdbc
jdbc define batch updates  define batch updates?exp   JDBC... links: http://www.roseindia.net/jdbc/Jdbc-batch-update.shtml http://www.roseindia.net/tutorial/java/jdbc/batchupdateresultsetexample.html
jdbc
jdbc  Write a web based student registration application where the students can register online with their enrollment no. You are required to use JSP, Servelet and JDBC
JDBC
JDBC save a data in the database  I need a code to save a data... between java and mysql using JDBC and saves the data into the database. import... con = null; String url = "jdbc:mysql://localhost:3306/"; String db
JDBC
JDBC code to save a data in the database  I need a code to save... the connection between java and mysql using JDBC and saves the data into the database...!"); Connection con = null; String url = "jdbc:mysql://localhost:3306/"; String db
jdbc
how can we set transaction level through jdbc api  how can we set transaction level through jdbc api   Use Connection.setTransactionIsolation(int) to set the desired tansaction level, which takes one of the 5 arguments
jdbc
how can we call stored procedure using jdbc  how can we call stored procedure using jdbc   Call a Stored Procedure using...(); For more information, visit the following link: JDBC call Stored Procedure

Ads