js| Data | database (reprint please indicate the source)
From:http://aspfans.yeah.net
Java beans that require two programs, JSP files, and database operations
select.jsp
<title>select everything from a database</title>
<body>
<jsp:usebean id= "Select" class= "Databaseselect" scope= "Request" >
</bean>
<% Out.print (Select.connect ()); %>
<% Out.print (Select.select ()); %>
<p>format Results
<%@ 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>
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
(reprint please indicate the source)
From:http://aspfans.yeah.net
