<
%@page contentType="text/html;charset=gb2312"%>
< %@page import="java.sql.*"%>
<%!
String dbcon="sun.jdbc.odbc.JdbcOdbcDriver";
String dburl="jdbc:odbc:db";
Connection con=null;
PreparedStatement pstmt=null;
ResultSet rs=null;
String sql="";
%>
<%
try{
Class.forName(dbcon);
}
catch(Exception e)
{
out.println("数据库连接驱动出错!!!");
}
try{
con=DriverManager.getConnection(dburl);
}
catch(Exception e)
{
out.println("数据库连接出错!!!");
}
try{
sql="SELECT id,name,password,age FROM person";
pstmt=con.prepareStatement(sql);
rs=pstmt.executeQuery();
%>
<table>
<tr><td>ID</td>
<td>姓名</td>
<td>密码</td>
<td>年龄</td>
</tr>
<%
while(rs.next())
{
int id=rs.getInt(1);
String name=rs.getString(2);
String password=rs.getString(3);
int age=rs.getInt(4);
%>
<tr><td><%=id%></td>
<td><%=name%></td>
<td><%=password%></td>
<td><%=age%></td>
</tr>
<%
}
}
catch(Exception e)
{
out.println("数据库操作出错!!!");
}
%>
<%
try
{
rs.close();
pstmt.close();
con.close();
}
catch(Exception e)
{
out.println("关闭数据库出错");
}
%>
< %@page import="java.sql.*"%>
<%!
String dbcon="sun.jdbc.odbc.JdbcOdbcDriver";
String dburl="jdbc:odbc:db";
Connection con=null;
PreparedStatement pstmt=null;
ResultSet rs=null;
String sql="";
%>
<%
try{
Class.forName(dbcon);
}
catch(Exception e)
{
out.println("数据库连接驱动出错!!!");
}
try{
con=DriverManager.getConnection(dburl);
}
catch(Exception e)
{
out.println("数据库连接出错!!!");
}
try{
sql="SELECT id,name,password,age FROM person";
pstmt=con.prepareStatement(sql);
rs=pstmt.executeQuery();
%>
<table>
<tr><td>ID</td>
<td>姓名</td>
<td>密码</td>
<td>年龄</td>
</tr>
<%
while(rs.next())
{
int id=rs.getInt(1);
String name=rs.getString(2);
String password=rs.getString(3);
int age=rs.getInt(4);
%>
<tr><td><%=id%></td>
<td><%=name%></td>
<td><%=password%></td>
<td><%=age%></td>
</tr>
<%
}
}
catch(Exception e)
{
out.println("数据库操作出错!!!");
}
%>
<%
try
{
rs.close();
pstmt.close();
con.close();
}
catch(Exception e)
{
out.println("关闭数据库出错");
}
%>