📄 studentedit.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.naming.NamingException;
import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.io.PrintWriter;
import java.util.Vector;
/**
* Created by IntelliJ IDEA.
* User: liubing
* Date: 2008-8-21
* Time: 17:46:02
* To change this template use File | Settings | File Templates.
*/
public class StudentEdit extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response){
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 degreeId = "";
String studentAddress = "";
String memo = "";
//String[] hobbies = null;
Vector hobbies = new Vector();
try {
response.setContentType("text/html;charset=gbk");
out = response.getWriter();
studentId = request.getParameter("editId");
ctx = new InitialContext();
ds = (DataSource)ctx.lookup("java:comp/env/jdbc/mydatasource");
conn = ds.getConnection();
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
//------------------get student ifno
sql = "select * from StudentT where StudentId=" + studentId;
rs = stmt.executeQuery(sql);
rs.next();
studentName = rs.getString("StudentName");
studentAge = rs.getString("StudentAge");
studentSex = rs.getString("StudentSex");
degreeId = rs.getString("degreeId");
studentAddress = rs.getString("StudentAddress");
memo = rs.getString("Memo");
//-------------
sql = "select HobbyId from StudentHobbyT where StudentId=" + studentId;
rs.close();
rs = stmt.executeQuery(sql);
// rs.last();
// hobbies = new String[rs.getRow()];
// rs.beforeFirst();
// int i = 0 ;
// while(rs.next()){
// hobbies[i++] = rs.getString("HobbyId");
// }
while(rs.next()){
hobbies.add(rs.getString("HobbyId"));
}
out.println("<html>");
out.println(" <head>");
out.println(" <script language='javascript' src='/stu/js/check.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(" <br>");
out.println(" <!--主表-->");
out.println(" <form name='addOneForm' action='/stu/StudentEdit' method='post'>");
out.println(" <table>");
out.println(" <tr>");
out.println(" <td>学号:</td>");
out.println(" <td><input type='text' name='studentId' value='" + studentId + "' readonly></td>");
out.println(" </tr>");
out.println(" <tr>");
out.println(" <td>姓名:</td>");
out.println(" <td><input type='text' name='studentName' value='" + studentName + "'></td>");
out.println(" </tr>");
out.println(" <tr>");
out.println(" <td>年龄:</td>");
out.println(" <td><input type='text' name='studentAge' maxlength='2' value='" + studentAge + "'></td>");
out.println(" </tr>");
out.println(" <tr>");
out.println(" <td>性别:</td>");
out.println(" <td>");
out.println(" <input type='radio' name='studentSex' value='1' " + ("1".equals(studentSex)?"checked":"") + ">男");
out.println(" <input type='radio' name='studentSex' value='0' " + ("0".equals(studentSex)?"checked":"") +">女");
out.println(" </td>");
out.println(" </tr>");
out.println(" <tr>");
out.println(" <td>学历:</td>");
out.println(" <td>");
out.println(" <select name='degreeId'>");
out.println(" <option>--------</option>");
out.println(" <option value='1' " + ("1".equals(degreeId)?"selected":"") + ">高中</option>");
out.println(" <option value='2' " + ("2".equals(degreeId)?"selected":"") + ">专科</option>");
out.println(" <option value='3' " + ("3".equals(degreeId)?"selected":"") + ">本科</option>");
out.println(" </select>");
out.println(" </td>");
out.println(" </tr>");
out.println(" <tr>");
out.println(" <td>家庭住址:</td>");
out.println(" <td><input type='text' name='studentAddress' maxlength='15' size='30' value='" + studentAddress + "'></td>");
out.println(" </tr>");
out.println(" <tr>");
out.println(" <td rowspan='2'>爱好:</td>");
out.println(" <td>");
out.println(" <input type='checkbox' name='hobby' value='1' " + (hobbies.contains("1")?"checked":"") + ">读书");
out.println(" <input type='checkbox' name='hobby' value='2' " + (hobbies.contains("2")?"checked":"") + ">运动");
out.println(" <input type='checkbox' name='hobby' value='3' " + (hobbies.contains("3")?"checked":"") + ">音乐");
out.println(" </td>");
out.println(" </tr>");
out.println(" <tr>");
out.println(" <td>");
out.println(" <input type='checkbox' name='hobby' value='4' " + (hobbies.contains("4")?"checked":"") + ">电影");
out.println(" <input type='checkbox' name='hobby' value='5' " + (hobbies.contains("5")?"checked":"") + ">旅游");
out.println(" <input type='checkbox' name='hobby' value='6' " + (hobbies.contains("6")?"checked":"") + ">购物");
out.println(" </td>");
out.println(" </tr>");
out.println(" <tr>");
out.println(" <td>备注:</td>");
out.println(" <td><textarea name='meno' rows='8' cols='30'>" + memo + "</textarea></td>");
out.println(" </tr>");
out.println(" <tr>");
out.println(" <td colspan='2' align='center'>");
out.println(" <input type='button' value='保存' onclick='submitFunc()'>");
out.println(" <input type='reset' name='reset' value='重置'>");
out.println(" </td>");
out.println(" </tr>");
out.println(" </table>");
out.println(" </form>");
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 (Exception e){}
}
}
public void doPost(HttpServletRequest request,HttpServletResponse response){
PrintWriter out = null;
Context ctx = null;
DataSource ds = null;
Connection conn = null;
Statement stmt = null;
StringBuffer sqlSb = new StringBuffer();
String studentId = "";
String studentName = "";
String studentAge = "";
String studentSex = "";
String degreeId = "";
String studentAddress = "";
String memo = "";
String[] hobbies = null;
try {
response.setContentType("text/html;charset=gbk");
out = response.getWriter();
request.setCharacterEncoding("gbk");
studentId = request.getParameter("studentId");
studentName = request.getParameter("studentName");
studentAge = request.getParameter("studentAge");
studentSex = request.getParameter("studentSex");
degreeId = request.getParameter("degreeId");
studentAddress = request.getParameter("studentAddress");
memo = request.getParameter("memo");
hobbies = request.getParameterValues("hobby");
ctx = new InitialContext();
ds = (DataSource)ctx.lookup("java:comp/env/jdbc/mydatasource");
conn = ds.getConnection();
stmt = conn.createStatement();
conn.setAutoCommit(false);
sqlSb.append( "update StudentT" +
" set " +
" StudentName='" + studentName + "'," +
" StudentAge=" + studentAge + "," +
" StudentSex=" + studentSex + "," +
" DegreeId=" + degreeId + "," +
" StudentAddress='" + studentAddress + "'," +
" Memo='" + memo + "'" +
" where StudentId=" + studentId);
sqlSb.append(" delete from StudentHobbyT where StudentId=" + studentId);
for(int i = 0 , n = hobbies.length; i < n ; i++){
sqlSb.append(" insert into StudentHobbyT (StudentId,HobbyId) values (" + studentId + "," + hobbies[i] + ")");
}
stmt.executeUpdate(sqlSb.toString());
conn.commit();
out.println("<script language='javascript'>");
out.println(" alert(\"修改成功！\"); ");
out.println(" window.location = \"/stu/StudentList\"; ");
out.println("</script>");
} catch (Exception e) {
out.println("<script language='javascript'>");
out.println(" alert(\"修改失败！\"); ");
out.println(" window.history.back(); ");
out.println("</script>");
try {
conn.rollback();
} catch (SQLException e1) {
e1.printStackTrace();
}
e.printStackTrace();
} finally{
try{
if(stmt != null) stmt.close();
if(conn != null) conn.close();
} catch (Exception e){}
}
}
// private boolean hasHobby(String[] hobbies,String hobbyId){
//
// for(int i = 0 , n = hobbies.length ; i < n ; i++ ){
// if(hobbyId.equals(hobbies[i])){
// return true;
// }
// }
//
// return false;
//
// }
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -