public Welcome() { c.setLayout(null); c.add(welcome); welcome.setBounds(250, 100, 600, 50); welcome.setFont(font1); welcome.setForeground(Color.black); c.add(hotel); hotel.setBounds(350, 170, 700, 50); hotel.setFont(font2); hotel.setForeground(Color.black); c.add(check); check.setBounds(450, 350, 250, 50); check.addActionListener(this); c.add(order); order.setBounds(150, 350, 250, 50); order.addActionListener(this); c.add(bill); bill.setBounds(750, 350, 250, 50); bill.addActionListener(this); c.add(exit); exit.setBounds(40, 600, 130, 20); exit.addActionListener(this); c.add(back).setBounds(0, 0, 1800, 1000); }
stab(ResultSet k) { super("PATIENT FOUND"); String[] chd = { "Date", "Patient ID", "Name", "Gender", "Age", "Weight", "Address", "Contact No.", "Doctor Name", "Symptoms", "Dignosis", "Fee: Rs.", "Blood Group" }; // DefaultTableModel dtm=new DefaultTableModel(); // jt.setModel(new DefaultTableModel(arr,chd)); jt = new JTable(); jsp = new JScrollPane(jt); btn = new JButton("CLOSE"); btn.addActionListener(this); int i = 0; try { while (k.next()) { arr[i][0] = k.getString(1); // System.out.println("ddddddddddddd"+arr[i][0]); arr[i][1] = "" + k.getInt(2); arr[i][2] = k.getString(3) + " " + k.getString(4) + " " + k.getString(5); arr[i][3] = k.getString(6); arr[i][4] = "" + k.getInt(7); arr[i][5] = k.getString(8); arr[i][6] = k.getString(9); arr[i][7] = k.getString(10); arr[i][8] = k.getString(11); arr[i][9] = k.getString(12); arr[i][10] = k.getString(13); arr[i][11] = "" + k.getInt(14); arr[i][12] = k.getString(15); arr[i][13] = k.getString(16); // dtm.insertRow(i,new Object[]{patient.rs.getString(1), // patient.rs.getInt(2),patient.rs.getString(3)+patient.rs.getString(4)+patient.rs.getString(5),patient.rs.getString(6),patient.rs.getInt(7),patient.rs.getString(8),patient.rs.getString(9),patient.rs.getString(10),patient.rs.getString(11),patient.rs.getString(12),patient.rs.getString(13),patient.rs.getInt(14)}); i++; } } catch (Exception e12) { System.out.println("" + e12); } jt.setModel(new DefaultTableModel(arr, chd)); Container con = getContentPane(); con.setLayout(null); jsp.setBounds(20, 20, 1230, 600); btn.setBounds(685, 630, 100, 30); add(jsp); add(btn); setSize(1330, 800); setVisible(true); }
public ItensVendidos() { super("Itens Vendidos"); JButton imprimir; final DefaultTableModel modelo = new DefaultTableModel(); // constrói a tabela JTable tabela = new JTable(modelo); // Cria duas colunas modelo.addColumn("Código"); modelo.addColumn("Vendedor"); modelo.addColumn("Produto"); modelo.addColumn("Quantidade"); imprimir = new JButton("Imprimir"); imprimir.setBounds(100, 450, 30, 24); // exibe os dados da tabela MySQL // Conexao banco = new Conexao(); String retorno = "erro"; try { // Connection ExConn = (Connection) banco.abrirBDconn(); Class.forName("com.mysql.jdbc.Driver"); Connection conexao = DriverManager.getConnection("jdbc:mysql://localhost/banco", "root", ""); Statement stmt = conexao.createStatement(); // procedimentos para obter os dados de uma tabela String query = "SELECT * FROM venda2"; ResultSet rs = stmt.executeQuery(query); while (rs.next()) { int id = rs.getInt("idVendedor"); String nome = rs.getString("nomeVendedor"); String produto = rs.getString("produto"); int qtd = rs.getInt("qtd"); modelo.addRow(new Object[] {new Integer(id), nome, produto, new Integer(qtd)}); } // fim procedimento para obter os dados } catch (SQLException ex) { System.out.println("SQLException: " + ex.getMessage()); System.out.println("SQLState: " + ex.getSQLState()); System.out.println("VendorError: " + ex.getErrorCode()); } catch (Exception e) { System.out.println("Problemas ao tentar conectar com o banco de dados"); } // fim MySQL tabela.setPreferredScrollableViewportSize(new Dimension(350, 50)); Container c = getContentPane(); c.setLayout(new FlowLayout()); JScrollPane scrollPane = new JScrollPane(tabela); c.add(scrollPane); c.add(imprimir); setSize(400, 300); setVisible(true); }
public Assi() { c = getContentPane(); c.setLayout(new BorderLayout()); c.add(pnn, BorderLayout.NORTH); c.add(pns, BorderLayout.SOUTH); c.add(pnc, BorderLayout.CENTER); c.add(pne, BorderLayout.EAST); pne.setLayout(new GridLayout(2, 1)); pne.add(pne1); pne.add(pne2); pne1.setLayout(new FlowLayout()); pne1.add(go); go.addItem("Student"); go.addItem("Teacher"); go.addItem("Course"); go.addItem("Result"); pne1.add(b6); pne2.setLayout(cl2); pns.add(b1); pns.add(b2); pns.add(b3); pns.add(b4); pns.add(b5); setJMenuBar(m); m.add(student); m.add(teacher); m.add(course); m.add(result); stu.setLayout(new GridLayout(8, 2)); stu.add(l1); stu.add(t1); stu.add(l2); stu.add(t2); stu.add(l3); stu.add(t3); stu.add(l4); stu.add(t4); stu.add(l5); stu.add(t5); stu.add(l6); stu.add(t6); cou.setLayout(new GridLayout(4, 2)); cou.add(l7); cou.add(t7); cou.add(l8); cou.add(t8); cou.add(l9); cou.add(t9); cou.add(l0); cou.add(t0); tea.setLayout(new GridLayout(4, 2)); tea.add(l11); tea.add(t11); tea.add(l12); tea.add(t12); tea.add(l13); tea.add(t13); tea.add(l14); tea.add(t14); res.setLayout(new GridLayout(15, 3)); res.add(l15); res.add(t15); res.add(l16); res.add(t16); res.add(l17); res.add(t17); res.add(lg); res.add(l); res.add(l18); res.add(t18); res.add(l19); res.add(t19); res.add(l20); res.add(t20); res.add(l21); res.add(t21); res.add(l22); res.add(t22); res.add(l23); res.add(t23); res.add(l24); res.add(t24); res.add(l25); res.add(t25); res.add(l26); res.add(t26); res.add(l27); res.add(t27); res.add(l28); res.add(t28); pnc.setLayout(cl); pnc.add(blk, "cblk"); pnc.add(stu, "cstu"); pnc.add(tea, "ctea"); pnc.add(cou, "ccou"); pnc.add(res, "cres"); b1.addActionListener(this); b2.addActionListener(this); b3.addActionListener(this); b4.addActionListener(this); b5.addActionListener(this); b6.addActionListener(this); student.addActionListener(this); teacher.addActionListener(this); course.addActionListener(this); result.addActionListener(this); go.addItemListener(this); }
public vehicle() { message = new JLabel("VEHICLE DETAILS"); mname = new JLabel("Model Name"); cap = new JLabel("Capacity"); cc = new JLabel("CC"); eng = new JLabel("Engine"); stroke = new JLabel("Stroke"); bhp = new JLabel("BHP"); volt = new JLabel("Volts"); rpm = new JLabel("RPM"); weight = new JLabel("Weight"); kg = new JLabel("Kg"); gear = new JLabel("Gears"); color = new JLabel("Color"); jcmname = new JComboBox(); tfcap = new JTextField(30); tfeng = new JTextField(20); tfbhp = new JTextField(10); tfvolt = new JTextField(20); tfrpm = new JTextField(20); tfweight = new JTextField(20); tfgear = new JTextField(30); jccolor = new JComboBox(); ok = new JButton("OK"); can = new JButton("CANCEL"); can.addActionListener(this); can.setActionCommand("can"); ok.addActionListener(this); ok.setActionCommand("Ok"); Container c = getContentPane(); setSize(800, 600); setTitle("Vehicle Details"); c.setLayout(null); setVisible(true); c.add(message); c.add(mname); c.add(cap); c.add(cc); c.add(eng); c.add(stroke); c.add(bhp); c.add(volt); c.add(rpm); c.add(weight); c.add(kg); c.add(gear); c.add(color); c.add(jcmname); c.add(tfcap); c.add(tfeng); c.add(tfbhp); c.add(tfvolt); c.add(tfrpm); c.add(tfweight); c.add(tfgear); c.add(jccolor); c.add(ok); c.add(can); c.setBackground(Color.pink); message.setBounds(300, 40, 200, 50); mname.setBounds(50, 100, 100, 30); cap.setBounds(50, 150, 100, 30); cc.setBounds(275, 150, 50, 30); eng.setBounds(50, 200, 50, 30); stroke.setBounds(275, 200, 100, 30); bhp.setBounds(50, 250, 100, 30); volt.setBounds(50, 300, 100, 30); rpm.setBounds(50, 350, 100, 30); weight.setBounds(50, 400, 50, 30); kg.setBounds(275, 400, 100, 30); gear.setBounds(450, 150, 150, 30); color.setBounds(450, 200, 100, 30); jcmname.setBounds(200, 100, 100, 30); jcmname.addItem(" -- Select --"); jcmname.addItem("Pulsar"); jcmname.addItem("CT 100"); jcmname.addItem("Discover DTS-i"); jcmname.addItem("Wave DTS-i"); tfcap.setBounds(200, 150, 70, 30); tfeng.setBounds(200, 200, 70, 30); tfbhp.setBounds(200, 250, 70, 30); tfvolt.setBounds(200, 300, 70, 30); tfrpm.setBounds(200, 350, 70, 30); tfweight.setBounds(200, 400, 70, 30); tfgear.setBounds(500, 150, 70, 30); jccolor.setBounds(500, 200, 100, 30); jccolor.addItem("Black"); jccolor.addItem("Blue"); jccolor.addItem("Red"); jccolor.addItem("Grey"); ok.setBounds(270, 480, 85, 30); can.setBounds(370, 480, 85, 30); }
public Design() throws Exception { super.setBackground(Color.BLACK); this.setTitle(""); con = getContentPane(); con.setLayout(null); dim = tk.getDefaultToolkit().getScreenSize(); this.setTitle("Customer Peer Login"); l1 = new JLabel(new ImageIcon("plain.jpg")); l1.setBounds(0, 0, 400, 400); con.add(l1); l1.setBorder(BorderFactory.createEtchedBorder(5, Color.black, Color.black)); title = new JLabel("CUSTOMER PEER LOGIN "); title.setFont(new Font("Bookman Old Style", Font.ROMAN_BASELINE, 20)); title.setForeground(Color.red); title.setBounds(80, 30, 300, 30); l1.add(title); l4 = new JLabel("CMACHINE NAME"); l4.setFont(new Font("Bookman Old Style", Font.BOLD, 16)); l4.setForeground(Color.BLUE); l4.setBounds(70, 100, 160, 20); // l4.setBorder(BorderFactory.createEtchedBorder(5,Color.green,Color.green)); l1.add(l4); jtf2 = new JTextField(); jtf2.setBounds(250, 100, 100, 20); jtf2.setBorder(BorderFactory.createEtchedBorder(5, Color.green, Color.green)); l1.add(jtf2); l2 = new JLabel("CUSER LOGIN"); l2.setFont(new Font("Bookman Old Style", Font.BOLD, 16)); l2.setForeground(Color.blue); l2.setBounds(70, 150, 120, 20); l1.add(l2); jtf1 = new JTextField(); jtf1.setBounds(250, 150, 100, 20); jtf1.setBorder(BorderFactory.createEtchedBorder(5, Color.green, Color.green)); l1.add(jtf1); l3 = new JLabel("CPASSWORD"); l3.setFont(new Font("Bookman Old Style", Font.BOLD, 16)); l3.setForeground(Color.blue); l3.setBounds(70, 200, 120, 20); l1.add(l3); jptf1 = new JPasswordField(); jptf1.setBounds(250, 200, 100, 20); jptf1.setBorder(BorderFactory.createEtchedBorder(5, Color.green, Color.green)); l1.add(jptf1); JLabel l4 = new JLabel("DAgent"); l4.setFont(new Font("Bookman Old Style", Font.BOLD, 16)); l4.setForeground(Color.blue); l4.setBounds(70, 250, 120, 20); l1.add(l4); box = new JComboBox(); box.setBounds(250, 250, 100, 20); box.setBorder(BorderFactory.createEtchedBorder(5, Color.green, Color.green)); l1.add(box); b2 = new JButton("Register"); b2.setBounds(50, 300, 100, 20); l1.add(b2); b2.setBorder(BorderFactory.createEtchedBorder(10, Color.BLUE, Color.BLUE)); b3 = new JButton("Login"); b3.setBounds(150, 300, 100, 20); b3.setBorder(BorderFactory.createEtchedBorder(10, Color.BLUE, Color.BLUE)); l1.add(b3); b1 = new JButton("Cancel"); b1.setBounds(250, 300, 100, 20); b1.setBorder(BorderFactory.createEtchedBorder(10, Color.BLUE, Color.BLUE)); l1.add(b1); b1.addActionListener( new ActionListener() { public void actionPerformed(ActionEvent we) { dispose(); } }); try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); conn = DriverManager.getConnection("jdbc:odbc:agent"); } catch (Exception exp) { } try { Statement satem = conn.createStatement(); ResultSet rsatem = satem.executeQuery("select * from Dagent"); while (rsatem.next()) { String namem = rsatem.getString("uname"); box.addItem(namem); } } catch (Exception expo1) { } b2.addActionListener( new ActionListener() { public void actionPerformed(ActionEvent we) { String username = jtf1.getText().trim(); String password = jptf1.getText().trim(); String mechine = jtf2.getText().trim(); String dname = box.getSelectedItem().toString(); int porte = 0; try { Statement sate = conn.createStatement(); ResultSet rsate = sate.executeQuery("select * from Dagent where uname='" + dname + "'"); if (rsate.next()) { servermachine = rsate.getString("umechine"); porte = rsate.getInt("ulistport"); System.out.println(servermachine); } System.out.println(servermachine); } catch (Exception exp) { exp.printStackTrace(); } try { packet p = new packet(); p.setaction("Creg"); p.setCuser(username); p.setCpass(password); p.setCmname(mechine); p.setCDpeer(dname); Socket soc = new Socket(servermachine, porte); ObjectOutputStream out = new ObjectOutputStream(soc.getOutputStream()); out.writeObject(p); ObjectInputStream in = new ObjectInputStream(soc.getInputStream()); packet rpac = (packet) in.readObject(); if (rpac.getaction().equals("ok")) { JOptionPane.showMessageDialog(null, "Sucessfully Registered"); jtf2.setText(""); jtf1.setText(""); jptf1.setText(""); } else { JOptionPane.showMessageDialog(null, "Already Registered"); jtf2.setText(""); jtf1.setText(""); jptf1.setText(""); } } catch (Exception exp) { } } }); b3.addActionListener( new ActionListener() { public void actionPerformed(ActionEvent we) { String username = jtf1.getText().trim(); String password = jptf1.getText().trim(); String mechine = jtf2.getText().trim(); String Dname = box.getSelectedItem().toString(); int porte = 0; try { Statement sate = conn.createStatement(); ResultSet rsate = sate.executeQuery("select * from Dagent where uname='" + Dname + "'"); if (rsate.next()) { servermachine = rsate.getString("umechine"); porte = rsate.getInt("ulistport"); System.out.println(servermachine); } System.out.println(servermachine); } catch (Exception exp) { } try { packet p1 = new packet(); p1.setaction("clogin"); p1.setCuser(username); p1.setCpass(password); p1.setCmname(mechine); p1.setCDpeer(Dname); Socket soc1 = new Socket(servermachine, porte); ObjectOutputStream out1 = new ObjectOutputStream(soc1.getOutputStream()); out1.writeObject(p1); ObjectInputStream in1 = new ObjectInputStream(soc1.getInputStream()); packet rpac1 = (packet) in1.readObject(); if (rpac1.getaction().equals("ok")) { int port1 = 0; try { int portm = rpac1.getCport(); System.out.println("XXXXXXX" + portm); // JOptionPane.showMessageDialog(null,"Sucessfully Started"); new Listen(portm); new process(username, portm); dispose(); } catch (Exception exp) { } } else { JOptionPane.showMessageDialog( null, "Enter valid username and password", "Server reply", 2); jtf1.setText(""); jtf2.setText(""); jptf1.setText(""); } } catch (Exception exp) { } } }); setSize(400, 400); show(); setLocation(150, 100); setResizable(false); }