|
|
|
|
Bonjour,
ma table n'affiche rien pourquoi malgres que j'ai crer le modele
aidez moiiiii
package combo;
import java.awt.Dimension;
import java.awt.Rectangle;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JFrame;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.AbstractTableModel;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableModel;
public class Frame2 extends JFrame {
Connection con = null;
String requete = "";
int rows = 0 ;
int current = -1 ;
ResultSet resultats = null;
Statement stmt;
private JScrollPane jScrollPane1 = new JScrollPane();
private JTable jTable1 = new JTable();
public Frame2() {
try {
jbInit();
} catch (Exception e) {
e.printStackTrace();
}
}
private void jbInit() throws Exception {
this.getContentPane().setLayout( null );
this.setSize( new Dimension(400, 300) );
jScrollPane1.setBounds(new Rectangle(5, 30, 300, 175));
jScrollPane1.getViewport().add(jTable1, null);
this.getContentPane().add(jScrollPane1, null);
TableModel MonModele = jTable1.getModel();
jTable1.setModel(MonModele);
}
public void connexionBD() {
Connection con = null;
String requete = "";
int rows = 0 ;
int current = -1 ;
ResultSet resultats = null;
Statement stmt;
try
{
//chargement de driver
Class.forName("oracle.jdbc.driver.OracleDriver");
System.out.println ("driver etablie");
}
catch(Exception e)
{
System.out.println ("erreur:Driver int" +
"rouvable");
}
//connexion à la base
try
{
String URL = "jdbc:oracle:thin:@SERVEUR2:1521:FR2";
String USER = "test";
String PASSWD = "test";
con =DriverManager.getConnection(URL,USER, PASSWD);
System.out.println ("connexion base test etablie");
}
catch(Exception e)
{
System.out.println ("erreur: base introuvable");
}}
class MonModele extends AbstractTableModel {
int rows = 0 ;
ResultSet resultats;
String req= "SELECT*FROM TT";
public MonModele( ResultSet resultats, int rows) {
try {
Statement stmt = con.createStatement();
resultats = stmt.executeQuery(requete);
} catch (SQLException e) {
System.out.println("Anomalie lors de l'execution de la requête");
}
try
{
this. resultats = resultats ;
this.rows = rows ;
current = 0 ;
this.resultats.beforeFirst() ;
this. resultats.next() ;
}
catch (SQLException e)
{
System.out.println(e.getMessage()) ;
}
}
public int getColumnCount()
{
try
{
return resultats.getMetaData().getColumnCount() ;
}
catch (SQLException e)
{
return -1 ;
}
}
public int getRowCount()
{
return rows ;
}
public String getColumnName(int col)
{
try
{
return resultats.getMetaData().getColumnName(col + 1) ;
}
catch (SQLException e)
{
return "-1" ;
}
}
public Object getValueAt(int row, int col)
{
try
{
if (current > row)
{
resultats.beforeFirst() ;
current = -1 ;
}
while (current < row)
{
resultats.next() ;
current++ ;
}
return resultats.getObject(col + 1) ;
}
catch (SQLException e)
{
return "-1" ;
}
}
public Class getColumnClass(int c)
{
return getValueAt(current, c).getClass() ;
}
public boolean isCellEditable(int row, int col)
{
return false ;
}
public void setValueAt(Object value, int row, int col)
{
}
}
}
Configuration: Windows 2000 Firefox 2.0.0.11
Non mais faut pas rêver...
|
Répondre à demoniako
|