package com.service;
/** 
 * 負責學生信息的所有數據庫操作，增刪改查
 */
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
 
import com.model.stuInfo;
 
public class stuInfoService {
 private Connection conn;
 private PreparedStatement pstmt;//執行sql語句
 
 public stuInfoService() {
  conn = new com.conn.conn().getCon();
 }
 
 public boolean addStu(stuInfo stu) {//插入學生數據
  try {
   pstmt = conn.prepareStatement("insert into studentinfo"
     + "(Nickname,truename,sex,birthday,major,course,interest,remark) "
     + "values(?,?,?,?,?,?,?,?)");
   pstmt.setString(1, stu.getNickname());
   pstmt.setString(2, stu.getTruename());
   pstmt.setByte(3, stu.getSex());
   pstmt.setString(4, stu.getbirthday());
   pstmt.setString(5, stu.getmajor());
   pstmt.setString(6, stu.getcourses());
   pstmt.setString(7, stu.getinterests());
   pstmt.setString(8, stu.getremark());
 
   pstmt.executeUpdate();
   return true;
  } catch (SQLException e) {
   // TODO Auto-generated catch block
 
   e.printStackTrace();
   return false;
  }
 
 }
//查詢所喲學生信息
 public ListstuInfo> queryAllStu() {//查詢學生數據
  ListstuInfo> stus = new ArrayListstuInfo>();//每一個學生的信息作為list集合的每一個元素存儲在list集合中
  try {
   pstmt = conn.prepareStatement("select * from studentinfo");
   ResultSet rs = pstmt.executeQuery();
   while (rs.next()) {
    stuInfo stu = new stuInfo();
    stu.setId(rs.getInt(1));
    stu.setNickname(rs.getString(2));
    stu.setTruename(rs.getString(3));
    stu.setSex(rs.getByte(4));
    if (rs.getDate(5) != null)
     stu.setbirthday(rs.getDate(5).toString());
    stu.setmajor(rs.getString(6));
    if (rs.getString(7) != null)
     stu.setcourse(rs.getString(7).split(""));
    if (rs.getString(8) != null)
     stu.setinterest(rs.getString(8).split(""));
    stu.setremark(rs.getString(9));
    stus.add(stu);
 
   }
   return stus;
 
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
   return null;
  }
 
 }
//查詢單個學生信息
 public stuInfo queryStubyID(int id) {
  // List stus = new ArrayList();
  try {
   pstmt = conn
     .prepareStatement("select * from studentinfo where id=?");
   pstmt.setInt(1, id);
   ResultSet rs = pstmt.executeQuery();
   if (rs.next()) {
    stuInfo stu = new stuInfo();
    stu.setId(rs.getInt(1));
    stu.setNickname(rs.getString(2));
    stu.setTruename(rs.getString(3));
    stu.setSex(rs.getByte(4));
    if (rs.getDate(5) != null)
     stu.setbirthday(rs.getDate(5).toString());
    stu.setmajor(rs.getString(6));
    if (rs.getString(7) != null)
     stu.setcourse(rs.getString(7).split(""));
    if (rs.getString(8) != null)
     stu.setinterest(rs.getString(8).split(""));
    stu.setremark(rs.getString(9));
    // stus.add(stu);
    return stu;
 
   }
   return null;
 
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
   return null;
  }
 
 }
  //更新學生信息
 public boolean updateStu(stuInfo stu) {
 
  try {
   pstmt = conn
     .prepareStatement("update studentinfo set Nickname=? , truename=? , sex=? ,birthday=? ,"
       + " major=? ,course=? , interest=?, remark=? where id=?");
   pstmt.setString(1, stu.getNickname());
   pstmt.setString(2, stu.getTruename());
   pstmt.setByte(3, stu.getSex());
   pstmt.setString(4, stu.getbirthday());
   pstmt.setString(5, stu.getmajor());
   pstmt.setString(6, stu.getcourses());
   pstmt.setString(7, stu.getinterests());
   pstmt.setString(8, stu.getremark());
   pstmt.setInt(9, stu.getId());
   pstmt.executeUpdate();
   return true;
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
   return false;
  }
 }
  //刪除學生信息
 public Boolean deleteStu(int id) {
 
  try {
   pstmt = conn.prepareStatement("delete from studentinfo where id=?");
   pstmt.setInt(1, id);
   pstmt.executeUpdate();
   return true;
  } catch (Exception e) {
   e.getStackTrace();
   return false;
  }
 
 }
}

package com.servlet;
 
import java.io.IOException;
import java.io.PrintWriter;
import java.util.Date;
 
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
 
import com.model.stuInfo;
import com.service.stuInfoService;
 
public class inputStuInfoServlet extends HttpServlet {
 
 /**
  * Constructor of the object.
  */
 public inputStuInfoServlet() {
  super();
 }
 
