jsp mysql select_JSP select标签数据库绑定

ResultSet results = null;

DataSource ds = null;

Connection connection = null;

PreparedStatement stmt = null;

int num_of_rows = 0;

ArrayList arraylist=null; Iterator iterator=null; %>

try{

Context context = new InitialContext();

if ( context == null ) {

throw new RuntimeException("JNDI Context could not be found.");

}

ds = (DataSource)context.lookup("java:comp/env/jdbc/leagueDB");

if ( ds == null ) {

throw new RuntimeException("DataSource could not be found.");

}

connection = ds.getConnection();

stmt = connection.prepareStatement(SELECT_ALLIANCE_STMT);

results=stmt.executeQuery();

}catch (SQLException se) {

throw new RuntimeException("A database error occured. " + se.getMessage()+"....");

// Handle any JNDI errors

} catch (NamingException ne) {

throw new RuntimeException("A JNDI error occured. " + ne.getMessage());

} finally {

if ( stmt != null ) {

try { stmt.close(); }

catch (SQLException se) { se.printStackTrace(System.err); }

}

if ( connection != null ) {

try { connection.close(); }

catch (Exception e) { e.printStackTrace(System.err); }

}

}

}

%>

select标签处:

{

while (results.next()){

arraylist.add(results.getString("allianceName"));

iterator=arraylist.iterator();

%>

} catch (SQLException e){

}

%>

这里是我写的代码,在select处小弟尝试N种方法都不可以,只有请教大虾们了,无论是用还是其他的方法,只要成功就可以. 把我的代码修改成功才给分.

问题我已经解决了,但还是希望大虾用标签来做,或者用useBean吧,说的好的追加30分!呵呵

展开