html实现宿舍管理系统,宿舍管理系统部分代码实现

目录结构：

连接数据库功能代码实现：

package com.db;

import java.sql.*;

public class DBHelper {

private String dbUrl="jdbc:mysql://localhost:3306/sushe";

private String dbUser="root";

private String dbPassword="123456";

private String jdbcName="com.mysql.jdbc.Driver";

public Connection getConn(){

Connection conn = null;

try{

Class.forName(jdbcName);

}

catch(Exception e){}

try{

conn=DriverManager.getConnection(dbUrl,dbUser,dbPassword);

}

catch(SQLException ex){}

return conn;

}

public static void main(String[] args)

{

System.out.println(new DBHelper().getConn());

}

}

登陆功能代码实现：

package com.action;

import java.io.PrintWriter;

import java.util.List;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.HttpSession;

import org.apache.struts2.ServletActionContext;

import com.opensymphony.xwork2.ActionSupport;

import com.bean.;

import com.dao.;

public class PasswordUpdateSave extends ActionSupport {

//下面是Action内用于封装用户请求参数的属性

private String Password;

private String Password2;

private String Msg;

public String getPassword() {

return Password;

}

public void setPassword(String password) {

Password = password;

}

public String getPassword2() {

return Password2;

}

public void setPassword2(String password2) {

Password2 = password2;

}

public String getMsg() {

return Msg;

}

public void setMsg(String msg) {

Msg = msg;

}

//处理用户请求的execute方法

public String execute() throws Exception {

//解决乱码，用于页面输出

HttpServletResponse response=null;

response=ServletActionContext.getResponse();

response.setContentType("text/html;charset=UTF-8");

response.setCharacterEncoding("UTF-8");

PrintWriter out = response.getWriter();

//创建session对象

HttpSession session = ServletActionContext.getRequest().getSession();

//验证是否正常登录

if(session.getAttribute("id")==null){

out.print("");

out.flush();out.close();return null;

}

String type=session.getAttribute("type").toString();

if(type.equals("1"))//校园管理员身份

{

//查询原密码是否正确

if (new AdminDao().CheckPassword(session.getAttribute("id").toString(), Password)) {

//修改密码

AdminBean cnbean=new AdminBean();

cnbean=new AdminDao().GetBean(Integer.parseInt(session.getAttribute("id").toString()));

cnbean.setAdmin_Password(Password2);

new AdminDao().Update(cnbean);

out.print("");

out.flush();out.close();return null;

}

else

{

Msg = "用户名或者密码错误";

return INPUT;

}

}

else if(type.equals("2"))//楼宇管理员身份

{

//查询原密码是否正确

if (new TeacherDao().CheckPassword(session.getAttribute("id").toString(), Password)) {

//修改密码

TeacherBean cnbean=new TeacherBean();

cnbean=new TeacherDao().GetBean(Integer.parseInt(session.getAttribute("id").toString()));

cnbean.setTeacher_Password(Password2);

new TeacherDao().Update(cnbean);

out.print("");

out.flush();out.close();return null;

}

else

{

Msg = "用户名或者密码错误";

return INPUT;

}

}

else if(type.equals("3"))//学生身份