java学籍管理系统部分代码_学生学籍管理系统(jsp+javabeans) 第五部分

基础类部分代码:

/*

* DataBase.java

*

* Created on 2006年6月15日, 下午1:00

*/

package personadmin;

import java.beans.*;

import java.io.Serializable;

import java.sql.*;

/**

* @author ibm

*/

public class DataBase extends Object implements Serializable

{

//by terry

public Connection con;

public java.sql.Statement sql;

public ResultSet rs=null;

public String sqlStr;

public DataBase()

{

this.connect();

this.sqlStr = "";

}

public boolean connect()

{

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

}

catch(ClassNotFoundException e){}

try

{

con = DriverManager.getConnection("jdbc:odbc:stuinfo","","");

sql = con.createStatement();

}

catch (SQLException ex)

{

return false;

}

return true;

}

}

/*

* ChineseProcess.java

*

* Created on 2006年6月16日, 下午10:54

*/

package personadmin;

import java.beans.*;

import java.io.Serializable;

/**

* @author ibm

*/

public class ChineseProcess extends Object implements Serializable

{

/*    private String older;

public ChineseProcess()

{

this.older = "";

}

public void setolder(String temp)

{

this.older = temp;

}*/

public String formatchange(String temp)throws Exception

{

byte b[] = temp.getBytes("ISO-8859-1");

String fuck = new String(b);

//     temp = new String(b);

return fuck;

}

}

/*

* ChangePassword.java

*

* Created on 2006年6月15日, 下午8:07

*/

package personadmin;

import java.beans.*;import java.io.Serializable;import personadmin.DataBase;import java.sql.*;/** * @author ibm */public class ChangePassword extends Object implements Serializable {    private String name;              //用户名    private String type;              //用户类型    private String oldpassword;       //旧密码    private String newpassword;       //新密码    private String affirmpassword;    //确认密码    private DataBase db;              //数据库处理    public ChangePassword()    {        this.name = "";        this.type = "";        this.oldpassword = "";        this.newpassword = "";        this.affirmpassword = "";        this.db = new DataBase();    }    public void setName(String temp)    {        this.name = temp;    }    public void setType(String temp)    {        this.type = temp;    }    public void setoldpassword(String temp)    {        this.oldpassword = temp;    }    public void setnewpassword(String temp)    {        this.newpassword = temp;    }    public void setaffirmpassword(String temp)    {        this.affirmpassword = temp;     }    public String getName()    {        return this.name;    }    public String getType()    {        return this.type;    }    public String getoldpassword()    {        return this.oldpassword;    }    public String getnewpassword()    {        return this.newpassword;    }    public String getaffirmpassword()    {        return this.affirmpassword;    }    public boolean justicenew()         //判断两个密码是否相等    {        return this.newpassword.equals(this.affirmpassword);    }    public boolean justiceolder(String session_password)      //判断旧密码是否输入是否正确    {        //temp从session获得        return this.oldpassword.equals(session_password);    }    //temp用户旧密码    public boolean findOlder(String session_password)  //获得修改密码    {        if (this.justicenew() && this.justiceolder(session_password)) //如果两个密码相等，并且旧密码也是正确的        {            if (this.type.equals("administrator"))                //管理员身份            {                 this.db.sqlStr = "update admininfo set adm_password = '"+this.newpassword+"' where adm_name = '"+this.name+"'";            }            else if (this.type.equals("teacher"))                //老师身份            {                 this.db.sqlStr = "update teacher_name set teacher_password = '"+this.newpassword+"' where teacher_name = '"+this.name+"'";            }            else if (this.type.equals("student"))                //学生身份            {                 this.db.sqlStr = "update registerinfo set reg_password = '"+this.newpassword+"' where reg_name = '"+this.name+"'";            }            return true;         //更改成功        }        else     //输入密码有问题        {            return false;        }    }       public boolean execute(String session_password)throws Exception    {        boolean flag = false;        if (this.findOlder(session_password))                 //如果输入正确        {            flag = true;            try            {                this.db.sql.executeUpdate(this.db.sqlStr);   //修改密码                this.db.sql.close();                           //关闭数据源            }            catch(SQLException e){}                    }        return flag;    }}