计算机毕业设计：Java实现的学生请假管理系统(源码+数据库)，保证可靠运行，附赠计算机答辩PPT模板

package shixun; import java.awt.Color; import java.awt.Font; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.io.*; import javax.swing.*; import javax.swing.*; import javax.swing.table.DefaultTableModel; import javax.swing.table.JTableHeader; import javax.swing.table.TableColumn; import com.mysql.jdbc.Connection; import java.sql.*; import java.util.Enumeration; import java.util.Vector; public class CounsellorShenHeSystem extends JFrame implements ActionListener{ /** * 辅导员查看学生请假信息模块 */ JLabel imagelabel;;//背景图片 JButton jb1=new JButton("审核请假信息"); JButton jb2=new JButton("审核销假信息"); JButton jb3=new JButton("学生请假记录"); JButton jb4=new JButton("通过审核"); JButton jb6=new JButton("审核不通过"); JButton jb5=new JButton("退出"); JButton jb7=new JButton("上交院长"); JButton jb8=new JButton("修改密码"); //JTextArea jt=new JTextArea(); // String[] columnNames={"姓名","学号","专业","联系","开始日期","结束日期","请假状态","请假事由"};//定义表格列名数 // String[][] tableValues={{"陈锦贤","182017331","计算机","15119747306","2019-9-23-17:55","2019-9-23-19:14","通过","因为想呆在宿舍"},{"21","22","23","24","25","26","27","28"},{"","","","","","","",""}, // {"","","","","","","",""},{"","","","","","","",""},{"","","","","","","",""},{"","","","","","","",""},{"","","","","","","",""}, // {"","","","","","","",""},{"","","","","","","",""},{"","","","","","","",""},{"","","","","","","",""},{"","","","","","","",""}, // {"","","","","","","",""},{"","","","","","","",""},{"","","","","","","",""},{"","","","","","","",""},{"","","","","","","",""}};//定义表格数据数组 // // JTable table=new JTable(tableValues,columnNames);//创建指定列名和数据的表格 Vector rowData,columnNames; JTable jt=null; JScrollPane jsp=null; Connection ct=null; ResultSet rs=null; Statement ps=null; String result;//该辅导员所管理的专业 // // public static final String DBDRVER ="org.gjt.mm.mysql.Driver"; // //定义MySQL数据库的连接地址 // public static final String DBURL="jdbc:mysql://localhost:3306/shixun?characterEncoding=utf-8"; // //MySQL数据库的连接用户名 // public static final String DBUSER="root"; // //MySQL数据库的连接密码 // public static final String DBPASS="root"; int num1,num2,num3,num4,num5,num6,num7; String name1; public static void main(String[] args) { // TODO Auto-generated method stub CounsellorShenHeSystem cshs=new CounsellorShenHeSystem(null); } public CounsellorShenHeSystem(String name){ name1=name; check();//调用这个函数，读取登陆用户管理的专业的名字 this.setTitle(name1+"辅导员管理请假信息系统"); this.setLocation(550,200); this.setSize(700,500); this.setDefaultCloseOperation(EXIT_ON_CLOSE); this.setLayout(null); ImageIcon image=new ImageIcon("image/3.jpg");//设置背景图片 imagelabel = new JLabel(image); imagelabel.setBounds(0,0,700,500); //JTable table=new JTable(tableValues,columnNames);//创建指定列名和数据的表格 // JScrollPane scrollpane=new JScrollPane(table);//创建显示表格的滚动面板 // //FitTableColumns(table); // table.setRowHeight(40); // table.setDefaultRenderer(Object.class, new TableCellTextAreaRenderer()); //JTableAUTO_RESIZE_ALL_COLUMNS; //table.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS); //JTable.AUTO_RESIZE_OFF //table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF); columnNames=new Vector(); //设置列名 columnNames.add("姓名"); columnNames.add("学号"); columnNames.add("专业"); columnNames.add("联系"); columnNames.add("开始日期"); columnNames.add("结束日期"); columnNames.add("请假事由"); columnNames.add("学生账号"); rowData = new Vector(); //rowData可以存放多行,开始从数据库里取 String DBDRVER ="org.gjt.mm.mysql.Driver"; //定义MySQL数据库的连接地址 // String DBURL="jdbc:mysql://localhost:3306/shixun?characterEncoding=utf-8"; String DBURL="jdbc:mysql://localhost:3306/guanliyuan?characterEncoding=utf-8"; // String DBURL="jdbc:mysql://39.105.231.173/guanliyuan?serverTimezone=UTC&characterEncoding=utf-8"; //MySQL数据库的连接用户名 String DBUSER="root"; //MySQL数据库的连接密码 String DBPASS="root"; // String DBPASS="aly66MYSQL!!!"; try { Class.forName("com.mysql.jdbc.Driver"); //(2)获取数据库连接 // Connection ct=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/shixun?useUnicode=true&characterEncoding=utf_8","root", "root"); ct=(Connection) DriverManager.getConnection(DBURL,DBUSER,DBPASS); //（3）创建SQL语句对象 Statement ps=ct.createStatement(); //(4)执行查询，返回结果集 // ResultSet rs=ps.executeQuery("SELECT * FROM user2"); String sql="select * from user2 where c='"+result+"'"; //假设要读的数据库表为user2 //String sql="SELECT * FROM user2"; ResultSet rs=ps.executeQuery(sql); // String sql="select * from cuserlist where name='"+name1+"'"; while(rs.next()){ String a =rs.getString(1); // System.out.println(a); String b =rs.getString(2); String c =rs.getString(3); String d =rs.getString(4); String e =rs.getString(5); String f =rs.getString(6); String g =rs.getString(7); String h =rs.getString(8); Vector hang=new Vector(); hang.add(a); hang.add(b); // hang.add(rs.getString(2).getBytes("lS08859-1")); hang.add(c); // hang.add(rs.getInt(4)); hang.add(d); hang.add(e); hang.add(f); hang.add(g); hang.add(h); //rowData可以存放多行 // Vector hang=new Vector(); // hang.add(rs.getString(1)); // hang.add(rs.getString(2)); // // hang.add(rs.getString(2).getBytes("lS08859-1")); // hang.add(rs.getString(3)); // // hang.add(rs.getInt(4)); // hang.add(rs.getString(4)); // hang.add(rs.getString(5)); // hang.add(rs.getString(6)); // hang.add(rs.getString(7)); //加入到rowData rowData.add(hang); //把读取到的内容添加进表格 System.out.println(rs.getString(1)); } } catch (Exception e) { e.printStackTrace(); } finally{ try { if(rs!=null){ rs.close(); } if(ps!=null){ ps.close(); } if(ct!=null){ ct.close(); } } catch (SQLException e) { e.printStackTrace(); } //初始化Jtable jt = new JTable(rowData,columnNames); jt.setRowHeight(40); jt.setDefaultRenderer(Object.class, new TableCellTextAreaRenderer()); //初始化 jsp jsp = new JScrollPane(jt); // FitTableColumns(jt); //把jsp放入到jframe jb1.setOpaque(false); jb1.setFont(new Font("简宋",Font.PLAIN,18)); jb2.setOpaque(false); jb2.setFont(new Font("简宋",Font.PLAIN,18)); jb3.setOpaque(false); jb3.setFont(new Font("简宋",Font.PLAIN,18));