?? servletjdbc.java
字號:
package servletJDBC;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.PrintWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.sql.DataSource;
import javax.naming.InitialContext;
import javax.naming.NamingException;
public class servletJDBC extends HttpServlet {
private static final String CONTENT_TYPE = "text/html; charset=GB2312";
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
try {
InitialContext ic=new InitialContext();
DataSource ds=(DataSource)ic.lookup("jdbc/DBConnCoreDS");
Connection conn=ds.getConnection();
Statement st=conn.createStatement();
ResultSet rs=st.executeQuery("select * from emp");
out.println("<html>");
out.println("<head><title>servletJDBC</title></head>");
out.println("<body>");
out.println("<center>雇員信息一覽表</center>");
out.println("<center><table width=85% border=1>");
out.println("<tr>");
out.println("<td>代碼</td>");
out.println("<td>姓名</td>");
out.println("<td>部門編號</td>");
out.println("<td>年齡</td>");
out.println("<td>職位</td>");
out.println("<td>薪水</td>");
out.println("</tr>");
while(rs.next()) {
out.println("<tr>");
out.println("<td>"+rs.getString("emp_id")+"</td>");
out.println("<td>"+rs.getString("emp_name")+"</td>");
out.println("<td>"+rs.getString("dept_id")+"</td>");
out.println("<td>"+rs.getString("emp_age")+"</td>");
out.println("<td>"+rs.getString("emp_job")+"</td>");
out.println("<td>"+rs.getString("emp_salary")+"</td>");
out.println("</tr>");
}
out.println("</table>");
out.println("</center>");
rs.close();
st.close();
conn.close();
}
catch(NamingException ee) {
out.println("數據庫連接失敗");
}
catch(SQLException e) {
out.println("數據庫操作失敗");
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -