package it.com.action;
import java.io.IOException;
import java.io.PrintWriter;
import java.io.UnsupportedEncodingException;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Random;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import org.apache.poi.hssf.extractor.ExcelExtractor;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import it.com.bean.Knowledge;
import it.com.bean.Questions;
import it.com.bean.Subject;
import it.com.bean.Users;
import it.com.service.TeacherService;
import it.com.service.UsersService;
import it.com.service.impl.ImpTeacherService;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import net.sf.json.JSONArray;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;
@Controller
public class UsersAction {
@Resource
UsersService us;
public UsersService getUs() {
return us;
}
public void setUs(UsersService us) {
this.us = us;
}
@Resource
TeacherService ts;
public TeacherService getTs() {
return ts;
}
public void setTs(TeacherService ts) {
this.ts = ts;
}
@RequestMapping("index.action")
//跳转到学生、教师登陆页面
public ModelAndView index(){
return new ModelAndView("stu/login.jsp");
}
@RequestMapping("welcome.action")
//跳转到管理员欢迎页面
public ModelAndView welcome(){
return new ModelAndView("admin/welcome.jsp");
}
@RequestMapping("forgetpwd.action")
//跳转到管理员欢迎页面
public ModelAndView forgetpwd(HttpSession session){
int m=0;
List<Users> list=us.findAdmin();
System.out.println(list);
session.setAttribute("usernameA", list);
session.setAttribute("m", m);
return new ModelAndView ("admin/forgetpwd.jsp");
}
@RequestMapping("tecwelcome.action")
//跳转到教师欢迎页面
public ModelAndView tecwelcome(){
return new ModelAndView("teacher/welcome.jsp");
}
@RequestMapping("nav.action")
//跳转到管理员nav页面
public ModelAndView nav(){
return new ModelAndView("admin/nav.jsp");
}
@RequestMapping("tecnav.action")
//跳转到教师nav页面
public ModelAndView tecnav(){
return new ModelAndView("teacher/nav.jsp");
}
@RequestMapping("table.action")
//跳转到管理员table页面
public ModelAndView table(){
return new ModelAndView("admin/table.jsp");
}
@RequestMapping("form.action")
//跳转到管理员form页面
public ModelAndView form(){
return new ModelAndView("admin/form.jsp");
}
@RequestMapping("tecform.action")
//跳转到教师form页面
public ModelAndView tecform(){
return new ModelAndView("teacher/form.jsp");
}
@RequestMapping("logintest.action")
//管理员登陆验证
public ModelAndView logintest(HttpServletRequest request,HttpSession session){
String uri="";
String username=request.getParameter("username");
String userpwd=request.getParameter("userpwd");
String usertype=request.getParameter("usertype");
if(usertype.equals("administrator")){
int n=us.login(username, userpwd,0);
if(n==1){
uri="admin/success.jsp";
}else{
uri="admin/login.jsp";
session.setAttribute("n", n);
}
Map map=new HashMap();
map.put("username", username);
map.put("userpwd",userpwd);
session.setAttribute("user", map);
}else{
uri="admin/login.jsp";
}
return new ModelAndView(uri);
}
//教师、学生登陆验证
@RequestMapping(value="login.action")
public ModelAndView login(String username,String userpwd, int numyzm,HttpServletRequest res,HttpSession session){
String uri="";
String usertype=res.getParameter("usertype");
System.out.println("*--------"+usertype);
System.out.println("*--------"+username);
//System.out.println("---usertype---:"+usertype);
if(usertype.equals("student")){
int nn=us.login(username, userpwd,2);
//System.out.println("输出nn的值--------"+nn);
int result=Integer.parseInt(session.getAttribute("result").toString());
//System.out.println(username+"===="+userpwd+"===="+numyzm);
if(numyzm==result&&nn==1){
//System.out.println("我是学生--------"+nn);
session.setAttribute("user", username);
uri="stu/main.jsp";
}else{
uri="stu/login.jsp";
}
}else if(usertype.equals("teacher")){
int nn=us.login(username, userpwd,1);
//System.out.println("输出nn的值--------"+nn);
int result=Integer.parseInt(session.getAttribute("result").toString());
//System.out.println(username+"===="+userpwd+"===="+numyzm);
if(numyzm==result&&nn==1){
//System.out.println("我是老师--------"+nn);
uri="tea.action";
}else{
uri="stu/login.jsp";
}
}else{
uri="stu/login.jsp";
}
return new ModelAndView(uri);
}
//通过页面获取的usertype查询学生或者教师的所有信息
@RequestMapping("selectUser.action")
public ModelAndView selectUser(int usertype,HttpSession session){
List<Users> list=us.findUserByType(usertype);
List <Subject>list1=ts.findSubject1();
int m1=list1.size();
session.setAttribute("m1", m1);
session.setAttribute("listsub", list1);
session.setAttribute("listusers", list);
session.setAttribute("usertype", usertype);
return new ModelAndView("admin/table.jsp");//跳转到查询的用户所有信息的界面
}
//Users 操作
//插入学生或者教师的信息
@RequestMapping("insertUser.action")
public ModelAndView insertUser(String username,String userpwd,int subjectid,int usertype,HttpSession session){
int n=us.insertUserByIdType(username, userpwd, subjectid, usertype);
return new ModelAndView("admin/up.jsp");//跳转到插入后的用户界面
}
//删除学生或者教师的信息
@RequestMapping("deleteUser.action")
public ModelAndView deleteUser(int userid){
int n=us.deleUserById(userid);
return new ModelAndView("admin/up.jsp");//更新用户信息后的界面
}
//更新查询
@RequestMapping("UpdateSelectUsersById.action")
public ModelAndView UpdateSelectUsersById(int userid,HttpSession session){
List<Users>list=us.UpdateSelectUsersById(userid);
session.setAttribute("listuserbyid", list);
return new ModelAndView("admin/update.jsp");//跳转到插入后的用户界面
}
//更新
@RequestMapping("UpdateUserById.action")
public ModelAndView UpdateUserById(String username,String userpwd,int subjectid,int usertype,int userid,HttpSession session){
int n=us.UpdateUserById(username, userpwd, subjectid, usertype, userid);
session.setAttribute("usertype", usertype);
return new ModelAndView("admin/up.jsp");//跳转到插入后的用户界面
}
//课程操作
//查询所有课程
@RequestMapping("allsubject.action")
public ModelAndView selectsubject(HttpSession session){
List <Subject> list=ts.findSubject1();
session.setAttribute("listless", list);
return new ModelAndView("admin/less.jsp");//跳转到插入后的用户界面
}
//插入
@RequestMapping("insertSub.action")
public ModelAndView insertSub(String subjecttype){
int n=us.insSubjectById(subjecttype);
return new ModelAndView("admin/su.jsp");//跳转到插入后的用户界面
}
//删除
@RequestMapping("deleteSub.action")
public ModelAndView deleteSub(HttpServletRequest request) throws UnsupportedEncodingException{
String subjecttype=new String(request.getParameter("subjecttype").getBytes("ISO-8859-1"),"utf-8");
int n=us.delSubjectById(subjecttype);
return new ModelAndView("admin/su.jsp");//更新用户信息后的界面
}
//更新查询
@RequestMapping("UpdateSelectSubById.action")
public ModelAndView UpdateSelectSubById(int subjectid,HttpSession session){
List<Subject>list=us.upfindSubjectById(subjectid);
session.setAttribute("listsu", list);
return new ModelAndView("admin/updatesub.jsp");//跳转到插入后的用户界面
}
//更新
@RequestMapping("UpdateSubById.action")
public ModelAndView UpdateSubById(String subjecttype,int subjectid){
int n=us.upSubjectById(subjecttype,subjectid);
return new ModelAndView("admin/su.jsp");//跳转到插入后的用户界面
}
//管理员找回密码
@RequestMapping("sendtel.action")
public void sendtel(HttpServletRequest request,HttpServletResponse response) throws IOException{
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String telphone=request.getParameter("telphone");
Random rd=new Random();
int yzm=rd.nextInt(999)*999;
System.out.println("yzm=--=="+yzm);
final String username="shanxihuaxin"; //短信平台用户名
final String userpwd="hxzy2008"; //短信平台密码
final String content="管理员您好，您本次操作的验证码为"+yzm+"，请尽快填写，谢谢"; //短信内容
final String url="http://service.winic.org:8009/sys_port/gateway/index.asp"; //接口
final String param="id="+username+"&pwd="+userpwd+"&to="+telphone+"&content="+content+"&otime=";
String sr=us.fogetPost(url, param);
System.out.println(sr);
JSONArray json=JSONArray.fromObject(yzm);
out.print(json);
}
//管理员验证码验证
@RequestMapping("telYz.action")
public ModelAndView telYz(HttpServletRequest request,HttpServletResponse response){
return new ModelAndView("admin/updatepwd.jsp");
}
//Excel批量导入用户
@RequestMapping("excel_insertUser.action")
public ModelAndView ExcelInsertUser(HttpServletRequest request,HttpServletResponse response,HttpSession session) throws IOException{
/*String uri=request.getParameter("userUploadFile");
System.out.println("uri===="+uri);*/
int usertype=Integer.parseInt(request.getParameter("usertype"));
InputStream is=new FileInputStream("c:\\Users.xls");
POIFSFileSystem fs=new POIFSFileSystem(is);
HSSFWorkbook wb=new HSSFWorkbook(fs);
HSSFSheet hssfSheet=wb.getSheetAt(0); //获取第一个Sheet页
//遍历行Row
Map map=new HashMap();
for(int rowNum=1;rowNum<=hssfSheet.getLastRowNum();rowNum++){
//得到每个具体的行
HSSFRow hssfRow=hssfSheet.getRow(rowNum);
if(hssfRow==null){
continue;
}
//System.out.print("hssfRow=行=== "+hssfRow);
//遍历列
for(int cellNum=0;cellNum<=hssfRow.getLastCellNum();cellNum++){
HSSFCell hssfCell=hssfRow.getCell(cellNum);
if(hssfCell==null){
continue;
}
if(cellNum==0)
{
map.put("username", hssfCell);
}else if(cellNum==1){
map.put("userpwd", hssfCell);
}else if(cellNum==2){
//System.out.println("hssfCell......"+hssfCell);
//hssfCell.equals("Java")
map.put("subjecttype", hssfCell);
//System.out.println("map======"+map);
String username=map.get("username").toString();
String userpwd=map.get("userpwd").toString();
//System.out.println("un=="+username+"........."+"up=="+userpwd);
int subjectid=us.FindIdBysubType(map.get("subjecttype").toString());
//System.out.println("subjectid==="+subjectid);
//System.out.println("------------------------"+username+" "+userpwd+" "+subjectid+" "+usertype);
us.insertUserByIdType(username, userpwd, subjectid, usertype);
}
//System.out.print("hssfCell=列= "+hssfCell);
}
System.out.println();
}
return new ModelAndView("admin/up.jsp");
}
}
最近下载更多
最近浏览