公司培训系统

    package bean;
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.PreparedStatement;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import dao.Dao;
    import util.Util;
    
    public class Bean
    {
        Util util=new Util( );
        Dao dao=new Dao( );
        public boolean FindName( ) throws Exception
        {
        Connection conn=util.getConnection( ); 
         String sql1="select * from management where 管理员编号=?";
         dao.stmt=conn.prepareStatement(sql1);
         dao.stmt.setString(1,dao.getID( ));
         dao.rs=dao.stmt.executeQuery( );
         while(dao.rs.next( ))
         {
             dao.setA(true);
             if(dao.rs.getString("密码").equals(dao.getMpassword()))
             {
                 return true;
             }
             else
             {
                 return false;
             }
         }
             return false;
        }
    
        public void AddEuser( ) throws Exception
        {
            Connection conn=util.getConnection( ); 
            String sql="insert into emlogin (员工编号,密码) values (?,?)";
            dao.stmt=conn.prepareStatement(sql);
            dao.stmt.setString(1,dao.getEID( ));
            dao.stmt.setString(2,dao.getTpassword( ));
            dao.stmt.execute();
        }
    
        public void AddTuser( ) throws Exception
        {
            Connection conn=util.getConnection( ); 
            String sql="insert into telogin (教师编号,密码) values (?,?)";
            dao.stmt=conn.prepareStatement(sql);
            dao.stmt.setString(1,dao.getTID( ));
            dao.stmt.setString(2,dao.getTpassword( ));
            dao.stmt.execute();
        }
    
    }