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 32 33 34 35 36 37 38 39 40 41 42 43 44
|
public void base(){
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch (Exception E) {
System.err.println("Pas de pilote !");
}
try {
String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/mabase.mdb";
Connection conn =
DriverManager.getConnection(url, "user", "user");
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(
"SELECT MC645 FROM Feuil1 "+"WHERE CELL_NAME='BK"+"AND Numéro<24");
JFrame q =new JFrame();
q.getContentPane().setLayout(null);
q.setTitle("");
q.setSize(1100,800);
q.show();
while(rs.next()) {
simpleChart1.setData( ?????? );
}
simpleChart1.setYAxisGridVisible(true);
simpleChart1.setBorder(BorderFactory.createEtchedBorder());
simpleChart1.setToolTipText("courbe");
simpleChart1.setXAxisTitleText("heure");
simpleChart1.setYAxisTitleText("valeur");
simpleChart1.setHeaderText("courbe de traffic");
simpleChart1.setChartType(com.klg.jclass.chart.JCChart.BAR);
simpleChart1.setBounds(new Rectangle(10, 10, 1000, 160));
q.getContentPane().add(simpleChart1, null);
rs.close();
// Fermeture
st.close();
conn.close();
}
catch (SQLException E) {
System.err.println(E.getMessage());
} |
Partager