package LvFrm; import java.awt.Color; import java.awt.Font; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.ItemEvent; import java.awt.event.ItemListener; import javax.swing.*; import javax.swing.border.Border; import javax.swing.JButton; @SuppressWarnings("serial") public class Check extends JFrame implements ActionListener,ItemListener { //class declaration JFrame frm; JLabel lbl1,lbl2,lbl3,lbl4,lbl5,lbl6,lbl7,lbl8,lbl9,lbl10, lbl11,lbl12,lbl13,lbl14,lbl15,lbl16,lbl17,lbl18,lbl19,lbl20; JTextField txf1,txf2,txf3,txf4,txf5,txf6,txf7,txf8,txf9,txf10; JPanel panel1,panel2,panel3,panel4; Font f1; JComboBox i1,j1,k1; JButton b1,b2; //for date month year entry String strD[]={"Day","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31"}; String strM[]={"Month","Jan","Feb","Mar","App","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"}; String strY[]={"Year","2012"}; Check() { //for font setting f1=new Font("",Font.BOLD,25); this.setLayout(null); //frame declaration JFrame frm=new JFrame("first project"); frm.setSize(650,400); frm.setLayout(null); /*Icon i=new ImageIcon("file:\\C:\\Documents%20and%20Settings\\All%20Users\\Documents\\My%20Pictures\\Sample%20Pictures\\Sunset.jpg"); //.setIcon(new ImageIcon("C://Documents and Settings//smart vision//Desktop")); JLabel image=new JLabel(i); image.setBounds(100,100,125,120); frm.add(image); */ lbl1=new JLabel("JOB WORK CENTRAL"); lbl1.setBounds(235,10,135,35); frm.add(lbl1); lbl2=new JLabel("Home Shop "); lbl2.setFont(f1); lbl2.setBounds(220,30,330,40); frm.add(lbl2); lbl3=new JLabel("Mfrs. of :Baby Tricycles,Jhula,Walker,Rides,Accessories,"); lbl3.setBounds(130, 20, 450, 100); frm.add(lbl3); lbl4=new JLabel (" Corrugated Box,Rolls,Sheets & Packing Materials"); lbl4.setBounds(150, 30, 450, 105); frm.add(lbl4); lbl5=new JLabel("B39/4,SITE-IV,SAHIBABAD INDUSTRIAL AREA,,GAZIABAD(U.P)201010"); lbl5.setBounds(100, 40, 480, 145); frm.add(lbl5); lbl6=new JLabel("Job Work :All Kinds Of Powder Coating Items"); lbl6.setBounds(160, 30, 465, 135); frm.add(lbl6); lbl7=new JLabel("TIN NO:09888807951"); lbl7.setBounds(10,10,125,30); frm.add(lbl7); lbl8=new JLabel("Dated 3-7-2008"); lbl8.setBounds(10,20,135,40); frm.add(lbl8); lbl9=new JLabel("Customer Mob No-"); lbl9.setBounds(10,80,135,90); frm.add(lbl9); //m/s label & textfld lbl10=new JLabel("M/s."); lbl10.setBounds(35,105,135,110); frm.add(lbl10); txf1=new JTextField(); txf1.setBounds(70, 150, 130, 25); frm.add(txf1); //address label & textfld lbl11=new JLabel("Address"); lbl11.setBounds(10,150,135,110); frm.add(lbl11); txf2=new JTextField(); txf2.setBounds(70, 190, 130, 30); frm.add(txf2); //book no label & textfld lbl12=new JLabel("Book NO"); lbl12.setBounds(250,105,80,110); frm.add(lbl12); txf4=new JTextField(); txf4.setBounds(300, 150, 32, 20); frm.add(txf4); //sr no label n textfield lbl13=new JLabel(" Sr No"); lbl13.setBounds(330,105,40,110); frm.add(lbl13); txf5=new JTextField(); txf5.setBounds(364, 150, 40, 20); frm.add(txf5); //transport label & textfld lbl16=new JLabel(" Transport"); lbl16.setBounds(245,150,70,145); frm.add(lbl16); txf6=new JTextField(); txf6.setBounds(315, 212, 80, 25); frm.add(txf6); //g.r no label & textfld lbl17=new JLabel(" G.R No."); lbl17.setBounds(430,150,70,145); frm.add(lbl17); txf7=new JTextField(); txf7.setBounds(480, 212,100, 25); frm.add(txf7); //creating button & adding to Frame b1=new JButton("Add"); b1.setBounds(220,270,70,20); frm.add(b1); b1.addActionListener(this); b2=new JButton("Print"); b2.setBounds(300,270,80,20); frm.add(b2); //panel1 declaration panel1=new JPanel(); panel1.setLayout(null); panel1.setBounds(5, 10, 600,130); Border b1= BorderFactory.createLineBorder(Color.darkGray); panel1.setBorder(b1); frm.add(panel1); //panel2 declaration panel2=new JPanel(); panel2.setLayout(null); panel2.setBounds(5, 140, 600,100); Border b2= BorderFactory.createLineBorder(Color.darkGray); panel2.setBorder(b2); frm.add(panel2); /*for date entry & adding date into panel 2 also addind panel into frame */ lbl14=new JLabel("Date"); lbl14.setBounds(400,10,30,20); frm.add(lbl14); panel2.add(lbl14); i1=new JComboBox(strD); i1.setBounds(430, 10, 50, 20); i1.addItemListener(this); frm.add(i1); panel2.add( i1); j1=new JComboBox(strM); j1.setBounds(480, 10, 60, 20); j1.addItemListener(this); frm.add(j1); panel2.add(j1); k1=new JComboBox(strY); k1.setBounds(540, 10, 60, 20); k1.addItemListener(this); frm.add(k1); panel2.add(k1); /*time of removal goods label & text field & * adding it to panel2 */ lbl15=new JLabel("Time Of Removal Of Goods"); lbl15.setBounds(245,30,170,30); frm.add(lbl15); panel2.add(lbl15); txf3=new JTextField(); txf3.setBounds(425, 35, 170, 25); frm.add(txf3); panel2.add(txf3); frm.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); frm.setVisible(true); } //main public static void main(String args[]) { new Check(); new bean(); new Conn(); } @Override public void itemStateChanged(ItemEvent arg0) { // TODO Auto-generated method stub } @Override public void actionPerformed(ActionEvent arg0) { // TODO Auto-generated method stub } }
import java.sql.*; import java.awt.*; import java.util.*; import java.text.*; import javax.swing.*; import java.awt.event.*; public class GetDate{ static String months[]={"Month","Jan","Feb","Mar","App","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"}; static int getMonth(String month){ for(int i = 0; i<12; i++) { if(month == months[i]) return i; } return 0; } public static void main(String args[]){ GetDate get=new GetDate(); } public GetDate(){ JFrame f = new JFrame(); f.getContentPane().setLayout(null); final JComboBox day=new JComboBox(); final JComboBox month=new JComboBox(); final JComboBox year=new JComboBox(); JButton button= new JButton("Submit"); day.addItem("Day"); year.addItem("Year"); for(int i=1;i<=31;i++){ day.addItem(i); } day.setBounds(10,10,10,10); for(int j=0;j<months.length;j++){ month.addItem(months[j]); } for(int k=1980;k<=2012;k++){ year.addItem(k); } day.setBounds(50,50,60,20); month.setBounds(120,50,80,20); year.setBounds(210,50,60,20); button.setBounds(50,80,100,20); button.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ Object ob1=day.getSelectedItem(); Object ob2=month.getSelectedItem(); Object ob3=year.getSelectedItem(); int d=Integer.parseInt(ob1.toString()); String mon=ob2.toString(); int m=getMonth(mon); int y=Integer.parseInt(ob3.toString()); Calendar cal = GregorianCalendar.getInstance(); cal.set(y, m-1, d); SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd"); System.out.println(sdf.format(cal.getTime())); } }); f.add(day); f.add(month); f.add(year); f.add(button); f.setVisible(true); f.setSize(300,200); } }
import java.sql.*; import java.awt.*; import javax.swing.*; import java.awt.event.*; public class GetDOB{ public static void main(String args[]){ GetDOB get=new GetDOB(); } public GetDOB(){ JFrame f = new JFrame(); f.getContentPane().setLayout(null); final JComboBox day=new JComboBox(); final JComboBox month=new JComboBox(); final JComboBox year=new JComboBox(); JButton button= new JButton("Submit"); for(int i=1;i<=31;i++){ day.addItem(i); } day.setBounds(10,10,10,10); for(int j=1;j<=12;j++){ month.addItem(j); } for(int k=1900;k<=2010;k++){ year.addItem(k); } day.setBounds(50,50,40,20); month.setBounds(100,50,40,20); year.setBounds(150,50,60,20); button.setBounds(50,80,100,20); button.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ Object ob1=day.getSelectedItem(); Object ob2=month.getSelectedItem(); Object ob3=year.getSelectedItem(); int d=Integer.parseInt(ob1.toString()); int m=Integer.parseInt(ob2.toString()); int y=Integer.parseInt(ob3.toString()); try{ Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root";, "root"); PreparedStatement pstmt = conn.prepareStatement("insert into d(myDate) values(?)"); java.sql.Date sqlDate = new java.sql.Date(y-1900,m-1,d); pstmt.setDate(1, sqlDate); pstmt.executeUpdate(); JOptionPane.showMessageDialog(null,"Date in inserted successfully"); } catch(Exception ex){} } }); f.add(day); f.add(month); f.add(year); f.add(button); f.setVisible(true); f.setSize(300,200); } }
Ads