import javax.swing.*; import java.awt.*; import java.awt.event.*; import java.sql.*; // INSERT NEW RECORD public class inswing implements ActionListener { JFrame fr; JPanel po; JLabel l1,l2,l4,l11,main; JTextField tf1,tf2; JComboBox S1,gender; GridBagConstraints gbc; GridBagLayout go; JButton ok,exit; public inswing() { fr=new JFrame("New Record Entry"); Font f=new Font("Verdana",Font.BOLD,24); //fr=new JFrame(); po=new JPanel(); fr.getContentPane().add(po); fr.setVisible(true); fr.setSize(1024,768); fr.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); po.setBackground(Color.orange); go=new GridBagLayout(); gbc=new GridBagConstraints(); po.setLayout(go); main=new JLabel(" NEW RECORD ENTRY "); main.setFont(f); l1=new JLabel("Student ID :"); tf1=new JTextField(6); l2=new JLabel("Student Name :"); tf2=new JTextField(20); l4=new JLabel("Gender :"); String str1[]={"Male","Female"}; gender=new JComboBox(str1); l11=new JLabel("Branch :"); String str[]={"Computer Science","Electrical","Electrical & Electronics","Information Technology","Mechanical"}; S1=new JComboBox(str); ok=new JButton("Accept"); exit=new JButton("Exit"); S1.addActionListener(this); gender.addActionListener(this); ///////////////////////////////////////// gbc.anchor=GridBagConstraints.WEST; gbc.gridx=0; gbc.gridy=0; go.setConstraints(l1,gbc); po.add(main); //a gbc.anchor=GridBagConstraints.WEST; gbc.gridx=5; gbc.gridy=5; go.setConstraints(l1,gbc); po.add(l1); gbc.anchor=GridBagConstraints.WEST; gbc.gridx=10; gbc.gridy=5; go.setConstraints(tf1,gbc); po.add(tf1); //b gbc.anchor=GridBagConstraints.WEST; gbc.gridx=5; gbc.gridy=10; go.setConstraints(l2,gbc); po.add(l2); gbc.anchor=GridBagConstraints.WEST; gbc.gridx=10; gbc.gridy=10; go.setConstraints(tf2,gbc); po.add(tf2); //d gbc.anchor=GridBagConstraints.WEST; gbc.gridx=5; gbc.gridy=20; go.setConstraints(l4,gbc); po.add(l4); gbc.anchor=GridBagConstraints.WEST; gbc.gridx=10; gbc.gridy=20; go.setConstraints(gender,gbc); po.add(gender); //i gbc.anchor=GridBagConstraints.WEST; gbc.gridx=5; gbc.gridy=60; go.setConstraints(l11,gbc); po.add(l11); gbc.anchor=GridBagConstraints.WEST; gbc.gridx=10; gbc.gridy=60; go.setConstraints(S1,gbc); po.add(S1); //m gbc.anchor=GridBagConstraints.WEST; gbc.gridx=10; gbc.gridy=90; go.setConstraints(ok,gbc); po.add(ok); ok.addActionListener(this); //n gbc.anchor=GridBagConstraints.WEST; gbc.gridx=11; gbc.gridy=90; go.setConstraints(exit,gbc); po.add(exit); exit.addActionListener(this); } public void actionPerformed(ActionEvent ev) { if(ev.getSource()==ok) { try { Connection con; JLabel last =new JLabel("Data inserted successfully"); Class.forName("com.mysql.jdbc.Driver"); con=DriverManager.getConnection("jdbc:mysql://192.168.10.13:3306/ankdb","root","root"); PreparedStatement ps=con.prepareStatement("Insert into studentrecord values(?,?,?,?)"); String id=tf1.getText(); String sname=tf2.getText(); String br=S1.getSelectedItem().toString(); String gen=gender.getSelectedItem().toString(); ps.setString(1,id); ps.setString(2,sname); ps.setString(3,gen); ps.setString(4,br); ps.executeUpdate(); con.close(); tf1.setText(""); tf2.setText(""); } catch(Exception e) { System.out.println("ERROR "+e); } } if(ev.getSource() == exit) { fr.dispose(); } } public static void main(String a[]) { new inswing(); } }