ja to desanimado d mais galera…por favor me ajudem…nem a minha professora é capaz d me ajuda nessa…só num vo explica o pq dela num consegui me ajuda pq esse num eh o motivo deu taki!!!
intaum…to fazendo um projeto d banco de dados d uma locadora de automoveis…i nela tem o cadastro de clientes e de carros…até aew tudu bem…cadastra bunitinhu…aew tem eh claro os formularios para poder mostrar os dados que estao dentro da tabela do banco de dados…i eh nessa parte q eu empaco…num saiu do lugar…muito dificil isso!!
o codigo fonte dessa parte ta aki:
import java.util.<em>;
import javax.swing.</em>;
import java.sql.<em>;
import java.awt.</em>;
public class impressao extends javax.swing.JFrame {
private String driver;
private String url;
private String userName;
private String password;
private String qry;
private String idAutomovel="";
private Connection conn;
public impressao() {
initComponents();
Configuracao cf = new Configuracao();
driver = cf.getDriver();
url = cf.getUrl();
userName = cf.getUserName();
password = cf.getPassword();
try{
Class.forName(driver);
conn = DriverManager.getConnection(url,userName,password);
}catch(ClassNotFoundException cnfex){
}catch(SQLException sqlex){
}
pesquisaTabela();
}
private void pesquisaTabela(){
Statement comm;
ResultSet resultSet;
String query;
try{
query = "select Chassis, cor, placa, modelo, marca, idAutomovel from automovel";
comm = conn.createStatement();
resultSet = comm.executeQuery(query);
exibeDados(resultSet);
comm.close();
}catch(SQLException sqlex){
}
}
private void exibeDados( ResultSet rs) throws SQLException{
boolean registro = rs.next();
if(!registro){
JOptionPane.showMessageDialog(this, "Tabela Vazia");
setTitle("Sem registros para exibir");
return;
}
setTitle("Automoveis");
Vector colunas = new Vector();
Vector linhas = new Vector();
try{
ResultSetMetaData rsmd = rs.getMetaData();
for(int i = 1; i<=rsmd.getColumnCount(); ++i){
colunas.addElement(trataNomeColuna(rsmd.getColumnName(i)));
}
do{
linhas.addElement(recuperaDados(rs,rsmd));
}while(rs.next());
tblVeiculos = new JTable(linhas,colunas);
JScrollPane scroller = new JScrollPane(tblVeiculos);
getContentPane().add(scroller, BorderLayout.CENTER);
validate();
}catch(SQLException sqlex){
}
}
private Vector recuperaDados(ResultSet rs, ResultSetMetaData rsmd) throws SQLException {
Vector dadosTabela = new Vector();
for(int i = 1 ; i <= rsmd.getColumnCount() ; ++i){
dadosTabela.addElement(rs.getString(i));
}
return dadosTabela;
}
private void fechaConexao(){
try{
conn.close();
}
catch(SQLException sqlex){
System.err.println("Não foi possovel encerra a conexao");
sqlex.printStackTrace();
}
}
private String trataNomeColuna(String str){
String result ="";
String[] nomeColuna = new String[6];
nomeColuna[0] = "Chassis";
nomeColuna[1] = "cor";
nomeColuna[2] = "placa";
nomeColuna[3] = "modelo";
nomeColuna[4] = "marca";
nomeColuna[5] = "idAutomovel";
String[] nomeTratado = new String [6];
nomeTratado[0] = "Chassis";
nomeTratado[1] = "Cor";
nomeTratado[2] = "Placa";
nomeTratado[3] = "Modelo";
nomeTratado[4] = "Marca";
nomeTratado[5] = "Identificação";
for(int i = 0; i <= nomeColuna.length; ++i){
if(str.toUpperCase().trim().equals(nomeColuna[i].toUpperCase().trim())){
result = nomeTratado[i];
break;
}
}
return result;
}
public String getIdAutomovel() {
return idAutomovel;
}
private void pegaValor(){
int row;
int col=1;
try{
row =tblVeiculos.getSelectedRow();
if(row >= 0){
Object data = tblVeiculos.getValueAt(row, col);
idAutomovel = data.toString();
}
}
catch(Exception e){
idAutomovel = "";
}
}
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jPanel1 = new javax.swing.JPanel();
jScrollPane1 = new javax.swing.JScrollPane();
tblVeiculos = new javax.swing.JTable();
jPanel2 = new javax.swing.JPanel();
jButton1 = new javax.swing.JButton();
jButton2 = new javax.swing.JButton();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder("Dados Veiculos"));
tblVeiculos.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
},
new String [] {
}
));
jScrollPane1.setViewportView(tblVeiculos);
javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
jPanel1.setLayout(jPanel1Layout);
jPanel1Layout.setHorizontalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 597, Short.MAX_VALUE)
.addContainerGap())
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 207, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(19, Short.MAX_VALUE))
);
jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder("Eventos"));
jButton1.setText("jButton1");
jButton2.setText("jButton2");
javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
jPanel2.setLayout(jPanel2Layout);
jPanel2Layout.setHorizontalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addGap(26, 26, 26)
.addComponent(jButton1)
.addGap(59, 59, 59)
.addComponent(jButton2)
.addContainerGap(386, Short.MAX_VALUE))
);
jPanel2Layout.setVerticalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addGap(23, 23, 23)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jButton1)
.addComponent(jButton2))
.addContainerGap(34, Short.MAX_VALUE))
);
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addContainerGap())
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(22, Short.MAX_VALUE))
);
java.awt.Dimension screenSize = java.awt.Toolkit.getDefaultToolkit().getScreenSize();
setBounds((screenSize.width-661)/2, (screenSize.height-451)/2, 661, 451);
}// </editor-fold>
// Variables declaration - do not modify
private javax.swing.JButton jButton1;
private javax.swing.JButton jButton2;
private javax.swing.JPanel jPanel1;
private javax.swing.JPanel jPanel2;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JTable tblVeiculos;
// End of variables declaration
}
c alguem puder me ajudar…eu vo agradece d mais … d mais!!!
vlw galera
qlq coisa c num intendeu só posta alguma pergunta sobre a minha pergunta…q eu esclareço
vlw vlw vlw :-o