📄 studentquery.java
字号:
package cn.jl.student.servlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* Created by IntelliJ IDEA.
* User: liubing
* Date: 2008-8-21
* Time: 19:19:44
* To change this template use File | Settings | File Templates.
*/
public class StudentQuery extends HttpServlet {
public void doPost(HttpServletRequest request , HttpServletResponse response){
response.setContentType("text/html;charset=gbk");
PrintWriter out = null;
Context ctx = null;
DataSource ds = null;
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String sql = "";
String studentId = "";
String studentName = "";
String studentAge = "";
String studentSex = "";
String degreeName = "";
String studentAddress = "";
String fieldName = "";
String operator = "";
String fieldValue = "";
try {
out = response.getWriter();
//数据连接操作
ctx = new InitialContext();
ds = (DataSource)ctx.lookup("java:comp/env/jdbc/mydatasource");
conn = ds.getConnection();
stmt = conn.createStatement();
request.setCharacterEncoding("gbk");
fieldName = request.getParameter("fieldName");
operator = request.getParameter("operator");
fieldValue = request.getParameter("fieldValue");
sql = " select StudentId,StudentName,StudentAge,DegreeName," +
" case StudentSex" +
" when 1 then '男'" +
" else '女'" +
" end as StudentSex,StudentAddress" +
" from StudentT s,DegreeT d" +
" where s.DegreeId = d.DegreeId";
if("StudentId".equals(fieldName) && !"like".equals(operator)){
sql += " and " + fieldName + " " + operator + " " + fieldValue;
}
else if("StudentName".equals(fieldName) && !"like".equals(operator)){
sql += " and " + fieldName + " " + operator + " '" + fieldValue + "' ";
}
else{
sql += " and " + fieldName + " " + operator + " '%" + fieldValue + "%' ";
}
//System.out.println(sql);
rs = stmt.executeQuery(sql);
out.println("<html>");
out.println(" <head>");
out.println(" <script language='javascript' src='dell.js'>");
out.println(" </script>");
out.println(" </head>");
out.println(" <body>");
out.println(" <fieldset>");
out.println(" <legend><font color='black'>学生列表</font></legend>");
out.println(" <center>");
out.println(" <!--外框表开始-->");
out.println(" <table border='0' width='86%'>");
out.println(" <!--与上边界距离-->");
out.println(" <!--主表开始-->");
out.println(" <tr>");
out.println(" <td>");
out.println(" <table bgcolor='black' cellspacing='1' cellpadding='8' width='100%'>");
out.println(" <tr bgcolor='white'>");
out.println(" <td align='center'> 学号 </td>");
out.println(" <td width='80'>姓名</td>");
out.println(" <td align='center'>年龄</td>");
out.println(" <td align='center'>学历</td>");
out.println(" <td align='center'>性别</td>");
out.println(" <td width='180'>");
out.println(" 地址");
out.println(" </td>");
out.println(" </tr>");
while(rs.next()){
studentId = rs.getString("StudentId");
studentName = rs.getString("StudentName");
studentAge = rs.getString("StudentAge");
degreeName = rs.getString("degreeName");
studentSex = rs.getString("StudentSex");
studentAddress = rs.getString("StudentAddress");
out.println(" <tr bgcolor='white'>");
out.println(" <td align='center'v>" + studentId + "</td>");
out.println(" <td>" + studentName + "</td>");
out.println(" <td align='center'>" + studentAge + "</td>");
out.println(" <td align='center'>" + degreeName + "</td>");
out.println(" <td align='center'>" + studentSex + "</td>");
out.println(" <td>" + studentAddress + "</td>");
out.println(" </tr>");
}
out.println(" </table>");
out.println(" <!--主表结束-->");
out.println(" </td>");
out.println(" </tr>");
out.println(" </table>");
out.println(" <!--外框表结束-->");
out.println(" <!--与下边界距离-->");
out.println(" <br>");
out.println(" <center>");
out.println(" </fieldset>");
out.println(" </body>");
out.println("</html>");
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if(rs != null) rs.close();
if(stmt != null) stmt.close();
if(conn != null) conn.close();
} catch (SQLException e) {
e.printStackTrace(); //To change body of catch statement use File | Settings | File Templates.
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -