📄 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 + -