 /**
  * Destruction of the servlet. br>
  */
 public void destroy() {
  super.destroy(); // Just puts "destroy" string in log
  // Put your code here
 }
 
 /**
  * The doGet method of the servlet. br>
  *
  * This method is called when a form has its tag value method equals to get.
  * 
  * @param request the request send by the client to the server
  * @param response the response send by the server to the client
  * @throws ServletException if an error occurred
  * @throws IOException if an error occurred
  */
 public void doGet(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {
 
  doPost(request, response);
 }
 
 /**
  * The doPost method of the servlet. br>
  *
  * This method is called when a form has its tag value method equals to post.
  * 
  * @param request the request send by the client to the server
  * @param response the response send by the server to the client
  * @throws ServletException if an error occurred
  * @throws IOException if an error occurred
  */
 public void doPost(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {
  request.setCharacterEncoding("utf-8");//get到表單所有的控件的值
  String nickname=request.getParameter("nickname");
  String truename=request.getParameter("truename");
  byte sex=Byte.parseByte(request.getParameter("sex"));
  String birthday=request.getParameter("birthday");
  String major=request.getParameter("major");
  System.out.println(major);
  //String course=request.getParameter("course");
  String courses[]=request.getParameterValues("course");
  String interests[]=request.getParameterValues("interest");
  String remark=request.getParameter("remark");
  //放到Javabean中暫時保存
  stuInfo stu=new stuInfo();
  stu.setNickname(nickname);
  stu.setTruename(truename);
   
  stu.setbirthday(birthday);
  if(birthday.equals(""))
   stu.setbirthday(null);
  if(courses!=null)
  stu.setcourse(courses);
  if(interests!=null)
  stu.setinterest(interests);
  stu.setremark(remark);
  stu.setmajor(major);
  stu.setSex(sex);
  if(new stuInfoService().addStu(stu))//插入學生數據的方法
   response.sendRedirect("../inputStuInfo_success.jsp");
  else
   response.sendRedirect("../inputStuInfo.jsp");//插入數據庫失敗則返回初始輸入頁面
   
 }
 
 /**
  * Initialization of the servlet. br>
  *
  * @throws ServletException if an error occurs
  */
 public void init() throws ServletException {
  // Put your code here
 }
 
}

package com.model;
//Javabean相當于是一個中間件，用于類與類之間，各層之間的中轉數據的一個中轉站
public class stuInfo {
 private int id;
 private String nickname;
 private String truename;
 private byte sex;
 private String birthday;
 private String major;
 private String[] course = { "" };
 private String courses = "";
 private String[] interest = { "" };
 private String interests = "";
 private String remark;
 public int getId() {
  return id;
 }
 public void setId(int id) {
  this.id = id;
 }
 public String getNickname() {
  return nickname;
 }
 public void setNickname(String nickname) {
  this.nickname = nickname;
 }
 public String getTruename() {
  return truename;
 }
 public void setTruename(String truename) {
  this.truename = truename;
 }
 public byte getSex() {
  return sex;
 }
 public void setSex(byte sex) {
  this.sex = sex;
 }
 public String getbirthday() {
  return birthday;
 }
 public void setbirthday(String birthday) {
  this.birthday = birthday;
 }
 public String getmajor() {
  return major;
 }
 public void setmajor(String major) {
  this.major = major;
 }
 public String[] getcourse() {
  return course;
 }
 public void setcourse(String[] course) {
  this.course = course;
 }
 public String getcourses() { 
  if(course!=null)
  {courses="";
   for(int i=0;icourse.length;i++)
   courses+=course[i]+"";
  }
  courses=courses.substring(0,courses.length()-1);
  return courses;
 }
 public void setcourses(String courses) {
  this.courses = courses;
 }
 public String[] getinterest() {
  return interest;
 }
 public void setinterest(String[] interest) {
  this.interest = interest;
 }
 public String getinterests() {
  if(interest!=null)
  {interests="";
   for(int i=0;iinterest.length;i++)
   interests+=interest[i]+"";
  }
  interests=interests.substring(0,interests.length()-1);
  return interests;
 }
 public void setinterests(String interests) {
  this.interests = interests;
 }
 public String getremark() {
  return remark;
 }
 public void setremark(String remark) {
  this.remark = remark;
 }
}

package com.conn;
 
import java.sql.Connection;
import java.sql.DriverManager;
 
public class conn {
 
 public Connection getCon() {
  try {
   Class.forName("com.mysql.jdbc.Driver");
   String url = "jdbc:mysql://localhost/Stu_info_System?useUnicode=truecharacterEncoding=utf-8";
   String user = "root";
   String password = "root";
   Connection conn = DriverManager.getConnection(url, user, password);
   System.out.println(conn.getMetaData().getURL());
 
   return conn;
  } catch (Exception e) {
   e.printStackTrace();
   return null;
  }
 
 }
 
}