Linux-JSP-JDBC-MySQL测试 - Select
关键词：Java, JSP
<%--作者：何志强[hhzqq@21cn.com]日期：2000-08-04功能：Linux-JSP-JDBC-MySQL测试 - Select--%><%@ page contentType="text/html;charset=8859_1" %><%//声明java.sql.Connection sqlConn;//数据库连接对象java.sql.Statement sqlStmt;//语句对象java.sql.ResultSet sqlRst;//结果集对象//登记JDBC驱动程序Class.forName("org.gjt.mm.mysql.Driver").newInstance();//连接数据库sqlConn = java.sql.DriverManager.getConnection("jdbc:mysql://localhost/test","test","test");//创建语句对象sqlStmt = sqlConn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);//执行SQL语句sqlRst = sqlStmt.executeQuery("select name,age from test");%><html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><title>Linux-JSP-JDBC-MySQL测试 - Select</title></head><body><table border="1" cellspacing="0" cellpadding="0" align="center"><tr> <th>姓名</th> <th>年龄</th></tr><%while(sqlRst.next()){%><tr> <td><%=sqlRst.getString(1)%></td> <td><%=sqlRst.getLong(2)%></td></tr><%}%></table></body></html><%//关闭结果集对象sqlRst.close();//关闭语句对象sqlStmt.close();//关闭数据库连接sqlConn.close();%>
