?? studentlist.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.io.IOException;
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-19
* Time: 18:58:34
* To change this template use File | Settings | File Templates.
*/
public class StudentList extends HttpServlet {
public void doGet(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 = "";
try {
out = response.getWriter();
//數據連接操作
ctx = new InitialContext();
ds = (DataSource)ctx.lookup("java:comp/env/jdbc/mydatasource");
conn = ds.getConnection();
stmt = conn.createStatement();
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";
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(" <form name='SLForm' action='/stu/StudentDel' method='post'>");
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(" <br>");
out.println(" <!--添加與刪除表-->");
out.println(" <tr>");
out.println(" <td align='right'>");
out.println(" <table border='0' cellspacing='0'>");
out.println(" <tr>");
out.println(" <td colspan='8'>");
out.println(" <a href='/stu/html/addnew.html'>添加</a>");
out.println(" <a href='listtable.html' onclick='del()'>刪除</a>");
out.println(" </td>");
out.println(" </tr>");
out.println(" </table>");
out.println(" </td>");
out.println(" </tr>");
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 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(" <td align='center'> </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'><input type='checkbox' name='delId' value='" + studentId + "'></td>");
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(" <td align='center'><a href='/stu/StudentEdit?editId=" + studentId + "'>修改</a></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(" </form>");
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 + -