?? jdbcinitservlet.java
字號:
package ServletApi;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class JDBCInitServlet extends HttpServlet {
protected String mydriver;
protected String myurl;
protected String myuserID;
protected String mypassword;
protected Connection conn = null;
public void doGet(HttpServletRequest req, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("TEXT/HTML;charSet=gb2312");
response.setLocale(request.getLocale());
PrintWriter out = res.getWriter();
out.println("<HTML>");
out.println("<TITLE>JDBC Init Connection</TITLE>");
out.println("<BODY>");
try { executeSQL(out);
}
catch (SQLException se) { se.printStackTrace();
}
out.println("</BODY></HTML>");
out.close();
}
public void executeSQL(PrintWriter out) throws SQLException{
Statement stmt = conn.createStatement();
String sql = "SELECT * FROM DEPARTMENT";
stmt.executeQuery(sql);
ResultSet rs = stmt.getResultSet();
int count = 1;
while (rs.next()) {
out.println("<B>" + rs.getString("DEPTNAME") + "</B><BR><BLOCKQUOTE>");
String sql2 = "SELECT * FROM EMPLOYEE WHERE WORKDEPT = '" + rs.getString("DEPTNO") + "'";
Statement stmt2 = conn.createStatement();
stmt2.executeQuery(sql2);
ResultSet rs2 = stmt2.getResultSet();
while(rs2.next()) {
out.println(rs2.getString("FIRSTNAME") + " " + rs2.getString("LASTNAME") + "<br>");
}
out.println("</BLOCKQUOTE>");
}
}
public void init(ServletConfig config) throws ServletException {
super.init(config);
mydriver = config.getInitParameter("driver");
myurl = config.getInitParameter("URL");
myuserID = config.getInitParameter("userID");
mypassword = config.getInitParameter("password");
try {
//動態加載驅動
Class.forName(mydriver).newInstance();
conn = DriverManager.getConnection(myurl,myuserID,mypassword);
System.out.println("連接成功..");
}
catch (SQLException se) { System.out.println(se); }
catch (Exception e) { e.printStackTrace(); }
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -