📄 cloudcustomerlist.java
字号:
import java.io.*;
import java.sql.*;
import java.text.*;
import java.awt.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class CloudCustomerList extends HttpServlet {
Connection db; // The connection to the database
Statement stmt; // Our statement to run queries with
String url, usr, pwd;
public void init(ServletConfig config) throws ServletException {
super.init(config);
url = "jdbc:cloudscape:c:/wrox/database/Wrox4370.db";
// usr = "beg";
//pwd = "java";
// Load the driver
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (Exception ex) {
System.err.println("Problem loading Oracle Driver");
ex.printStackTrace();
}
}
public void doGet(HttpServletRequest request,
HttpServletResponse response) throws ServletException,
IOException {
PrintWriter out;
response.setContentType("text/html");
out = response.getWriter();
out.println("<HTML><HEAD><TITLE>");
out.println("Servlet Example Connecting to the Oracle Database");
out.println("</TITLE></HEAD>");
out.println("<BODY BGCOLOR=\"#FFCCFF\">");
out.println("<P><B>Customer List:</B></P>");
out.println("Connecting to Database URL = " + url + "<br>");
try {
db = DriverManager.getConnection(url); //, usr, pwd);
} catch (Exception ex) {
out.println("Error connecting to database");
ex.printStackTrace();
}
if (db == null) {
out.println("<p>Error getting connection</p>");
} else {
out.println("<p>Connected...</p>");
try {
stmt = db.createStatement();
// Now run tests using JDBC methods
getCustomers(out);
// Finally close the database
out.println("<p>Closing database connection<p>");
stmt.close();
db.close();
} catch (Exception ex) {
out.println("Exception! ");
ex.printStackTrace();
}
}
out.println("</BODY></HTML>");
out.close();
} // doGet
/*
* This gets the customer list:
*/
public void getCustomers(PrintWriter out) throws SQLException {
// Perform a query on the table
String sqlQuery = "";
sqlQuery =
"select ct.CustomerTitleAbbrev || ' ' || c.CustomerFirstName || ' ' || c.CustomerLastName Customer ";
sqlQuery +=
" from Customers c, CustomerTitles ct where c.CustomerTitleID = ct.CustomerTitleID";
ResultSet rs = stmt.executeQuery(sqlQuery);
if (rs != null) {
// Now we run through the result set, printing out the result.
// Note, we must call .next() before attempting to read any results
out
.println("<TABLE BORDER COLS=2 WIDTH=\"45%\" BGCOLOR=\"#FFFFCC\">");
out.println("<TD WIDTH=\"50%\"></TD>");
while (rs.next()) {
String cust = rs.getString("Customer");
out.println("<TR>");
// don't repeat module names
out.println("<TD>" + cust + "</TD>");
}
out.println("</TR>");
}
out.println("</TABLE>");
rs.close();
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -