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 45 46 47 48
| ....autres declaration avant...
private DataModel data;
private ResultSet rs=null;
public App() {
super(null);
List headerList = new ArrayList();
headerList.add(new ColumnHeader("Symbole","60",false));
headerList.add(new ColumnHeader("Sold","100",true));
columnHeaders = new ListDataModel(headerList);
try{
String url="jdbc:oracle:thin:@192.168.100.34:1521:ORCL";
DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
Connection conn = DriverManager.getConnection(url,"user","pass");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
String mydate_datalist = getEvdat_app();
rs=stmt.executeQuery("SELECT fonction('"+mydate_datalist+"') RES FROM PVMCA WHERE id=4");
}
catch ( SQLException e ) {.....}
List rowList = new ArrayList();
if (rs.next())
{
List colList = new ArrayList();
String tmpSym = rs.getString("sym");
colList.add(tmpSym);
rowList.add(colList);
}
data = new ListDataModel(rowList);
}
public DataModel getData() throws SQLException {
sort(getSort(), isAscending());
return data;
}
void setData(DataModel datamodel)
{
System.out.println("preserved datamodel updated");
} |
Partager