|
![]() |
名片设计 CorelDRAW Illustrator AuotoCAD Painter 其他软件 Photoshop Fireworks Flash |
|
jsp+beans实现读取数据库的例子 Select.jsp <html> <head> <title>Select everything from a database</title> </head> <body> <jsp:useBean id="select" class="DataBaseSelect" scope="request"> </bean> <% out.print(select.connect()); %> <br> <% out.print(select.select()); %> <p>Format results <br> <%@ page import="java.util.Vector" %> <% Vector aResult = select.getResult(); %> <table> <% for (int i=0; i < aResult.size(); i++) { %> <tr> <td> <% out.print(aResult.elementAt(i)); %> </td> </tr> <% } %> </table> </body> </html> DataBaseSelect.java import java.sql.*; import java.util.Vector; /** * DataBaseSelect.java * Written by Morgan Catlin * August 19, 1999 * * Variables: * Vector result = where I put the results of a select query * * Methods: * Vector getResult() = returns result * void setResult() = sets result * String connect() = connects to a database * String select() = selects information from a database */ public class DataBaseSelect { private Vector result; public DataBaseSelect() { result = new Vector(); } // constructor DataBaseSelect public String connect() { try { Class.forName("a jdbc driver").newInstance(); return "Driver Loaded!"; } catch (Exception E) { return "Unable to load driver."; } } public String select() { try { Connection C = DriverManager.getConnection("database connection string"); Statement Stmt = C.createStatement(); ResultSet myResult = Stmt.executeQuery("SELECT acolumn from atable"); while (myResult.next()) { result.addElement(myResult.getString(1)); } // Clean up myResult.close(); Stmt.close(); C.close(); return "Connection Success!"; } catch (SQLException E) { return "SQLException: " + E.getMessage(); } } /** * Accessor for result **/ public Vector getResult() { return result; } /** * Mutator for result **/ public void setResult(Vector avector) { result = avector; } } // class DataBaseSelect 返回类别: 教程 上一教程: JAVA访问数据库的速度瓶颈问题的分析及解决 下一教程: 在JSP中使用JAVAMAIL(二) 您可以阅读与"JSP+BEANS实现读取数据库的例子"相关的教程: · 和同事写了一个下午的递归读取数据库的javabean · 用JSP从数据库中读取图片并显示在网页上 · 如何用JSP读取MYSQL数据库 · 一个JAVABEAN轻松实现对数据库的各种操作 · 用JSP如何读取ACCESS数据库 |
![]() ![]() |
快精灵印艺坊 版权所有 |
首页![]() ![]() ![]() ![]() ![]() ![]() ![]() |