当前页面: 开发资料首页 → JSP 专题 → jsp+beans实现读取数据库的例子

jsp+beans实现读取数据库的例子

摘要: jsp+beans实现读取数据库的例子

需要用到两个程序，jsp文件和数据库操作的java bean

Select.jsp

<head>
Select everything from a database
</head>
<body>

<% out.print(select.connect()); %>

<% out.print(select.select()); %>

Format results

<%@ page import="java.util.Vector" %>
<% Vector aResult = select.getResult(); %>

</body>

DataBaseSelect.java
import java.sql.*;
import java.util.Vector;
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

↑返回目录
前一篇: Jsp中调用Oracle存储过程的小例子
后一篇: 一个连接池的例子（二）