tomcat5.0下载_创建web项目_lomboz eclipse(15)

%>

<!--下面这些代码将入到servlet中-->

<%

java.sql.Connection conn= null;

java.sql.Statement stmt =null;

java.sql.ResultSet rs=null;

try {

//通过JNDI获取主接口

Context initCtx = new InitialContext();

Context envCtx = (Context) initCtx.lookup("java:comp/env");

DataSource ds = (DataSource)envCtx.lookup("jdbc/mybonusds");

conn=ds.getConnection();

stmt = conn.createStatement();

//执行SQL语句

stmt.execute("select * from奖金");

//取得结果集

rs = stmt.getResultSet();

%>

<table border="1">

<tr>

<td width="60" height="20"><% out.print("编号"); %></td>

<td width="80" height="20"><% out.print("姓名"); %></td>

<td width="200" height="20"><% out.print("发奖名称"); %></td>

<td width="100" height="20"><% out.print("金额"); %></td>

<td width="200" height="20"><% out.print("备注"); %></td>

</tr>

<%while (rs.next()) {

%>

<tr>

<td width="60" height="20"><% out.print(rs.getString("编号")); %></td>

<td width="80" height="20"><% out.print(rs.getString("姓名")); %></td>

<td width="200" height="20"><% out.print(rs.getString("发奖名称")); %></td>

<td width="100" height="20"><% out.print(rs.getString("金额")); %></td>

本文来自电脑杂谈，转载请注明本文网址：
http://www.pc-fly.com/a/jisuanjixue/article-27620-15.html