机房上机管理系统 JavaEE 开发的（分教师用户、学生用户、管理员用户等角色）

package com.wy.dao; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import java.util.*; import com.wy.form.ConsumerForm; import com.wy.tool.JDBConnection; import com.wy.form.teacherlogForm; public class ConsumerDao { private static JDBConnection connection = null; //private static ConsumerForm consumerForm = null; //private signform form1=null; public ConsumerDao() { connection = new JDBConnection(); } // 以用户名为查询条件，查询一组数据 public ConsumerForm getConsumerForm(String account) { ConsumerForm consumerForm=null; String sql = "select * from student where stuID='"+account+ "'"; try { ResultSet rs = connection.executeQuery(sql); //System.out.print(sql); while (rs.next()) { consumerForm = new ConsumerForm(); consumerForm.setAccount(rs.getString(2)); consumerForm.setPassword(rs.getString(3)); consumerForm.setName(rs.getString(4)); } rs.close(); } catch (SQLException e) { e.printStackTrace(); }finally{ //connection.dbClose(); } return consumerForm; } public ConsumerForm getConsumerFormAdmin(String account) { ConsumerForm consumerForm=null; String sql = "select * from administrator where name='"+account+ "'"; try { ResultSet rs = connection.executeQuery(sql); //System.out.print(sql); while (rs.next()) { consumerForm = new ConsumerForm(); consumerForm.setAccount(rs.getString(2)); consumerForm.setPassword(rs.getString(3)); } rs.close(); } catch (SQLException e) { e.printStackTrace(); }finally{ //connection.dbClose(); } return consumerForm; } public teacherlogForm getteacherlogForm(String account) { teacherlogForm consumerForm=null; String sql = "select * from teacher where teachID='"+account+ "'"; try { ResultSet rs = connection.executeQuery(sql); System.out.print(sql); while (rs.next()) { consumerForm = new teacherlogForm(); consumerForm.setAccount(rs.getString(2)); consumerForm.setPassword(rs.getString(3)); consumerForm.setName(rs.getString(4)); } rs.close(); } catch (SQLException e) { e.printStackTrace(); }finally{ //connection.dbClose(); } return consumerForm; } public boolean addsle(String xuehao,String name,String ip){ String sql="insert into online(stuID,stuName,sign,IpAddress) Values('"+xuehao+"','"+name+"',0,'"+ip+"')"; try{ connection.executeUpdate(sql); System.out.print(sql); dbClose(); //connection.close(); } catch(Exception e){ e.printStackTrace(); } return true; } public List getsign(String xuehao){ List list = new ArrayList(); try { String sql="select sign from online where stuID='"+xuehao+"'"; ResultSet rs = connection.executeQuery(sql); System.out.println(sql); while (rs.next()) { String sn=rs.getString(1); list.add(sn); } rs.close(); } catch (SQLException e) { e.printStackTrace(); }finally{ //dbClose(); } return list; } public static List getstudentlist(int sign) { List list = new ArrayList(); ConsumerForm consumerForm=null; String sql = "select * from online where sign='"+sign+"'"; try { ResultSet rs = connection.executeQuery(sql); while (rs.next()) { consumerForm = new ConsumerForm(); consumerForm.setAccount(rs.getString(2)); consumerForm.setName(rs.getString(3)); consumerForm.setIp(rs.getString(5)); consumerForm.setStarttime(rs.getString(7)); list.add(consumerForm); } rs.close(); } catch (SQLException e) { e.printStackTrace(); }finally{ //connection.dbClose(); } return list; } public boolean reset(String xuehao,String name,String ip,String time,String teacher){ boolean flag = false; String[] sqls = new String[2]; sqls[0]="insert into logtime(stuID,stuName,ip,starttime,teacher) Values('"+xuehao+"','"+name+"','"+ip+"','"+time+"','"+teacher+"')"; sqls[1]= "update online set sign='1',teacher='"+teacher+"',starttime='"+time+"' where stuID='"+xuehao+"'"; if (connection.executeUpdates(sqls)) { //connection.dbClose(); flag = true; } return flag; } public boolean down(Integer id,String xuehao,String time){ boolean flag = false; String[] sqls = new String[2]; sqls[0]= "update logtime set endtime='"+time+"' where id='"+id+"' "; sqls[1]="delete from online where stuID='"+xuehao+"'"; if (connection.executeUpdates(sqls)) { flag = true; } return flag; } public boolean changepassword(String mima,String xuehao){ boolean flag = false; String sql= "update student set stuPassWd='"+mima+"' where stuID='"+xuehao+"'"; if (connection.executeUpdate(sql)) { flag = true; } return flag; } public boolean changepassword2(String mima,String ID){ boolean flag = false; String sql= "update teacher set teachPassWd='"+mima+"' where teachID='"+ID+"'"; if (connection.executeUpdate(sql)) { flag = true; } return flag; } public List getmax(String xuehao){ List list = new ArrayList(); try { String sql="select max(id) from logtime where stuID='"+xuehao+"'"; ResultSet rs = connection.executeQuery(sql); while(rs.next()){ Integer sn=(Integer)rs.getInt(1); list.add(sn); } rs.close(); } catch (SQLException e) { e.printStackTrace(); }finally{ } return list; } public boolean teacherlog(String ID,String name,String time,String ip){ String sql="insert into teacherlog(teachID,teachName,starttime,ip) Values('"+ID+"','"+name+"','"+time+"','"+ip+"')"; try{ connection.executeUpdate(sql); System.out.print(sql); dbClose(); } catch(Exception e){ e.printStackTrace(); } return true; } public List getteachermax(String ID){ List list = new ArrayList(); try { String sql="select max(id) from teacherlog where teachID='"+ID+"'"; ResultSet rs = connection.executeQuery(sql); while(rs.next()){ Integer sn=(Integer)rs.getInt(1); list.add(sn); } rs.close(); } catch (SQLException e) { e.printStackTrace(); }finally{ //dbClose(); } return list; } public boolean teacherdown(Integer id,String time){ boolean flag = false; String sql= "update teacherlog set stoptime='"+time+"' where id='"+id+"' "; if (connection.executeUpdate(sql)) { //connection.dbClose(); flag = true; } return flag; } public void dbClose() throws SQLException{ JDBConnection.dbClose(); } }