please tel me where is the doc ?
i don't know how to call data from database in jsp ?
here the answer :
//database ABP
Connection connection = null;
try {
Context initCtxt = new InitialContext();
Context envCtxt = (Context)initCtxt.lookup( "java:comp/env");
DataSource dataSource = (DataSource)envCtxt.lookup( "jdbc/businesspublisherdb");
connection = dataSource.getConnection();
} catch(Exception e) {
ABPLogger.error("connection DB failed "+e.getMessage());
}
Statement statement = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet rs = null;
try{
rs = statement.executeQuery("SELECT * FROM SYS.SYSTABLES WHERE TABLENAME='ASTATS_1'");
} catch (SQLException sqle){
ABPLogger.error("SQLException or Oracle ? :"+sqle.getMessage());
try{
rs = statement.executeQuery("SELECT * FROM ALL_ALL_TABLES WHERE TABLE_NAME='ASTATS_1'");
} catch (SQLException sqle2){
ABPLogger.error("SQLException even for Oracle :"+sqle2.getMessage());
}
}