Ready Project |BCA Project | MCA Project | BBA Project | MBA Project |INDIA'S BIGGEST COLLEGE PROJECT STORE




import java.sql.*;

import java.awt.*;

import java.awt.event.*;

import javax.swing.*;

import java.util.*;

class Slip24_2 extends JFrame implements ActionListener

{

JLabel l1,l2,l3,l4;

JTextField t1,t2,t3,t4;

JButton b1,b2;

String sql;

JPanel p,p1;

Connection con;

PreparedStatement ps;

JTable t;

JScrollPane js;

Statement stmt ;

ResultSet rs ;


ResultSetMetaData rsmd ;

int columns;

Vector columnNames = new Vector();

Vector data = new Vector();

Slip24_2()

{

l1 = new JLabel("Cust id :");

l2 = new JLabel("Enter name :");

l3 = new JLabel("Adderss :");

l4 = new JLabel("Year:");

t1 = new JTextField(20);

t2 = new JTextField(20);

t3 = new JTextField(20);

t4 = new JTextField(20);

b1 = new JButton("Save");

b2 = new JButton("Clear");

b1.addActionListener(this);

b2.addActionListener(this);

p=new JPanel();

p1=new JPanel();

p.add(l1);

p.add(t1);

p.add(l2);

p.add(t2);

p.add(l3);

p.add(t3);

p.add(l4);

p.add(t4);

p.add(b1);

p.add(b2);

add(p);

setLayout(new GridLayout(2,1));

setSize(600,800);

setVisible(true);

setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

}

public void actionPerformed(ActionEvent e)

{

if((JButton)b1==e.getSource())

{

int no = Integer.parseInt(t1.getText());

String name = t2.getText();

int p = Integer.parseInt(t3.getText());

int yr = Integer.parseInt(t4.getText());

NR CLASSES, PUNE (8796064387/90)

System.out.println("Accept Values");

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

con=DriverManager.getConnection("jdbc:odbc:dsn");

sql = "insert into customer values(?,?,?)";

ps = con.prepareStatement(sql);

ps.setInt(1,no);

ps.setString(2, name);

ps.setInt(3,p);

ps.setInt(4,yr);

System.out.println("values set");

int n=ps.executeUpdate();

if(n!=0)

{

JOptionPane.showMessageDialog(null,"Record insered
...");

}

else

JOptionPane.showMessageDialog(null,"Record NOT
inserted ");

}//end of try

catch(Exception ex)

{

System.out.println(ex);

//ex.printStackTrace();

}

}//end of if

else

{

t1.setText(" ");

t2.setText(" ");

t3.setText(" ");

t4.setText(" ");

}

}//end of method

public static void main(String a[])

{

Slip24_2 ob = new Slip24_2();

}

}

24) Write a java program to accept the details of college (CID, CName, Address, year) and store it into database (Use Swing and PreparedStatement interface)

Search

Project Categories

Recent Posts

Sign In