Bom dia galerinha,
To com o seguinte projeto para desenvolver, tenho que criar um projeto desktop para uma microempresa de assistência de pc, eles me pediram a seguinte coisa:
1:Uma interface gráfica bonitinha,(já fiz)
2:Usar um banco localhost MySql;
3:Tem que ter 3 abas(CLIENTE,SERVIÇO e PESQUISAR);
package view;
import javax.swing.DebugGraphics;
import javax.swing.DefaultComboBoxModel;
import javax.swing.JButton;
import javax.swing.JCheckBox;
import javax.swing.JLabel;
import javax.swing.JList;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTabbedPane;
import javax.swing.JTextField;
import javax.swing.ListModel;
import javax.swing.SwingUtilities;
import com.cloudgarden.layout.AnchorConstraint;
import com.cloudgarden.layout.AnchorLayout;
public class TecInfoView extends javax.swing.JFrame {
private JPanel ClienteJPanel;
private JTextField nomeTextField;
private JTextField jTextField1;
private JLabel jLabel1;
private JButton pesquisarButton;
private JCheckBox servicoCheckBox;
private JCheckBox clienteCheckBox;
private JPanel PesquisaJPanel;
private JTextField enderecoTextField;
private JTabbedPane jTabbedPane;
private JButton gravarBotaoServicoButton;
private JTextField descricaoTextField;
private JLabel descricaoLabel;
private JTextField clienteTextField;
private JLabel clienteLabel;
private JScrollPane jScrollPane1;
private JList jList;
private JPanel ServiçoJPanel;
private JButton botaoGravarjButton;
private JTextField emailTextField;
private JLabel emailLabel;
private JTextField cidadeTextField;
private JLabel cidadeLabel;
private JTextField sobreNomeTextField;
private JLabel sobreNomeLabel;
private JLabel enderecoLabel;
private JLabel nomeLabel;
public static void main(String[] args) {
SwingUtilities.invokeLater(new Runnable() {
public void run() {
TecInfoView inst = new TecInfoView();
inst.setLocationRelativeTo(null);
inst.setVisible(true);
}
});
}
public TecInfoView() {
super();
initGUI();
}
private void initGUI() {
try {
{
this.setName("");
AnchorLayout thisLayout = new AnchorLayout();
getContentPane().setLayout(thisLayout);
this.setTitle("TECINFO LTDA - Sistema Operacional");
{
jTabbedPane = new JTabbedPane();
getContentPane().add(
jTabbedPane,
new AnchorConstraint(12, 984, 977, 9,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL));
jTabbedPane.setPreferredSize(new java.awt.Dimension(701,
490));
{
ClienteJPanel = new JPanel();
jTabbedPane
.addTab("Cliente", null, ClienteJPanel, null);
AnchorLayout clientePanelLayout = new AnchorLayout();
ClienteJPanel.setLayout(clientePanelLayout);
ClienteJPanel.setPreferredSize(new java.awt.Dimension(
197, 217));
ClienteJPanel.setBackground(new java.awt.Color(255,
255, 255));
{
botaoGravarjButton = new JButton();
ClienteJPanel.add(botaoGravarjButton,
new AnchorConstraint(856, 984, 977, 710,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL));
botaoGravarjButton.setText("Gravar");
botaoGravarjButton
.setPreferredSize(new java.awt.Dimension(
191, 56));
}
{
emailTextField = new JTextField();
ClienteJPanel.add(emailTextField,
new AnchorConstraint(649, 990, 705, 48,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL));
emailTextField
.setPreferredSize(new java.awt.Dimension(
656, 26));
}
{
emailLabel = new JLabel();
ClienteJPanel.add(emailLabel, new AnchorConstraint(
585, 150, 615, 48,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL));
emailLabel.setText("E-mail");
emailLabel.setPreferredSize(new java.awt.Dimension(
71, 14));
}
{
cidadeTextField = new JTextField();
ClienteJPanel.add(cidadeTextField,
new AnchorConstraint(307, 532, 356, 48,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL));
cidadeTextField
.setPreferredSize(new java.awt.Dimension(
337, 23));
}
{
cidadeLabel = new JLabel();
ClienteJPanel.add(cidadeLabel,
new AnchorConstraint(251, 153, 281, 48,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL));
cidadeLabel.setText("Cidade");
cidadeLabel
.setPreferredSize(new java.awt.Dimension(
73, 14));
}
{
sobreNomeTextField = new JTextField();
ClienteJPanel.add(sobreNomeTextField,
new AnchorConstraint(134, 983, 184, 532,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL));
sobreNomeTextField
.setPreferredSize(new java.awt.Dimension(
314, 24));
}
{
sobreNomeLabel = new JLabel();
ClienteJPanel.add(sobreNomeLabel,
new AnchorConstraint(80, 650, 110, 532,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL));
sobreNomeLabel.setText("Sobrenome");
sobreNomeLabel
.setPreferredSize(new java.awt.Dimension(
82, 14));
}
{
enderecoLabel = new JLabel();
ClienteJPanel.add(enderecoLabel,
new AnchorConstraint(406, 206, 451, 48,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL));
enderecoLabel.setText("Endereço");
enderecoLabel
.setPreferredSize(new java.awt.Dimension(
110, 21));
}
{
nomeTextField = new JTextField();
ClienteJPanel.add(nomeTextField,
new AnchorConstraint(134, 493, 184, 48,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL));
nomeTextField
.setPreferredSize(new java.awt.Dimension(
314, 24));
}
{
nomeLabel = new JLabel();
ClienteJPanel.add(nomeLabel, new AnchorConstraint(
72, 118, 119, 48,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL));
nomeLabel.setText("Nome");
nomeLabel.setPreferredSize(new java.awt.Dimension(
49, 22));
}
{
enderecoTextField = new JTextField();
ClienteJPanel.add(enderecoTextField,
new AnchorConstraint(477, 532, 526, 48,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL));
enderecoTextField
.setPreferredSize(new java.awt.Dimension(
337, 23));
}
}
{
ServiçoJPanel = new JPanel();
jTabbedPane
.addTab("Serviço", null, ServiçoJPanel, null);
AnchorLayout servicoPanelLayout = new AnchorLayout();
ServiçoJPanel.setLayout(servicoPanelLayout);
ServiçoJPanel.setPreferredSize(new java.awt.Dimension(
261, 186));
ServiçoJPanel.setBackground(new java.awt.Color(255,
255, 255));
{
gravarBotaoServicoButton = new JButton();
ServiçoJPanel.add(gravarBotaoServicoButton,
new AnchorConstraint(856, 984, 977, 711,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL));
gravarBotaoServicoButton.setText("Gravar");
gravarBotaoServicoButton
.setPreferredSize(new java.awt.Dimension(
190, 56));
}
{
descricaoTextField = new JTextField();
ServiçoJPanel.add(descricaoTextField,
new AnchorConstraint(294, 983, 813, 16,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL));
descricaoTextField
.setPreferredSize(new java.awt.Dimension(
673, 241));
descricaoTextField
.setDebugGraphicsOptions(DebugGraphics.BUFFERED_OPTION);
}
{
descricaoLabel = new JLabel();
ServiçoJPanel.add(descricaoLabel,
new AnchorConstraint(240, 223, 268, 9,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL));
descricaoLabel.setText("Descrição");
descricaoLabel
.setPreferredSize(new java.awt.Dimension(
149, 13));
}
{
clienteTextField = new JTextField();
ServiçoJPanel.add(clienteTextField,
new AnchorConstraint(130, 595, 182, 16,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL));
clienteTextField
.setPreferredSize(new java.awt.Dimension(
403, 24));
}
{
clienteLabel = new JLabel();
ServiçoJPanel.add(clienteLabel,
new AnchorConstraint(76, 104, 104, 9,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL));
clienteLabel.setText("Cliente");
clienteLabel
.setPreferredSize(new java.awt.Dimension(
66, 13));
}
}
{
PesquisaJPanel = new JPanel();
AnchorLayout PesquisaJPanelLayout = new AnchorLayout();
PesquisaJPanel.setLayout(PesquisaJPanelLayout);
jTabbedPane.addTab("Pesquisa", null, PesquisaJPanel,
null);
PesquisaJPanel.setBackground(new java.awt.Color(255,
255, 255));
{
jScrollPane1 = new JScrollPane();
PesquisaJPanel.add(jScrollPane1,
new AnchorConstraint(273, 982, 841, 36,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL));
jScrollPane1
.setPreferredSize(new java.awt.Dimension(
780, 285));
{
ListModel jListModel = new DefaultComboBoxModel(
new String[] { "Item One", "Item Two" });
jList = new JList();
jScrollPane1.setViewportView(jList);
jList.setModel(jListModel);
jList.setPreferredSize(new java.awt.Dimension(
780, 285));
}
}
{
jTextField1 = new JTextField();
PesquisaJPanel.add(jTextField1,
new AnchorConstraint(132, 516, 174, 26,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL));
jTextField1
.setPreferredSize(new java.awt.Dimension(
405, 21));
}
{
jLabel1 = new JLabel();
PesquisaJPanel.add(jLabel1, new AnchorConstraint(
92, 108, 120, 26,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL));
jLabel1.setText("Cliente");
jLabel1.setPreferredSize(new java.awt.Dimension(68,
14));
}
{
pesquisarButton = new JButton();
PesquisaJPanel.add(pesquisarButton,
new AnchorConstraint(857, 987, 979, 713,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL));
pesquisarButton.setText("Pesquisar");
pesquisarButton
.setPreferredSize(new java.awt.Dimension(
226, 61));
}
{
servicoCheckBox = new JCheckBox();
PesquisaJPanel.add(servicoCheckBox,
new AnchorConstraint(134, 700, 170, 617,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL));
servicoCheckBox.setText("Serviço");
servicoCheckBox
.setPreferredSize(new java.awt.Dimension(
68, 18));
servicoCheckBox.setBackground(new java.awt.Color(
255, 255, 255));
}
{
clienteCheckBox = new JCheckBox();
PesquisaJPanel.add(clienteCheckBox,
new AnchorConstraint(84, 701, 120, 618,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL,
AnchorConstraint.ANCHOR_REL));
clienteCheckBox.setText("Cliente");
clienteCheckBox
.setPreferredSize(new java.awt.Dimension(
68, 18));
clienteCheckBox.setBackground(new java.awt.Color(
255, 255, 255));
}
}
}
}
this.setSize(859, 574);
} catch (Exception e) {
e.printStackTrace();
}
}
}
Bom, como viram vai ter 2 botões GRAVAR e um PESQUISAR, e na aba PESQUISAR vai ter checkbox, quando marcados tal, vai ter que ser retornavel o item correto, minha duvida é o seguinte, como faço para salvar os dados digitados TextFiel, salaverem no banco quando clicado GRAVAR e na aba PESQUISAR, retornar a pesquisa dentro de um TextFiel ou JTable (tbm é minha dúvida)
Fiz uma classe para conectar-se ao banco segue:
package model;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class ConectaBanco {
public Connection getConnection() {
try {
return DriverManager.getConnection(
"jdbc:mysql://localhost/tecinfo", "root", "adminadmin");
} catch (SQLException e) {
throw new RuntimeException(e);
}
}
}
Que também está rodando, certinho.
Obrigado, aguardo resposta.



