devbox
运维做开发
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

Java Swing+SQL sever学生管理系统代码_java+sqlserver学生成绩管理系统

作者：运维做开发 | 2024-07-23 23:13:59

赞

踩

java+sqlserver学生成绩管理系统

主界面(Interface类)：

主界面：我设置了全局字体，字体的话，如果在每个每个类中设置的话，会显得很臃肿，所以我就写了一方法定义了一个全局字体，当然，在最后面有些特殊需要的字体，我就另外重新定义了字体，而这个全局字体的话，是对所有的字体进行规范的。

然后添加了背景图片：

设置背景图片的方法基本上都是这样，但是你要知道，Java的Swing窗口，你在添加这些组件的时候，如果你没有设置透明，它是会覆盖的，从而显示不出来，这也是我之前所遇到的难题，所以后面每个类，再添加这些东西的时候，我都会去设置三个盘子，去容纳所需要添加的组件，如果你是是使用C#的话，那就会方便很多！

  1.         //设置背景图片
  2.         ImageIcon img = new ImageIcon("C:\\Users\\god36c\\OneDrive\\桌面\\图一.jpg");
  3.         JLabel bgimg = new JLabel(img);
  4.         bgimg.setBounds(0,0,img.getIconWidth(),img.getIconHeight());

主界面(Interface类)的源代码：

  1. package 高校学生管理库;
  2.  
  3. import java.awt.*;
  4. import java.awt.event.ActionEvent;
  5. import java.awt.event.ActionListener;
  6. import java.util.Enumeration;
  7.  
  8. import javax.swing.*;
  9. import javax.swing.plaf.FontUIResource;
  10.  
  11. public class Interface extends JFrame{
  12.     private static final long serialVersionUID = 1L;
  13.     final int WIDTH = 500;
  14.     final int HEIGHT = 315;
  15.     // 统一设置字体，父界面设置之后，所有由父界面进入的子界面都不需要再次设置字体
  16.     private static void InitGlobalFont(Font font) {
  17.         FontUIResource fontRes = new FontUIResource(font);
  18.         for (Enumeration<Object> keys = UIManager.getDefaults().keys(); keys.hasMoreElements(); ) {
  19.             Object key = keys.nextElement();
  20.             Object value = UIManager.get(key);
  21.             if (value instanceof FontUIResource) {
  22.                 UIManager.put(key, fontRes);
  23.             }
  24.         }
  25.     }
  26.     public Interface() {
  27.         setTitle("登录");
  28.         setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
  29.         setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
  30.         this.setSize(520,370);
  31.         this.setLocationRelativeTo(null);
  32.         setVisible(true);
  33.  
  34.         //给盘子1创建对象
  35.         javax.swing.JPanel jpanel_1 = new javax.swing.JPanel();
  36.         jpanel_1.setBounds(0,0,WIDTH,HEIGHT);
  37.         jpanel_1.setLayout(null);//设置布局为空
  38.         //给盘子2创建对象
  39.         javax.swing.JPanel jpanel_2 = new javax.swing.JPanel();
  40.         jpanel_2.setBounds(0,30,WIDTH,100);
  41.         FlowLayout flowLayout = new FlowLayout(FlowLayout.CENTER);
  42.         jpanel_2.setLayout(flowLayout);//设置布局为居中
  43.         jpanel_2.setOpaque(false);//设置盘子为透明
  44.         //给盘子3创建对象
  45.         javax.swing.JPanel jpanel_3 = new javax.swing.JPanel();
  46.         jpanel_3.setBounds(0,50,WIDTH,350);
  47.         jpanel_3.setLayout(null);//设置布局为空
  48.         jpanel_3.setOpaque(false);//设置盘子为透明
  49.         //初始化字体
  50.         font fonts = new font();
  51.         //设置背景图片
  52.         ImageIcon img = new ImageIcon("C:\\Users\\god36c\\OneDrive\\桌面\\图一.jpg");
  53.         JLabel bgimg = new JLabel(img);
  54.         bgimg.setBounds(0,0,img.getIconWidth(),img.getIconHeight());
  55.  
  56.         JLabel title = new JLabel(" 我  是 ");
  57.         title.setFont(font.title);
  58.         title.setHorizontalAlignment(SwingConstants.CENTER);//居中
  59.  
  60.         JButton g=new JButton("管理员");g.setBounds(200, 80, 100, 40);
  61.         JButton x=new JButton("学生");x.setBounds(200, 200, 100, 40);
  62.         g.setContentAreaFilled(false);x.setContentAreaFilled(false);
  63.  
  64.         jpanel_3.add(g);jpanel_3.add(x);jpanel_2.add(title);
  65.         jpanel_1.add(bgimg);this.add(jpanel_3);this.add(jpanel_2);
  66.         this.add(jpanel_1);
  67.  
  68.         x.addActionListener(new ActionListener() {//监听学生按钮
  69.             public void actionPerformed(ActionEvent e) {
  70.                 new Slogin();
  71.             }
  72.         });
  73.         g.addActionListener(new ActionListener() {//监听管理员按钮
  74.             public void actionPerformed(ActionEvent e) {
  75.                 new Glogin();
  76.             }
  77.         });
  78.     }
  79.     public static void main(String[] args) {
  80.         new Interface().setVisible(true);
  81.         InitGlobalFont(new Font("alias", Font.PLAIN, 18)); //统一设置字体
  82.     }
  83. }

8e5a57c81f914215acce46723115edb6.png

管理员(Glogin)和学生(Slogin)登录界面：

这个登录界面的实现还是比较简单的，但是设置了验证码以及学生密码运用MD5加密！！这两个的运用应该是系统的灵魂所在了。

而什么是MD5加密呢？

MD5概述：
MD5消息摘要算法，属Hash算法一类。MD5算法对输入任意长度的消息进行运行，产生一个128位的消息摘要(32位的数字字母混合码)。

MD5主要特点:
不可逆，相同数据的MD5值肯定一样，不同数据的MD5值不一样

(一个MD5理论上的确是可能对应无数多个原文的，因为MD5是有限多个的而原文可以是无数多个。比如主流使用的MD5将任意长度的“字节串映射为一个128bit的大整数。也就是一共有2^128种可能，大概是3.4*10^38，这个数字是有限多个的，而但是世界上可以被用来加密的原文则会有无数的可能性)

MD5的性质：
1、压缩性：任意长度的数据，算出的MD5值长度都是固定的(相当于超损压缩)。

2、容易计算：从原数据计算出MD5值很容易。

3、抗修改性：对原数据进行任何改动，哪怕只修改1个字节，所得到的MD5值都有很大区别。

4、弱抗碰撞：已知原数据和其MD5值，想找到一个具有相同MD5值的数据（即伪造数据）是非常困难的。

5、强抗碰撞：想找到两个不同的数据，使它们具有相同的MD5值，是非常困难的。

为了大家更好地理解，我推荐一篇文章：java中MD5加密 - zpk-aaron - 博客园 (cnblogs.com)

管理员(Glogin)界面源代码：

  1. package 高校学生管理库;
  2.  
  3. import java.awt.*;
  4. import java.awt.event.ActionEvent;
  5. import java.awt.event.ActionListener;
  6.  
  7. import java.sql.Statement;
  8. import java.sql.Connection;
  9. import java.sql.DriverManager;
  10. import java.sql.ResultSet;
  11. import java.sql.SQLException;
  12.  
  13. import javax.swing.*;
  14.  
  15. public class Glogin extends JFrame{
  16.     private static final long serialVersionUID = 1L;
  17.     private Captcha vcode = new Captcha();
  18.     JTextField co;
  19.     //窗口常量
  20.     final int WIDTH = 500;
  21.     final int HEIGHT = 315;
  22.     public Glogin() {
  23.         super("管理员登陆");
  24.         setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
  25.         this.setSize(520,370);
  26.         this.setLocationRelativeTo(null);
  27.         setVisible(true);
  28.         //初始化字体
  29.         font fonts = new font();
  30.         //给盘子1创建对象
  31.         javax.swing.JPanel jpanel_1 = new javax.swing.JPanel();
  32.         jpanel_1.setBounds(0,0,WIDTH,HEIGHT);
  33.         jpanel_1.setLayout(null);//设置布局为空
  34.         //给盘子2创建对象
  35.         javax.swing.JPanel jpanel_2 = new javax.swing.JPanel();
  36.         jpanel_2.setBounds(0,30,WIDTH,100);
  37.         FlowLayout flowLayout = new FlowLayout(FlowLayout.CENTER);
  38.         jpanel_2.setLayout(flowLayout);//设置布局为居中
  39.         jpanel_2.setOpaque(false);//设置盘子为透明
  40.         //给盘子3创建对象
  41.         javax.swing.JPanel jpanel_3 = new javax.swing.JPanel();
  42.         jpanel_3.setBounds(0,50,WIDTH,350);
  43.         jpanel_3.setLayout(null);//设置布局为空
  44.         jpanel_3.setOpaque(false);//设置盘子为透明
  45.         //设置背景图片
  46.         ImageIcon img = new ImageIcon("C:\\Users\\god36c\\OneDrive\\桌面\\图三.jpg");
  47.         JLabel bgimg = new JLabel(img);
  48.         bgimg.setBounds(0,0,img.getIconWidth(),img.getIconHeight());
  49.         //登录界面
  50.         JLabel title = new JLabel("管理员登录界面");
  51.         title.setFont(font.title);
  52.         JLabel l= new JLabel("账号");l.setBounds(80, 50, 60, 40);
  53.         JLabel p= new JLabel("密码");p.setBounds(80, 100, 60, 40);
  54.         JLabel code=new JLabel("验证码");code.setBounds(70, 150, 60, 40);
  55.         JTextField user=new JTextField();user.setBounds(150, 50, 150, 30);
  56.         JPasswordField pass=new JPasswordField();pass.setBounds(150, 100, 150, 30);
  57.         co=new JTextField();co.setBounds(150, 150, 150, 30);
  58.         JButton ok=new JButton("登录");ok.setBounds(180, 220, 70, 30);
  59.         ok.setContentAreaFilled(false);vcode.setBounds(310, 145, 100, 40);
  60.  
  61.         jpanel_3.add(l);jpanel_3.add(p);jpanel_3.add(code);
  62.         jpanel_3.add(user);jpanel_3.add(co);jpanel_3.add(vcode);
  63.         jpanel_3.add(pass);jpanel_3.add(ok);jpanel_2.add(title);
  64.         jpanel_1.add(bgimg);
  65.         this.add(jpanel_3);this.add(jpanel_2);this.add(jpanel_1);
  66.  
  67.         ok.addActionListener(new ActionListener() {//监听登录按钮
  68.             public void actionPerformed(ActionEvent e) {
  69.                 String jusername=user.getText();
  70.                 char s[]=pass.getPassword();
  71.                 String jpassword=new String(s);
  72.                 String coo=co.getText();
  73.                 try {
  74.                     Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  75.                     //加载对应的jdbc驱动
  76.                     String url="jdbc:sqlserver://localhost:1433;DatabaseName=高校学生管理库";
  77.                     //配置连接字符串
  78.                     String user="sa";//sa超级管理员
  79.                     String password="你的密码";//密码
  80.                     Connection conn=DriverManager.getConnection(url,user,password);
  81.                     //创建数据库连接对象
  82.                     Statement st=conn.createStatement();
  83.                     //创建SQL语句执行对象
  84.                     String  strSQL="(Select * from  dbo.GLY where ID1='"+jusername+"'And PAWD1='"+jpassword+"' )";
  85.                     ResultSet rs=st.executeQuery(strSQL);
  86.                     if(coo.isEmpty()) {
  87.                         JOptionPane.showMessageDialog(null, "请输入验证码!","提示消息",JOptionPane.WARNING_MESSAGE);
  88.                     }
  89.                     else {
  90.                         if(!isValidCodeRight()) {
  91.                             JOptionPane.showMessageDialog(null, "验证码错误,请重新输入!","提示消息",JOptionPane.WARNING_MESSAGE);
  92.                         }
  93.                         else {
  94.                             if(rs.next()) {
  95.                                 new GLY();
  96.                                 closeThis();
  97.                             }
  98.                             else {
  99.                                 JOptionPane.showMessageDialog(null,"用户名不存在或密码错误","错误!",JOptionPane.ERROR_MESSAGE);
  100.                             }
  101.                             conn.close();//关闭数据库连接
  102.                         }
  103.                     }
  104.                 }
  105.                 catch (ClassNotFoundException ex) {
  106.                     System.out.println("没有找到对应的数据库驱动类");
  107.                 }
  108.                 catch (SQLException ex) {
  109.                     System.out.println("数据库连接或者是数据库操作失败");
  110.                 }
  111.             }
  112.         });
  113.     }
  114.     public boolean isValidCodeRight() {
  115.         if(co == null) {
  116.             return false;
  117.         }else if(vcode == null) {
  118.             return true;
  119.         }else if(vcode.getCode() .equals(co.getText())) {
  120.             return true;
  121.         }else
  122.             return false;
  123.     }
  124.     public  void closeThis() {//关闭当前界面
  125.         this.dispose();
  126.     }
  127. }

0555bc96ca1e4d63a57e1816cf423e1c.png

学生(Slogin)界面源代码：

  1. package 高校学生管理库;
  2.  
  3. import java.awt.*;
  4. import java.awt.event.ActionEvent;
  5. import java.awt.event.ActionListener;
  6. import java.io.UnsupportedEncodingException;
  7. import java.security.NoSuchAlgorithmException;
  8. import java.sql.Statement;
  9. import java.sql.Connection;
  10. import java.sql.DriverManager;
  11. import java.sql.ResultSet;
  12. import java.sql.SQLException;
  13.  
  14. import javax.swing.*;
  15.  
  16. public class Slogin extends JFrame {
  17.     private static final long serialVersionUID = 1L;
  18.     private Captcha vcode = new Captcha();
  19.     JTextField co;
  20.     static JTextField user;
  21.     //窗口常量
  22.     final int WIDTH = 500;
  23.     final int HEIGHT = 315;
  24.     public Slogin() {
  25.         super("学生登陆");
  26.         setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
  27.         this.setSize(520,370);
  28.         this.setLocationRelativeTo(null);
  29.         setVisible(true);
  30.         //初始化字体
  31.         font fonts = new font();
  32.         //给盘子1创建对象
  33.         javax.swing.JPanel jpanel_1 = new javax.swing.JPanel();
  34.         jpanel_1.setBounds(0,0,WIDTH,HEIGHT);
  35.         jpanel_1.setLayout(null);//设置布局为空
  36.         //给盘子2创建对象
  37.         javax.swing.JPanel jpanel_2 = new javax.swing.JPanel();
  38.         jpanel_2.setBounds(0,30,WIDTH,100);
  39.         FlowLayout flowLayout = new FlowLayout(FlowLayout.CENTER);//设置布局为居中
  40.         jpanel_2.setLayout(flowLayout);
  41.         jpanel_2.setOpaque(false);//设置盘子为透明
  42.         //给盘子3创建对象
  43.         javax.swing.JPanel jpanel_3 = new javax.swing.JPanel();
  44.         jpanel_3.setBounds(0,50,WIDTH,350);
  45.         jpanel_3.setLayout(null);//设置布局为空
  46.         jpanel_3.setOpaque(false);//设置盘子为透明
  47.         //设置背景图片
  48.         ImageIcon img = new ImageIcon("C:\\Users\\god36c\\OneDrive\\桌面\\图二.jpg");
  49.         JLabel bgimg = new JLabel(img);
  50.         bgimg.setBounds(0,0,img.getIconWidth(),img.getIconHeight());
  51.         //登录界面
  52.         JLabel title = new JLabel("学生登录界面");
  53.         title.setFont(font.title);
  54.         JLabel l= new JLabel("账号");l.setBounds(80, 50, 60, 40);
  55.         JLabel p= new JLabel("密码");p.setBounds(80, 100, 60, 40);
  56.         JLabel code=new JLabel("验证码");code.setBounds(70, 150, 60, 40);
  57.         user=new JTextField();user.setBounds(150, 50, 150, 30);
  58.         JPasswordField pass=new JPasswordField();pass.setBounds(150, 100, 150, 30);
  59.         co=new JTextField();co.setBounds(150, 150, 150, 30);
  60.         JButton ok=new JButton("登录"); ok.setBounds(120, 220, 70, 30);
  61.         ok.setContentAreaFilled(false);
  62.         JButton register=new JButton("注册");register.setBounds(250, 220, 70, 30);
  63.         register.setContentAreaFilled(false);
  64.         vcode.setBounds(310, 145, 100, 40);
  65.  
  66.         jpanel_3.add(l);jpanel_3.add(p);jpanel_3.add(code);
  67.         jpanel_3.add(user);jpanel_3.add(co);jpanel_3.add(vcode);
  68.         jpanel_3.add(register);jpanel_3.add(pass);jpanel_3.add(ok);
  69.         jpanel_2.add(title);jpanel_1.add(bgimg);
  70.         this.add(jpanel_3);this.add(jpanel_2);this.add(jpanel_1);
  71.  
  72.         register.addActionListener(new ActionListener() {
  73.             public void actionPerformed(ActionEvent e) {
  74.                 new Enroll();
  75.                 closeThis();
  76.             }
  77.         });
  78.         ok.addActionListener(new ActionListener() {   //监听登录按钮
  79.             public void actionPerformed(ActionEvent e) {
  80.                 String jusername=user.getText();
  81.                 char s[]=pass.getPassword();
  82.                 String jpassword=new String(s);
  83.                 String coo=co.getText();
  84.                 try {
  85.                     Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  86.                     //加载对应的jdbc驱动
  87.                     String url="jdbc:sqlserver://localhost:1433;DatabaseName=高校学生管理库";
  88.                     //配置连接字符串
  89.                     String user="sa";//sa超级管理员
  90.                     String password="你的密码";//密码
  91.                     Connection conn=DriverManager.getConnection(url,user,password);
  92.                     //创建数据库连接对象
  93.                     Statement st=conn.createStatement();
  94.                     //创建SQL语句执行对象
  95.  
  96.                     Md5 md5 = new Md5();//使用MD5加密
  97.                     String newString = md5.EncoderByMd5(jpassword);
  98.                     String  strSQL="(Select * from  dbo.PY where ID='"+jusername+"'And PAWD='"+newString+"' )";
  99.                     ResultSet rs=st.executeQuery(strSQL);
  100.                     if(coo.isEmpty()) {
  101.                         JOptionPane.showMessageDialog(null, "请输入验证码!","提示消息",JOptionPane.WARNING_MESSAGE);
  102.                     }
  103.                     else {
  104.                         if(!isValidCodeRight()) {
  105.                             JOptionPane.showMessageDialog(null, "验证码错误,请重新输入!","提示消息",JOptionPane.WARNING_MESSAGE);
  106.                         }
  107.                         else {
  108.                             if(rs.next()) {
  109.                                 new Student();
  110.                                 closeThis();
  111.                             }
  112.                             else {
  113.                                 JOptionPane.showMessageDialog(null,"用户名不存在或密码错误","错误!",JOptionPane.ERROR_MESSAGE);
  114.                             }
  115.                             conn.close();//关闭数据库连接
  116.                         }
  117.                     }
  118.                 }
  119.                 catch (ClassNotFoundException ex) {
  120.                     System.out.println("没有找到对应的数据库驱动类");
  121.                 }
  122.                 catch (SQLException ex) {
  123.                     System.out.println("数据库连接或者是数据库操作失败");
  124.                 }catch (NoSuchAlgorithmException e1) {
  125.                     e1.printStackTrace();
  126.                 } catch (UnsupportedEncodingException e1) {
  127.                     e1.printStackTrace();
  128.                 }
  129.             }
  130.         });
  131.     }
  132.     public boolean isValidCodeRight() {
  133.         if(co == null) {
  134.             return false;
  135.         }else if(vcode == null) {
  136.             return true;
  137.         }else if(vcode.getCode() .equals(co.getText())) {
  138.             return true;
  139.         }else
  140.             return false;
  141.     }
  142.     public  void closeThis() {//关闭当前界面
  143.         this.dispose();
  144.     }
  145. }

e47d12e7c2c248f49b34fb49a8744a6a.png

 MD5类源代码：

  1. package 高校学生管理库;
  2.  
  3. import java.io.UnsupportedEncodingException;
  4. import java.security.MessageDigest;
  5. import java.security.NoSuchAlgorithmException;
  6. import sun.misc.BASE64Encoder;
  7.  
  8. public class Md5 {    /**利用MD5进行加密*/
  9.     public String EncoderByMd5(String str) throws NoSuchAlgorithmException, UnsupportedEncodingException{
  10.         //确定计算方法
  11.         MessageDigest md5=MessageDigest.getInstance("MD5");
  12.         BASE64Encoder base64en = new BASE64Encoder();
  13.         //加密后的字符串
  14.         String newstr=base64en.encode(md5.digest(str.getBytes("utf-8")));
  15.         return newstr;
  16.     }
  17. }

验证码功能(Captcha类)源代码:区分大小写，点击可更换

  1. package 高校学生管理库;
  2.  
  3. import java.awt.Color;
  4. import java.awt.Dimension;
  5. import java.awt.Font;
  6. import java.awt.FontMetrics;
  7. import java.awt.Graphics;
  8. import java.awt.Graphics2D;
  9. import java.awt.event.MouseEvent;
  10. import java.awt.event.MouseListener;
  11.  
  12. import java.util.Random;
  13.  
  14. import javax.swing.JComponent;
  15.  
  16. public class Captcha extends JComponent implements MouseListener {
  17.     private static final long serialVersionUID = 1L;
  18.     private String code;
  19.     private int width, height = 40;
  20.     private int codeLength = 4;
  21.     private Random random = new Random();
  22.     public Captcha() {
  23.         width = this.codeLength * 16 + (this.codeLength - 1) * 10;
  24.         setPreferredSize(new Dimension(width, height));
  25.         setSize(width, height);
  26.         this.addMouseListener(this);
  27.         setToolTipText("点击可以更换验证码");
  28.     }
  29.     public int getCodeLength() {
  30.         return codeLength;
  31.     }
  32.     //设置验证码文字的长度
  33.     public void setCodeLength(int codeLength) {
  34.         if(codeLength < 4) {
  35.             this.codeLength = 4;
  36.         } else {
  37.             this.codeLength = codeLength;
  38.         }
  39.     }
  40.     public String getCode() {
  41.         return code;
  42.     }
  43.     //产生随机的颜色
  44.     public Color getRandColor(int min, int max) {
  45.         if (min > 255)
  46.             min = 255;
  47.         if (max > 255)
  48.             max = 255;
  49.         int red = random.nextInt(max - min) + min;
  50.         int green = random.nextInt(max - min) + min;
  51.         int blue = random.nextInt(max - min) + min;
  52.         return new Color(red, green, blue);
  53.     }
  54.     //设置验证码具体的字母是什么
  55.     protected String generateCode() {
  56.         char[] codes = new char[this.codeLength];
  57.         for (int i = 0, len = codes.length; i < len; i++) {
  58.             if (random.nextBoolean()) {
  59.                 codes[i] = (char) (random.nextInt(26) + 65);
  60.             } else {
  61.                 codes[i] = (char) (random.nextInt(26) + 97);
  62.             }
  63.         }
  64.         this.code = new String(codes);
  65.         return this.code;
  66.     }
  67.     @Override
  68.     protected void paintComponent(Graphics g) {
  69.         super.paintComponent(g);
  70.         if(this.code == null || this.code.length() != this.codeLength) {
  71.             this.code = generateCode();
  72.         }
  73.         width = this.codeLength * 16 + (this.codeLength - 1) * 10;
  74.         super.setSize(width, height);
  75.         super.setPreferredSize(new Dimension(width, height));
  76.         Font mFont = new Font("Arial", Font.BOLD | Font.ITALIC, 25);
  77.         g.setFont(mFont);
  78.         //绘制出验证码的背景的矩形轮廓
  79.         Graphics2D g2d = (Graphics2D) g;
  80.         g2d.setColor(getRandColor(200, 250));
  81.         g2d.fillRect(0, 0, width, height);
  82.         g2d.setColor(getRandColor(180, 200));
  83.         g2d.drawRect(0, 0, width - 1, height - 1);
  84.         //绘制出验证码背景的线
  85.         int i = 0, len = 150;
  86.         for (; i < len; i++) {
  87.             int x = random.nextInt(width - 1);
  88.             int y = random.nextInt(height - 1);
  89.             int x1 = random.nextInt(width - 10) + 10;
  90.             int y1 = random.nextInt(height - 4) + 4;
  91.             g2d.setColor(getRandColor(180, 200));
  92.             g2d.drawLine(x, y, x1, y1);
  93.         }
  94.         //绘制出验证码的具体字母
  95.         i = 0; len = this.codeLength;
  96.         FontMetrics fm = g2d.getFontMetrics();
  97.         int base = (height - fm.getHeight())/2 + fm.getAscent();
  98.         for(;i<len;i++) {
  99.             int b = random.nextBoolean() ? 1 : -1;
  100.             g2d.rotate(random.nextInt(10)*0.01*b);
  101.             g2d.setColor(getRandColor(20, 130));
  102.             g2d.drawString(code.charAt(i)+"", 16 * i + 10, base);
  103.         }
  104.     }
  105.     //下一个验证码
  106.     public void nextCode() {
  107.         generateCode();
  108.         repaint();
  109.     }
  110.     @Override
  111.     public void mouseClicked(MouseEvent e) {
  112.         nextCode();
  113.     }
  114.     @Override
  115.     public void mousePressed(MouseEvent e) {
  116.     }
  117.     @Override
  118.     public void mouseReleased(MouseEvent e) {
  119.     }
  120.     @Override
  121.     public void mouseEntered(MouseEvent e) {
  122.     }
  123.     @Override
  124.     public void mouseExited(MouseEvent e) {
  125.     }
  126. }

学生注册（Enroll类）：

学生注册界面：
上传照片功能，这里我遇到了一个问题就是关于转义字符的问题，因为我要获取选中的图片的路径并将照片添加到JLabel里展示出来,当我们需要在字符串中使用普通的反斜杠时，就需要使用双反斜杠\\来表示；java编译器会将\\\\ 解释为 \\ ，而正则表达式里，双斜杠 \\ 代表单斜杠 \ ,这也就是为什么要用 \\\\ 表示 \ ，\\\\\\\\表示\\。

  1.         pho.addActionListener(new ActionListener() {
  2.             public void actionPerformed(ActionEvent e) {
  3.                 JFileChooser fileChooser = new JFileChooser("C:\\Users\\god36c\\OneDrive\\桌面");
  4.                 fileChooser.setFileSelectionMode(JFileChooser.FILES_AND_DIRECTORIES);
  5.                 int returnVal = fileChooser.showOpenDialog(fileChooser);
  6.                 if(returnVal == JFileChooser.APPROVE_OPTION) {
  7.                     File filePath = fileChooser.getSelectedFile();//获取图片路径
  8.                     System.out.println(filePath);
  9.                     String f=filePath.getPath();
  10.                     String filePath1=f.replaceAll("\\\\\\\\", "\\\\\\\\");	//将\转义为\\
  11.                     ImageIcon p = new ImageIcon(filePath1);
  12.                     photo.setIcon(p);
  13.                 }
  14.             }
  15.         });

然后这里用到了数据库中的表来判断是否已经存在这个人，如果存在注册失败，不存在并信息填入符合要求则成功（照片则保存照片的路径）。

学生注册界面源代码：

  1. package 高校学生管理库;
  2.  
  3. import java.awt.*;
  4. import java.awt.event.ActionEvent;
  5. import java.awt.event.ActionListener;
  6.  
  7. import java.io.File;
  8. import java.io.UnsupportedEncodingException;
  9. import java.security.NoSuchAlgorithmException;
  10.  
  11. import java.sql.Connection;
  12. import java.sql.DriverManager;
  13. import java.sql.PreparedStatement;
  14. import java.sql.ResultSet;
  15. import java.sql.SQLException;
  16. import java.sql.Statement;
  17.  
  18. import javax.swing.*;
  19.  
  20. public class Enroll extends JFrame{
  21.     private static final long serialVersionUID = 1L;
  22.     JTextField co;
  23.     private Captcha vcode = new Captcha();
  24.     final int WIDTH = 1020;
  25.     final int HEIGHT = 1615;
  26.     public Enroll() {
  27.         super("注册");
  28.         setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
  29.         this.setSize(1020,700);
  30.         this.setLocationRelativeTo(null); //此窗口将置于屏幕的中央
  31.         setVisible(true);
  32.  
  33.         //初始化字体
  34.         font fonts = new font();
  35.         //设置背景图片
  36.         ImageIcon img = new ImageIcon("C:\\Users\\god36c\\OneDrive\\桌面\\图七.jpg");
  37.         JLabel bgimg = new JLabel(img);
  38.         bgimg.setBounds(0,0,img.getIconWidth(),img.getIconHeight());
  39.         bgimg.setOpaque(false);//背景照片透明
  40.         //给盘子1创建对象
  41.         javax.swing.JPanel jpanel_1 = new javax.swing.JPanel();
  42.         jpanel_1.setBounds(0,0,WIDTH,HEIGHT);
  43.         jpanel_1.setLayout(null);//设置布局为空
  44.         jpanel_1.setOpaque(false);
  45.         //给盘子2创建对象
  46.         javax.swing.JPanel jpanel_2 = new javax.swing.JPanel();
  47.         jpanel_2.setBounds(0,30,WIDTH,100);
  48.         FlowLayout flowLayout = new FlowLayout(FlowLayout.CENTER);
  49.         jpanel_2.setLayout(flowLayout);//设置布局为居中
  50.         jpanel_2.setOpaque(false);//设置盘子为透明
  51.         //给盘子3创建对象
  52.         javax.swing.JPanel jpanel_3 = new javax.swing.JPanel();
  53.         jpanel_3.setBounds(0,50,WIDTH,350);
  54.         jpanel_3.setLayout(null);//设置布局为空
  55.         jpanel_3.setOpaque(false);//设置盘子为透明
  56.  
  57.         JLabel title = new JLabel(" 注 册 界 面 ");
  58.         title.setFont(font.title);
  59.         title.setHorizontalAlignment(SwingConstants.CENTER);//居中
  60.  
  61.         JLabel username=new JLabel("账号");username.setBounds(58, 46, 60, 40);
  62.         JLabel password=new JLabel("密码");password.setBounds(54,100,120,30);
  63.         JLabel id=new JLabel("学号");id.setBounds(54,150,120,30);
  64.         JLabel phone=new JLabel("手机号码");phone.setBounds(22,200,120,30);
  65.         JLabel code=new JLabel("验证码");code.setBounds(41,250,120,30);
  66.         JLabel photo=new JLabel();photo.setBounds(280,100,200,200);
  67.         JTextField user=new JTextField();user.setBounds(100,50,120,30);
  68.         JTextField pass=new JTextField(); pass.setBounds(100,100,120,30);
  69.         JTextField idd=new JTextField();idd.setBounds(100,150,120,30);
  70.         JTextField ph=new JTextField();ph.setBounds(100,200,120,30);
  71.         co=new JTextField();co.setBounds(100,250,120,30);
  72.         JButton pho=new JButton("上传照片");pho.setBounds(305,280,100,30);
  73.         JButton register=new JButton("注  册"); register.setBounds(150,380,80,30);
  74.         JButton exit=new JButton("退  出");exit.setBounds(250,380,80,30);
  75.         pho.setContentAreaFilled(false);register.setContentAreaFilled(false);exit.setContentAreaFilled(false);
  76.         vcode.setBounds(112, 300, 100, 40);
  77.  
  78.         jpanel_1.add(username);jpanel_1.add(user);jpanel_1.add(password);
  79.         jpanel_1.add(pass);jpanel_1.add(id);jpanel_1.add(idd);
  80.         jpanel_1.add(phone);jpanel_1.add(ph);jpanel_1.add(code);
  81.         jpanel_1.add(co);jpanel_1.add(photo);jpanel_1.add(pho);
  82.         jpanel_1.add(register);jpanel_1.add(exit);jpanel_1.add(vcode);
  83.         jpanel_1.add(bgimg);this.add(jpanel_1);jpanel_2.add(title);
  84.         this.add(jpanel_2);this.add(jpanel_3);
  85.  
  86.         pho.addActionListener(new ActionListener() {
  87.             public void actionPerformed(ActionEvent e) {
  88.                 JFileChooser fileChooser = new JFileChooser("C:\\Users\\god36c\\OneDrive\\桌面");
  89.                 fileChooser.setFileSelectionMode(JFileChooser.FILES_AND_DIRECTORIES);
  90.                 int returnVal = fileChooser.showOpenDialog(fileChooser);
  91.                 if(returnVal == JFileChooser.APPROVE_OPTION) {
  92.                     File filePath = fileChooser.getSelectedFile();//获取图片路径
  93.                     System.out.println(filePath);
  94.                     String f=filePath.getPath();
  95.                     String filePath1=f.replaceAll("\\\\\\\\", "\\\\\\\\");	//将\转义为\\
  96.                     ImageIcon p = new ImageIcon(filePath1);
  97.                     photo.setIcon(p);
  98.                 }
  99.             }
  100.         });
  101.         register.addActionListener(new ActionListener() {
  102.             public void actionPerformed(ActionEvent e) {
  103.                 String user1=user.getText().trim();
  104.                 String pass1=pass.getText().trim();
  105.                 String id1=idd.getText().trim();
  106.                 String ph1=ph.getText().trim();
  107.                 String co1=co.getText();
  108.                 try {
  109.                     Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  110.                     //加载对应的jdbc驱动
  111.                     String url="jdbc:sqlserver://localhost:1433;DatabaseName=高校学生管理库";
  112.                     //配置连接字符串
  113.                     String user="sa";//sa超级管理员
  114.                     String password="你的密码";//密码
  115.                     Connection conn=DriverManager.getConnection(url,user,password);
  116.                     //创建数据库连接对象
  117.                     Statement st=conn.createStatement();
  118.                     //创建SQL语句执行对象
  119.                     String  strSQL="(Select * from  dbo.PY where ID='"+user1+"' )";
  120.                     ResultSet rs=st.executeQuery(strSQL);
  121.                     Md5 md5 = new Md5();
  122.                     String newString = md5.EncoderByMd5(pass1);
  123.                     if(co1.isEmpty()) {
  124.                         JOptionPane.showMessageDialog(null, "请输入验证码!","提示消息",JOptionPane.WARNING_MESSAGE);
  125.                     }
  126.                     else {
  127.                         if(!isValidCodeRight()) {
  128.                             JOptionPane.showMessageDialog(null, "验证码错误,请重新输入!","提示消息",JOptionPane.WARNING_MESSAGE);
  129.                         }
  130.                         else {
  131.                             if(rs.next()) {
  132.                                 JOptionPane.showMessageDialog(null,"用户名已存在","错误!", JOptionPane.ERROR_MESSAGE);
  133.                             }
  134.                             else {
  135.                                 String sql = "insert into dbo.PY(ID,PAWD,Sno,phone) values('"+user1+"','"+newString+"','"+id1+"','"+ph1+"')";
  136.                                 PreparedStatement pst = conn.prepareStatement(sql,Statement.RETURN_GENERATED_KEYS);
  137.                                 pst.executeUpdate();
  138.                                 pst.close();
  139.                                 JOptionPane.showMessageDialog(null,"注册成功");
  140.                             }
  141.                             conn.close();//关闭数据库连接
  142.                         }
  143.                     }
  144.                 }
  145.                 catch (ClassNotFoundException ex) {
  146.                     System.out.println("没有找到对应的数据库驱动类");
  147.                 }
  148.                 catch (SQLException ex) {
  149.                     System.out.println("数据库连接或者是数据库操作失败");
  150.                 }
  151.                 catch (NoSuchAlgorithmException e1) {
  152.                     e1.printStackTrace();
  153.                 } catch (UnsupportedEncodingException e1) {
  154.                     e1.printStackTrace();
  155.                 }
  156.             }
  157.         });
  158.         exit.addActionListener(new ActionListener() {
  159.             public void actionPerformed(ActionEvent e) {
  160.                 closeThis();
  161.                 new Slogin();
  162.             }
  163.         });
  164.     }
  165.     public boolean isValidCodeRight() {
  166.         if(co == null) {
  167.             return false;
  168.         }else if(vcode == null) {
  169.             return true;
  170.         }else if(vcode.getCode() .equals(co.getText())) {
  171.             return true;
  172.         }else
  173.             return false;
  174.     }
  175.     public  void closeThis(){//关闭当前界面
  176.         this.dispose();
  177.     }
  178. }

学生类（Student）:

另外，大家要注意数据库链接的时候，我的数据库是和你们不一样的，所以你们要留意一下，自己的数据库是否和我一样，如果不一样要根据自己的数据库去更改一下，不然是链接不成功的！！接下来的学生和管理员类，是这次系统设计的核心。

Student的源代码：

  1. package 高校学生管理库;
  2.  
  3. import java.awt.Dimension;
  4. import java.awt.Menu;
  5. import java.awt.MenuBar;
  6. import java.awt.MenuItem;
  7. import java.awt.event.ActionEvent;
  8. import java.awt.event.ActionListener;
  9. import java.sql.Connection;
  10. import java.sql.Statement;
  11. import java.util.Vector;
  12. import java.sql.DriverManager;
  13. import java.sql.ResultSet;
  14. import java.sql.SQLException;
  15.  
  16. import javax.swing.ImageIcon;
  17. import javax.swing.JButton;
  18. import javax.swing.JFrame;
  19. import javax.swing.JLabel;
  20. import javax.swing.JOptionPane;
  21. import javax.swing.JPanel;
  22. import javax.swing.JScrollPane;
  23. import javax.swing.JTabbedPane;
  24. import javax.swing.JTable;
  25. import javax.swing.JTextField;
  26. import javax.swing.table.DefaultTableModel;
  27.  
  28. public class Student extends JFrame{
  29.     private static final long serialVersionUID = 1L;
  30.     public Student() throws SQLException, ClassNotFoundException
  31.     {
  32.         super("学生登陆");
  33.         setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
  34.         this.setSize(800,600);
  35.         this.setLocationRelativeTo(null);
  36.         setVisible(true);
  37.  
  38.         MenuBar bar = new MenuBar();// 创建菜单栏
  39.         Menu fileMenu = new Menu("FILE");// 创建“文件”菜单
  40.         MenuItem open = new MenuItem("OPEN");
  41.         MenuItem exit = new MenuItem("EXIT");
  42.         Menu help = new Menu("HELP");// 创建“帮助"菜单
  43.         MenuItem print = new MenuItem("PRINT");
  44.  
  45.         exit.addActionListener(new ActionListener(){
  46.             public void actionPerformed(ActionEvent e)
  47.             {
  48.                 new Slogin();
  49.                 closeThis();
  50.             }
  51.         });
  52.         //设置背景图片
  53.         ImageIcon img = new ImageIcon("C:\\Users\\god36c\\OneDrive\\桌面\\图八.jpg");
  54.         JLabel bgimg = new JLabel(img);
  55.         bgimg.setBounds(0,0,img.getIconWidth(),img.getIconHeight());
  56.         bgimg.setOpaque(false);//背景照片透明
  57.         //设置背景图片
  58.         ImageIcon img1 = new ImageIcon("C:\\Users\\god36c\\OneDrive\\桌面\\图十.jpg");
  59.         JLabel bgimg1 = new JLabel(img1);
  60.         bgimg1.setBounds(0,0,img1.getIconWidth(),img1.getIconHeight());
  61.         bgimg1.setOpaque(false);//背景照片透明
  62.         //设置背景图片
  63.         ImageIcon img2 = new ImageIcon("C:\\Users\\god36c\\OneDrive\\桌面\\图九.jpg");
  64.         JLabel bgimg2 = new JLabel(img2);
  65.         bgimg2.setBounds(0,0,img2.getIconWidth(),img2.getIconHeight());
  66.         bgimg2.setOpaque(false);//背景照片透明
  67.  
  68.         fileMenu.add(print);fileMenu.add(open);
  69.         fileMenu.addSeparator();// 设置菜单分隔符
  70.         fileMenu.add(exit);
  71.         bar.add(fileMenu);// 将文件添加到菜单栏上
  72.         bar.add(help);// 将文件添加到菜单栏上
  73.         setMenuBar(bar);// 设置菜单栏，使用这种方式设置菜单栏可以不占用布局空间
  74.         //创建组件
  75.         JPanel jp1= new JPanel();//定义面板
  76.         JPanel jp2= new JPanel();
  77.         JPanel jp3= new JPanel();
  78.         jp1.setLayout(null);//自由布局
  79.         jp2.setLayout(null);//自由布局
  80.         jp3.setLayout(null);//自由布局
  81.         //jp1面板上上的内容
  82.         String[][] datas = {};
  83.         String[] titles = { "学号", "姓名","性别","年龄","专业" };
  84.         String[][] datas1 = {};
  85.         String[] titles1 = { "课程号", "分数","等级"};
  86.  
  87.         DefaultTableModel myModel  = new DefaultTableModel(datas, titles);// myModel存放表格的数据
  88.         DefaultTableModel myModel1 = new DefaultTableModel(datas1, titles1);
  89.         JTable table  = new JTable(myModel);// 表格对象table的数据来源是myModel对象
  90.         JTable table1 = new JTable(myModel1);
  91.         table.setPreferredScrollableViewportSize(new Dimension(550, 100));// 表格的显示尺寸
  92.         table1.setPreferredScrollableViewportSize(new Dimension(550, 100));
  93.         // 产生一个带滚动条的面板
  94.         JScrollPane scrollPane = new JScrollPane(table);scrollPane.setBounds(50, 190, 550, 70);
  95.         JScrollPane scrollPane1 = new JScrollPane(table1);scrollPane1.setBounds(50, 290, 550, 100);
  96.         //行高
  97.         table.setRowHeight(20);
  98.         table1.setRowHeight(20);
  99.  
  100.         Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  101.         //加载对应的jdbc驱动
  102.         String url="jdbc:sqlserver://localhost:1433;DatabaseName=高校学生管理库";
  103.         //配置连接字符串
  104.         String user="sa";//sa超级管理员
  105.         String password="123456";//密码
  106.         Connection conn=DriverManager.getConnection(url,user,password);
  107.         //创建数据库连接对象
  108.         Statement st=conn.createStatement();
  109.         //创建SQL语句执行对象
  110.  
  111.         String  strSQL="(Select * from  dbo.Student where Sname='"+ Slogin.user.getText()+"')";
  112.         ResultSet rs=st.executeQuery(strSQL);
  113.         if(rs.next()) {
  114.             Vector<String> ve = new Vector<String>();
  115.             ve.addElement(rs.getString(1));ve.addElement(rs.getString(2));
  116.             ve.addElement(rs.getString(3));ve.addElement(rs.getString(4));
  117.             ve.addElement(rs.getString(5));
  118.             myModel.addRow(ve);
  119.         }
  120.         String  s1="(Select * from dbo.Student,dbo.SC where Sname='"+ Slogin.user.getText()+"' And Student.Sno=SC.Sno)";
  121.         ResultSet r1=st.executeQuery(s1);
  122.         while(r1.next()) {
  123.             Vector<String> ve1 = new Vector<String>();
  124.             ve1.addElement(r1.getString(7));
  125.             ve1.addElement(r1.getString(8));
  126.             ve1.addElement(r1.getString(9));
  127.             myModel1.addRow(ve1);
  128.         }
  129.         JButton again=new JButton("刷 新~");again.setBounds(490, 140, 80, 30);
  130.         again.setContentAreaFilled(false);
  131.         again.addActionListener(new ActionListener(){
  132.             public void actionPerformed(ActionEvent e) {
  133.                 try {
  134.                     Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  135.                     //加载对应的jdbc驱动
  136.                     String url="jdbc:sqlserver://localhost:1433;DatabaseName=高校学生管理库";
  137.                     //配置连接字符串
  138.                     String user="sa";//sa超级管理员
  139.                     String password="你的密码";//密码
  140.                     Connection conn=DriverManager.getConnection(url,user,password);
  141.                     Statement st=conn.createStatement();
  142.                     while(myModel1.getRowCount()>0) {
  143.                         myModel1.removeRow(myModel1.getRowCount()-1);
  144.                     }
  145.                     String  s1="(Select * from dbo.Student,dbo.SC where Sname='"+ Slogin.user.getText()+"' And Student.Sno=SC.Sno)";
  146.                     ResultSet r1=st.executeQuery(s1);
  147.                     while(r1.next()) {
  148.                         Vector<String> ve1 = new Vector<String>();
  149.                         ve1.addElement(r1.getString(7));
  150.                         ve1.addElement(r1.getString(8));
  151.                         ve1.addElement(r1.getString(9));
  152.                         myModel1.addRow(ve1);
  153.                     }
  154.                     conn.close();
  155.                 }catch (ClassNotFoundException ex) {
  156.                     System.out.println("没有找到对应的数据库驱动类");
  157.                 }
  158.                 catch (SQLException ex) {
  159.                     System.out.println("数据库连接或者是数据库操作失败");
  160.                 }
  161.             }
  162.         });
  163.         //jp2面板上的内容
  164.         String[][] datas2 = {};
  165.         String[] titles2 = { "课程号", "课程名","学分" };
  166.         DefaultTableModel myModel2 = new DefaultTableModel(datas2, titles2);
  167.         JTable table2  = new JTable(myModel2);
  168.         table2.setRowHeight(20);
  169.         table2.setPreferredScrollableViewportSize(new Dimension(550, 400));
  170.         JScrollPane scrollPane2 = new JScrollPane(table2);scrollPane2.setBounds(50, 20, 550, 400);
  171.         String  s2="(Select * from dbo.Course)";
  172.         ResultSet r2=st.executeQuery(s2);
  173.         while(r2.next()) {
  174.             Vector<String> ve2 = new Vector<String>();
  175.             ve2.addElement(r2.getString(1));
  176.             ve2.addElement(r2.getString(2));
  177.             ve2.addElement(r2.getString(4));
  178.             myModel2.addRow(ve2);
  179.         }
  180.         conn.close();
  181.         //jp2上的内容
  182.         JLabel a=new JLabel("请输入你想选的课的课程号：");a.setBounds(50, 470, 270, 30);
  183.         JTextField b=new JTextField(20);b.setBounds(320, 470, 150, 25);
  184.         JButton c=new JButton("确定");c.setBounds(500, 470, 80, 27);
  185.         //jp3上的内容
  186.         JLabel ja1=new JLabel("你想查询的科目是：");ja1.setBounds(50, 50, 200, 30);
  187.         JLabel ja2=new JLabel("你的成绩是：");ja2.setBounds(80, 220, 150, 30);
  188.         JLabel ja3=new JLabel("你的等级是：");ja3.setBounds(80, 270, 150, 30);
  189.         JLabel ja4=new JLabel("(输入课程号哦~)");ja4.setBounds(255, 80, 150, 30);
  190.         JTextField b1=new JTextField(15);b1.setBounds(260, 50, 150, 25);
  191.         JTextField b2=new JTextField(15);b2.setBounds(260, 220, 100, 25);
  192.         JTextField b3=new JTextField(15);b3.setBounds(260, 270, 100, 25);
  193.         JButton c1=new JButton("查 询");c1.setBounds(450, 50, 70, 30);
  194.         // 将组件添加入jp1窗口中
  195.         jp1.add(scrollPane);jp1.add(scrollPane1);
  196.         jp1.add(again);jp1.add(bgimg);
  197.         // 将组件添加入jp2窗口中
  198.         jp2.add(scrollPane2);jp2.add(a);jp2.add(b);
  199.         jp2.add(c);jp2.add(bgimg1);
  200.         // 将组件添加入jp3窗口中
  201.         jp3.add(ja1);jp3.add(ja2);jp3.add(ja3);
  202.         jp3.add(ja4);jp3.add(b1);jp3.add(b2);
  203.         jp3.add(b3);jp3.add(c1);jp3.add(bgimg2);
  204.         JTabbedPane jtbp=new JTabbedPane(JTabbedPane.LEFT); //创建选项卡并使选项卡垂直排列
  205.         jtbp.add("个人信息",jp1);jtbp.add("选课",jp2);jtbp.add("成绩查询",jp3);
  206.         this.add(jtbp);    //添加选项卡窗格到容器
  207.         c.addActionListener(new ActionListener(){
  208.             public void actionPerformed(ActionEvent e)
  209.             {
  210.                 try {
  211.                     Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  212.                     //加载对应的jdbc驱动
  213.                     String url="jdbc:sqlserver://localhost:1433;DatabaseName=高校学生管理库";
  214.                     //配置连接字符串
  215.                     String user="sa";//sa超级管理员
  216.                     String password="你的密码";//密码
  217.                     Connection conn=DriverManager.getConnection(url,user,password);
  218.                     Statement st=conn.createStatement();
  219.                     String ok=b.getText().trim();
  220.                     String s="(Select * from dbo.Course where Cno='"+ok+"' )";
  221.                     ResultSet r=st.executeQuery(s);
  222.                     if(r.next()) {
  223.                         String s1="(Select * from dbo.Student,dbo.SC where Sname='"+ Slogin.user.getText()+"' And SC.Sno=Student.Sno )";
  224.                         ResultSet r1=st.executeQuery(s1);
  225.                         if(r1.next()) {
  226.                             String s2="(Select * from dbo.SC where Sno='"+r1.getString(1)+"' And Cno='"+ok+"' )";
  227.                             ResultSet r2=st.executeQuery(s2);
  228.                             if(r2.next()) {
  229.                                 JOptionPane.showMessageDialog(null, "你已经选过该科目了~","提示消息",JOptionPane.WARNING_MESSAGE);
  230.                             }
  231.                             else {
  232.                                 String ss="(Select * from dbo.Student where Sname='"+ Slogin.user.getText()+"')";
  233.                                 ResultSet rr=st.executeQuery(ss);
  234.                                 if(rr.next()) {
  235.                                     String  strSQL="insert into dbo.SC(Sno,Cno) values('"+rr.getString(1)+"','"+ok+"')";
  236.                                     int rr1=st.executeUpdate(strSQL);
  237.                                     if(rr1==1) {
  238.                                         JOptionPane.showMessageDialog(null, "选课成功","提示消息",JOptionPane.WARNING_MESSAGE);
  239.                                     }
  240.                                 }
  241.                             }
  242.                         }
  243.                     }
  244.                     else {
  245.                         JOptionPane.showMessageDialog(null, "没有这种科目哦~","提示消息",JOptionPane.WARNING_MESSAGE);
  246.                     }
  247.                     conn.close();
  248.                 }catch (ClassNotFoundException ex) {
  249.                     System.out.println("没有找到对应的数据库驱动类");
  250.                 }
  251.                 catch (SQLException ex) {
  252.                     System.out.println("数据库连接或者是数据库操作失败");
  253.                 }
  254.             }
  255.         });
  256.         c1.addActionListener(new ActionListener(){
  257.             public void actionPerformed(ActionEvent e) {
  258.                 try {
  259.                     Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  260.                     //加载对应的jdbc驱动
  261.                     String url="jdbc:sqlserver://localhost:1433;DatabaseName=高校学生管理库";
  262.                     //配置连接字符串
  263.                     String user="sa";//sa超级管理员
  264.                     String password="你的密码";//密码
  265.                     Connection conn=DriverManager.getConnection(url,user,password);
  266.                     Statement st=conn.createStatement();
  267.  
  268.                     String B1=b1.getText().trim();
  269.                     String L="(Select * from dbo.Student,dbo.SC where Sname='"+ Slogin.user.getText()+"' And Cno='"+B1+"' And Student.Sno=SC.Sno )";
  270.                     ResultSet M=st.executeQuery(L);
  271.                     if(M.next()) {
  272.                         b2.setText(M.getString(8));
  273.                         b3.setText(M.getString(9));
  274.                     }
  275.                     else {
  276.                         JOptionPane.showMessageDialog(null, "没有该科目的成绩哦~","提示消息",JOptionPane.WARNING_MESSAGE);
  277.                     }
  278.                     conn.close();
  279.                 }catch (ClassNotFoundException ex) {
  280.                     System.out.println("没有找到对应的数据库驱动类");
  281.                 }
  282.                 catch (SQLException ex) {
  283.                     System.out.println("数据库连接或者是数据库操作失败");
  284.                 }
  285.             }
  286.         });
  287.     }
  288.     public  void closeThis() {//关闭当前界面
  289.         this.dispose();
  290.     }
  291. }

a9cb386529474543a814288b946150e5.png

73e265aad61441e197a3d33d09ebebda.png 

 614ef65dc4fe46f7a85bac1d1f6d606d.png

 管理员（GLY）类：

这个管理员类，主要是显示和查询功能，当然，管理员这上面还是有一些组件，增删改的跳转，以及我们可以全部查询，也可以按学生学号进行查询，以及显示各种，专业，但是要记住的是，如果你没有注册学生账号，那么你按学号查询的话是只能查询到，所选的课程和课程号等，是不能查询到学生的其他信息的，简单来说就是，你只能查询到，最下面两组的信息，但是，如果你是按我的代码去写的话，那就是不会有任何问题，但是你如果是自己去添加什么功能的话，那么你的数据库列哪里就会发生改变，你就自己去调整和更改那些列，不然，是显示不出来的！！

GLY源代码;

  1. package 高校学生管理库;
  2.  
  3. import java.awt.Dimension;
  4. import java.awt.event.ActionEvent;
  5. import java.awt.event.ActionListener;
  6. import java.sql.Connection;
  7. import java.sql.DriverManager;
  8. import java.sql.ResultSet;
  9. import java.sql.SQLException;
  10. import java.sql.Statement;
  11. import java.util.Vector;
  12.  
  13. import javax.swing.ImageIcon;
  14. import javax.swing.JButton;
  15. import javax.swing.JFrame;
  16. import javax.swing.JLabel;
  17. import javax.swing.JPanel;
  18. import javax.swing.JScrollPane;
  19. import javax.swing.JSplitPane;
  20. import javax.swing.JTable;
  21. import javax.swing.JTextField;
  22. import javax.swing.table.DefaultTableModel;
  23.  
  24. public class GLY extends JFrame  {
  25.     private static final long serialVersionUID = 1L;
  26.     public GLY()
  27.     {
  28.         super("管理员登录");
  29.         JPanel A=new JPanel();
  30.         JPanel B=new JPanel();
  31.         JSplitPane jSplitPane = new JSplitPane(JSplitPane.VERTICAL_SPLIT,A,B);//分屏的方式：左右HORIZONTAL_SPLIT，上下VERTICAL_SPLIT
  32.         jSplitPane.setDividerLocation(150);
  33.         this.add(jSplitPane);
  34.         setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
  35.         this.setSize(1020,700);
  36.         this.setLocationRelativeTo(null);
  37.         setVisible(true);
  38.         //设置背景图片
  39.         ImageIcon img = new ImageIcon("C:\\Users\\god36c\\OneDrive\\桌面\\图十一.jpg");
  40.         JLabel bgimg = new JLabel(img);
  41.         bgimg.setBounds(0,0,img.getIconWidth(),img.getIconHeight());
  42.         bgimg.setOpaque(false);//背景照片透明
  43.         //设置背景图片
  44.         ImageIcon img1 = new ImageIcon("C:\\Users\\god36c\\OneDrive\\桌面\\图十二.jpg");
  45.         JLabel bgimg1 = new JLabel(img1);
  46.         bgimg1.setBounds(0,0,img1.getIconWidth(),img1.getIconHeight());
  47.         bgimg1.setOpaque(false);//背景照片透明
  48.         //生成A窗体中的各种组件
  49.         A.setLayout(null);//自由布局
  50.         JButton component1=new JButton("添加");component1.setBounds(20, 30, 70, 30);
  51.         JButton component2=new JButton("修改");component2.setBounds(105, 30, 70, 30);
  52.         JButton component3=new JButton("删除");component3.setBounds(20, 100, 70, 30);
  53.         JButton component4=new JButton("退出");component4.setBounds(105, 100, 70, 30);//增删改退按钮
  54.         JLabel component5=new JLabel("请输入学号:");component5.setBounds(395, 30, 100, 25);
  55.         JTextField component6=new JTextField(20);component6.setBounds(500, 30, 200, 25);//后面的输入框
  56.         JButton component7=new JButton("查询");component7.setBounds(715, 27, 80, 50);//查询按钮
  57.         JButton component8=new JButton("全 部 信 息 展 示");component8.setBounds(460, 85, 230, 50);
  58.         component1.setContentAreaFilled(false);component2.setContentAreaFilled(false);
  59.         component3.setContentAreaFilled(false);component4.setContentAreaFilled(false);
  60.         component7.setContentAreaFilled(false);component8.setContentAreaFilled(false);
  61.         //把所有组件加入窗体对象中去
  62.         A.add(component1);A.add(component2);A.add(component3);
  63.         A.add(component4);A.add(component5);A.add(component6);
  64.         A.add(component7);A.add(component8);A.add(bgimg);
  65.         //四个表格
  66.         String[][] datas = {};
  67.         String[] titles = { "学号", "姓名","性别","年龄","专业" };
  68.         String[][] datas1 = {};
  69.         String[] titles1 = { "课程号", "课程名","学分"};
  70.         String[][] datas2 = {};
  71.         String[] titles2 = { "学号", "课程号","成绩","等级"};
  72.         String[][] datas3 = {};
  73.         String[] titles3 = { "账号", "密码","学号","电话号码"};
  74.         DefaultTableModel myModel  = new DefaultTableModel(datas, titles);// myModel存放表格的数据
  75.         DefaultTableModel myModel1 = new DefaultTableModel(datas1, titles1);
  76.         DefaultTableModel myModel2 = new DefaultTableModel(datas2, titles2);
  77.         DefaultTableModel myModel3 = new DefaultTableModel(datas3, titles3);
  78.         JTable table  = new JTable(myModel);table.setPreferredScrollableViewportSize(new Dimension(700, 100));// 表格的显示尺寸// 表格对象table的数据来源是myModel对象
  79.         JTable table1 = new JTable(myModel1);table1.setPreferredScrollableViewportSize(new Dimension(700, 100));
  80.         JTable table2 = new JTable(myModel2);table2.setPreferredScrollableViewportSize(new Dimension(700, 100));
  81.         JTable table3 = new JTable(myModel3);table3.setPreferredScrollableViewportSize(new Dimension(700, 100));
  82.         // 产生一个带滚动条的面板
  83.         JScrollPane scrollPane = new JScrollPane(table);scrollPane.setBounds(170, 110, 700, 100);
  84.         JScrollPane scrollPane1 = new JScrollPane(table1);scrollPane1.setBounds(170, 220, 700, 100);
  85.         JScrollPane scrollPane2 = new JScrollPane(table2);scrollPane2.setBounds(170, 330, 700, 100);
  86.         JScrollPane scrollPane3 = new JScrollPane(table3);scrollPane3.setBounds(170, 0, 700, 100);
  87.         // 将带滚动条的面板添加入B窗口中
  88.         B.setLayout(null);//自由布局
  89.         B.add(scrollPane);B.add(scrollPane1);B.add(scrollPane2);
  90.         B.add(scrollPane3);B.add(bgimg1);
  91.  
  92.         component1.addActionListener(new ActionListener(){
  93.             public void actionPerformed(ActionEvent e)
  94.             {
  95.                 new Add();
  96.             }
  97.         });
  98.         component2.addActionListener(new ActionListener(){
  99.             public void actionPerformed(ActionEvent e)
  100.             {
  101.                 new Update();
  102.             }
  103.         });
  104.         component3.addActionListener(new ActionListener(){
  105.             public void actionPerformed(ActionEvent e)
  106.             {
  107.                 new Delete();
  108.             }
  109.         });
  110.         component4.addActionListener(new ActionListener(){
  111.             public void actionPerformed(ActionEvent e) {
  112.                 new Glogin();
  113.                 closeThis();
  114.             }
  115.         });
  116.         component7.addActionListener(new ActionListener(){
  117.             public void actionPerformed(ActionEvent e) {
  118.                 try {
  119.                     Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  120.                     //加载对应的jdbc驱动
  121.                     String url="jdbc:sqlserver://localhost:1433;DatabaseName=高校学生管理库";
  122.                     //配置连接字符串
  123.                     String user="sa";//sa超级管理员
  124.                     String password="你的密码";//密码
  125.                     Connection conn=DriverManager.getConnection(url,user,password);
  126.                     //创建数据库连接对象
  127.                     Statement st=conn.createStatement();
  128.                     //创建SQL语句执行对象
  129.                     while(myModel.getRowCount()>0) {
  130.                         myModel.removeRow(myModel.getRowCount()-1);
  131.                     }
  132.                     while(myModel1.getRowCount()>0) {
  133.                         myModel1.removeRow(myModel1.getRowCount()-1);
  134.                     }
  135.                     while(myModel2.getRowCount()>0) {
  136.                         myModel2.removeRow(myModel2.getRowCount()-1);
  137.                     }
  138.                     while(myModel3.getRowCount()>0) {
  139.                         myModel3.removeRow(myModel3.getRowCount()-1);
  140.                     }//清空表上的东西
  141.                     String ID=component6.getText().trim();
  142.                     String  s="(Select * from dbo.Student,dbo.PY where Student.Sno='"+ID+"' And Student.Sno=PY.Sno)";
  143.                     ResultSet r=st.executeQuery(s);
  144.                     while(r.next()) {
  145.                         Vector<String> ve = new Vector<String>();
  146.                         ve.addElement(r.getString(1));ve.addElement(r.getString(2));
  147.                         ve.addElement(r.getString(3));ve.addElement(r.getString(4));
  148.                         ve.addElement(r.getString(5));
  149.                         myModel.addRow(ve);
  150.                         Vector<String> ve1 = new Vector<String>();
  151.                         ve1.addElement(r.getString(6));ve1.addElement(r.getString(7));
  152.                         ve1.addElement(r.getString(8));ve1.addElement(r.getString(9));
  153.                         myModel3.addRow(ve1);
  154.                     }
  155.                     String  s1="(Select * from dbo.SC,dbo.Course where Sno='"+ID+"' And SC.Cno=Course.Cno)";
  156.                     ResultSet r1=st.executeQuery(s1);
  157.                     while(r1.next()) {
  158.                         Vector<String> ve1 = new Vector<String>();
  159.                         ve1.addElement(r1.getString(1));ve1.addElement(r1.getString(2));
  160.                         ve1.addElement(r1.getString(3));ve1.addElement(r1.getString(4));
  161.                         myModel2.addRow(ve1);
  162.                         Vector<String> ve2 = new Vector<String>();
  163.                         ve2.addElement(r1.getString(5));ve2.addElement(r1.getString(6));
  164.                         ve2.addElement(r1.getString(8));
  165.                         myModel1.addRow(ve2);
  166.                     }
  167.                     conn.close();
  168.                 }catch (ClassNotFoundException ex) {
  169.                     System.out.println("没有找到对应的数据库驱动类");
  170.                 }
  171.                 catch (SQLException ex) {
  172.                     System.out.println("数据库连接或者是数据库操作失败");
  173.                 }
  174.             }
  175.         });
  176.         component8.addActionListener(new ActionListener(){
  177.             public void actionPerformed(ActionEvent e) {
  178.                 try {
  179.                     Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  180.                     //加载对应的jdbc驱动
  181.                     String url="jdbc:sqlserver://localhost:1433;DatabaseName=高校学生管理库";
  182.                     //配置连接字符串
  183.                     String user="sa";//sa超级管理员
  184.                     String password="你的密码";//密码
  185.                     Connection conn=DriverManager.getConnection(url,user,password);
  186.                     //创建数据库连接对象
  187.                     Statement st=conn.createStatement();
  188.                     //创建SQL语句执行对象
  189.                     while(myModel.getRowCount()>0) {
  190.                         myModel.removeRow(myModel.getRowCount()-1);
  191.                     }
  192.                     while(myModel1.getRowCount()>0) {
  193.                         myModel1.removeRow(myModel1.getRowCount()-1);
  194.                     }
  195.                     while(myModel2.getRowCount()>0) {
  196.                         myModel2.removeRow(myModel2.getRowCount()-1);
  197.                     }
  198.                     while(myModel3.getRowCount()>0) {
  199.                         myModel3.removeRow(myModel3.getRowCount()-1);
  200.                     }
  201.                     String  strSQL="(Select * from  dbo.Student)";
  202.                     ResultSet rs=st.executeQuery(strSQL);
  203.                     while(rs.next()) {
  204.                         Vector<String> v = new Vector<String>();
  205.                         v.addElement(rs.getString(1));v.addElement(rs.getString(2));
  206.                         v.addElement(rs.getString(3));v.addElement(rs.getString(4));
  207.                         v.addElement(rs.getString(5));
  208.                         myModel.addRow(v);
  209.                     }
  210.                     String  strSQL1="(Select * from  dbo.Course)";
  211.                     ResultSet rs1=st.executeQuery(strSQL1);
  212.                     while(rs1.next()) {
  213.                         Vector<String> v1 = new Vector<String>();
  214.                         v1.addElement(rs1.getString(1));v1.addElement(rs1.getString(2));
  215.                         v1.addElement(rs1.getString(4));
  216.                         myModel1.addRow(v1);
  217.                     }
  218.                     String  strSQL2="(Select * from  dbo.SC)";
  219.                     ResultSet rs2=st.executeQuery(strSQL2);
  220.                     while(rs2.next()) {
  221.                         Vector<String> v2 = new Vector<String>();
  222.                         v2.addElement(rs2.getString(1));v2.addElement(rs2.getString(2));
  223.                         v2.addElement(rs2.getString(3));v2.addElement(rs2.getString(4));
  224.                         myModel2.addRow(v2);
  225.                     }
  226.                     String  strSQL3="(Select * from  dbo.PY)";
  227.                     ResultSet rs3=st.executeQuery(strSQL3);
  228.                     while(rs3.next()) {
  229.                         Vector<String> v3 = new Vector<String>();
  230.                         v3.addElement(rs3.getString(1));v3.addElement(rs3.getString(2));
  231.                         v3.addElement(rs3.getString(3));v3.addElement(rs3.getString(4));
  232.                         myModel3.addRow(v3);
  233.                     }
  234.                     conn.close();
  235.                 }catch (ClassNotFoundException ex) {
  236.                     System.out.println("没有找到对应的数据库驱动类");
  237.                 }
  238.                 catch (SQLException ex) {
  239.                     System.out.println("数据库连接或者是数据库操作失败");
  240.                 }
  241.             }
  242.         });
  243.     }
  244.     public  void closeThis() {
  245.         this.dispose();
  246.     }
  247. }

4ee5d45f500645ad99d7bdb890196312.png

 增删改（Add,Update,Delete）:

对于增删改这三部分的内容的话，其实还是比较简单的，所以，再次就不多说了，自己可以好好看看你，很容易理解！！

Add源代码：

  1. package 高校学生管理库;
  2.  
  3. import java.awt.*;
  4. import java.awt.event.ActionEvent;
  5. import java.awt.event.ActionListener;
  6. import java.sql.Connection;
  7. import java.sql.DriverManager;
  8. import java.sql.ResultSet;
  9. import java.sql.SQLException;
  10. import java.sql.Statement;
  11.  
  12. import javax.swing.*;
  13.  
  14. public class Add extends JFrame{
  15.     private static final long serialVersionUID = 1L;
  16.     final int WIDTH = 550;
  17.     final int HEIGHT = 315;
  18.     public Add() {
  19.         super("添加信息");
  20.         setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
  21.         this.setSize(1020,700);
  22.         this.setLocationRelativeTo(null);
  23.         setVisible(true);
  24.  
  25.         //初始化字体
  26.         font fonts = new font();
  27.         //设置背景图片
  28.         ImageIcon img = new ImageIcon("C:\\Users\\god36c\\OneDrive\\桌面\\图四.jpg");
  29.         JLabel bgimg = new JLabel(img);
  30.         bgimg.setBounds(0,0,img.getIconWidth(),img.getIconHeight());
  31.         bgimg.setOpaque(false);//背景照片透明
  32.         //给盘子1创建对象
  33.         javax.swing.JPanel jpanel_1 = new javax.swing.JPanel();
  34.         jpanel_1.setBounds(0,0,WIDTH,HEIGHT);
  35.         jpanel_1.setLayout(null);//设置布局为空
  36.         //给盘子2创建对象
  37.         javax.swing.JPanel jpanel_2 = new javax.swing.JPanel();
  38.         jpanel_2.setBounds(0,30,WIDTH,100);
  39.         FlowLayout flowLayout = new FlowLayout(FlowLayout.CENTER);
  40.         jpanel_2.setLayout(flowLayout);//设置布局为居中
  41.         jpanel_2.setOpaque(false);//设置盘子为透明
  42.         //给盘子3创建对象
  43.         javax.swing.JPanel jpanel_3 = new javax.swing.JPanel();
  44.         jpanel_3.setBounds(0,50,WIDTH,350);
  45.         jpanel_3.setLayout(null);//设置布局为空
  46.         jpanel_3.setOpaque(false);//设置盘子为透明
  47.  
  48.         JLabel title = new JLabel(" 添 加 界 面 ");
  49.         title.setFont(font.title);
  50.         title.setHorizontalAlignment(SwingConstants.CENTER);//居中
  51.  
  52.         JLabel j=new JLabel("学号:");JTextField c=new JTextField(15);//学号
  53.         j.setBounds(40, 30,  50, 20); c.setBounds(120, 30, 100, 25);
  54.         JLabel j1=new JLabel("姓名:");JTextField c1=new JTextField(15);//姓名
  55.         j1.setBounds(40, 70, 50, 20);c1.setBounds(120, 70, 100, 25);
  56.         JLabel j2=new JLabel("性别:");JTextField c2=new JTextField(15);//性别
  57.         j2.setBounds(40, 110, 50, 30);c2.setBounds(120, 110, 100, 25);
  58.         JLabel j3=new JLabel("年龄:");JTextField c3=new JTextField(15);//年龄
  59.         j3.setBounds(40, 150, 50, 30);c3.setBounds(120, 150, 100, 25);
  60.         JLabel j4=new JLabel("专业:");JTextField c4=new JTextField(15);//专业
  61.         j4.setBounds(40, 190, 50, 30);c4.setBounds(120, 190, 100, 25);
  62.         JLabel j5=new JLabel("课程:");JTextField c5=new JTextField(15);//课程
  63.         j5.setBounds(40, 230, 50, 30);c5.setBounds(120, 230, 100, 25);
  64.         JLabel j6=new JLabel("成绩:");JTextField c6=new JTextField(15);//成绩
  65.         j6.setBounds(40, 270, 50, 30);c6.setBounds(120, 270, 100, 25);
  66.         JLabel j7=new JLabel("等级:");JTextField c7=new JTextField(15);//等级
  67.         j7.setBounds(40, 310, 50, 30); c7.setBounds(120, 310, 100, 25);
  68.         JLabel j8=new JLabel("(温馨提醒：添加学生信息学号必填哦~，右边一列为课程信息)");j8.setBounds(10, 600, 500, 30);
  69.         JLabel j11=new JLabel("课程号:");JTextField c11=new JTextField(15);//课程号
  70.         j11.setBounds(300, 120, 70, 30); c11.setBounds(380, 120, 100, 25);
  71.         JLabel j12=new JLabel("课程名:");JTextField c12=new JTextField(15);//课程名
  72.         j12.setBounds(300, 170, 70, 30); c12.setBounds(380, 170, 100, 25);
  73.         JLabel j13=new JLabel("学分:");JTextField c13=new JTextField(15);//学分
  74.         j13.setBounds(300, 230, 70, 30); c13.setBounds(380, 230, 100, 25);
  75.  
  76.         JButton a=new JButton("确定");
  77.         a.setContentAreaFilled(false);
  78.         a.setBounds(100, 400, 100, 30);
  79.         JButton b=new JButton("重置");
  80.         b.setContentAreaFilled(false);
  81.         b.setBounds(300, 400, 100, 30);
  82.  
  83.         jpanel_3.add(j);  jpanel_3.add(j1); jpanel_3.add(j2);
  84.         jpanel_3.add(j3); jpanel_3.add(j4); jpanel_3.add(j5);
  85.         jpanel_3.add(j6); jpanel_3.add(j7); jpanel_3.add(j11);
  86.         jpanel_3.add(j12);jpanel_3.add(j13);jpanel_1.add(j8);
  87.         jpanel_3.add(c);jpanel_3.add(c1); jpanel_3.add(c2);
  88.         jpanel_3.add(c3);jpanel_3.add(c4); jpanel_3.add(c5);
  89.         jpanel_3.add(c6);jpanel_3.add(c7);jpanel_3.add(c11);
  90.         jpanel_3.add(c12);jpanel_3.add(c13);jpanel_1.add(a);
  91.         jpanel_1.add(b);this.add(jpanel_3);jpanel_2.add(title);
  92.         this.add(jpanel_2);jpanel_1.add(bgimg);this.add(jpanel_1);
  93.  
  94.         a.addActionListener(new ActionListener(){
  95.             public void actionPerformed(ActionEvent e) {
  96.                 try {
  97.                     Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  98.                     //加载对应的jdbc驱动
  99.                     String url="jdbc:sqlserver://localhost:1433;DatabaseName=高校学生管理库";
  100.                     //配置连接字符串
  101.                     String user="sa";//sa超级管理员
  102.                     String password="你的密码";//密码
  103.                     Connection conn=DriverManager.getConnection(url,user,password);
  104.                     Statement st=conn.createStatement();
  105.  
  106.                     String a=c.getText().trim();    String a1=c1.getText().trim();
  107.                     String a2=c3.getText().trim();  String a3=c5.getText().trim();
  108.                     String a4=c6.getText().trim();  String a11=c11.getText().trim();
  109.                     String a12=c12.getText().trim();String a13=c13.getText().trim();
  110.                     String a5=c2.getText().trim();  String a6=c4.getText().trim();
  111.                     String a7=c7.getText().trim();
  112.  
  113.                     String  s="(Select * from dbo.Student where Sno='"+a+"')";
  114.                     ResultSet r=st.executeQuery(s);
  115.                     if(r.next()) {
  116.                         JOptionPane.showMessageDialog(null, "该同学已存在哦~","提示消息",JOptionPane.WARNING_MESSAGE);
  117.                     }
  118.                     else {
  119.                         if(a.equals("")) {
  120.                             String  s3="insert into dbo.Course(Cno,Cname,Ccredit) values('"+a11+"','"+a12+"','"+a13+"')";
  121.                             int r3=st.executeUpdate(s3);
  122.                             if(r3==1) {
  123.                                 JOptionPane.showMessageDialog(null, "添加成功","提示消息",JOptionPane.WARNING_MESSAGE);
  124.                             }
  125.                         }
  126.                         else {
  127.                             String  s1="insert into dbo.Student(Sno,Sname,Ssex,Sage,Sdept) values('"+a+"','"+a1+"','"+a5+"','"+a2+"','"+a6+"')";
  128.                             int r1=st.executeUpdate(s1);
  129.                             String  s2="insert into dbo.SC(Sno,Cno,Grade,LEVEL) values('"+a+"','"+a3+"','"+a4+"','"+a7+"')";
  130.                             int r2=st.executeUpdate(s2);
  131.                             if(r1==1&&r2==1) {
  132.                                 JOptionPane.showMessageDialog(null, "添加成功","提示消息",JOptionPane.WARNING_MESSAGE);
  133.                             }
  134.                         }
  135.                     }
  136.                     conn.close();
  137.                 }catch (ClassNotFoundException ex) {
  138.                     System.out.println("没有找到对应的数据库驱动类");
  139.                 }
  140.                 catch (SQLException ex) {
  141.                     System.out.println("数据库连接或者是数据库操作失败");
  142.                 }
  143.             }
  144.         });
  145.         b.addActionListener(new ActionListener(){//重置清零
  146.             public void actionPerformed(ActionEvent e) {
  147.                 c.setText("");c1.setText("");c2.setText("");
  148.                 c3.setText("");c4.setText("");c5.setText("");
  149.                 c6.setText("");c11.setText("");c12.setText("");
  150.                 c13.setText("");
  151.             }
  152.         });
  153.     }
  154. }

5630e8e67903422abe5e04c102e4426e.png

 Delete源代码：

  1. package 高校学生管理库;
  2.  
  3. import java.awt.*;
  4. import java.awt.event.ActionEvent;
  5. import java.awt.event.ActionListener;
  6. import java.sql.Connection;
  7. import java.sql.DriverManager;
  8. import java.sql.ResultSet;
  9. import java.sql.SQLException;
  10. import java.sql.Statement;
  11.  
  12. import javax.swing.*;
  13.  
  14. public class Delete extends JFrame{
  15.     private static final long serialVersionUID = 1L;
  16.     final int WIDTH = 500;
  17.     final int HEIGHT = 315;
  18.     public Delete() {
  19.         super("删除信息");
  20.         setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
  21.         this.setSize(1020,700);
  22.         this.setLocationRelativeTo(null);
  23.         setVisible(true);
  24.  
  25.         //初始化字体
  26.         font fonts = new font();
  27.         //设置背景图片
  28.         ImageIcon img = new ImageIcon("C:\\Users\\god36c\\OneDrive\\桌面\\图五.jpg");
  29.         JLabel bgimg = new JLabel(img);
  30.         bgimg.setBounds(0,0,img.getIconWidth(),img.getIconHeight());
  31.         bgimg.setOpaque(false);//将面板设置为透明
  32.         //给盘子1创建对象
  33.         javax.swing.JPanel jpanel_1 = new javax.swing.JPanel();
  34.         jpanel_1.setBounds(0,0,WIDTH,HEIGHT);
  35.         jpanel_1.setLayout(null);//设置布局为空
  36.         jpanel_1.setOpaque(false);
  37.         //给盘子2创建对象
  38.         javax.swing.JPanel jpanel_2 = new javax.swing.JPanel();
  39.         jpanel_2.setBounds(0,30,WIDTH,100);
  40.         FlowLayout flowLayout = new FlowLayout(FlowLayout.CENTER);
  41.         jpanel_2.setLayout(flowLayout);//设置布局为居中
  42.         jpanel_2.setOpaque(false);//设置盘子为透明
  43.         //给盘子3创建对象
  44.         javax.swing.JPanel jpanel_3 = new javax.swing.JPanel();
  45.         jpanel_3.setBounds(0,50,WIDTH,350);
  46.         jpanel_3.setLayout(null);//设置布局为空
  47.         jpanel_3.setOpaque(false);//设置盘子为透明
  48.  
  49.         JLabel title = new JLabel(" 删 除 界 面 ");
  50.         title.setFont(font.title);
  51.         title.setHorizontalAlignment(SwingConstants.CENTER);//居中
  52.  
  53.         JCheckBox optionA=new JCheckBox(" 姓名");optionA.setBounds(80, 70, 150, 20);
  54.         JCheckBox optionB=new JCheckBox(" 性别");optionB.setBounds(80, 120, 150, 20);
  55.         JCheckBox optionC=new JCheckBox(" 年龄");optionC.setBounds(80, 170, 150, 20);
  56.         JCheckBox optionD=new JCheckBox(" 专业");optionD.setBounds(80, 220, 150, 20);
  57.         JCheckBox optionE=new JCheckBox(" 成绩");optionE.setBounds(80, 320, 150, 20);
  58.         JCheckBox optionF=new JCheckBox(" 等级");optionF.setBounds(80, 370, 150, 20);
  59.         optionA.setContentAreaFilled(false);optionB.setContentAreaFilled(false);
  60.         optionC.setContentAreaFilled(false);optionD.setContentAreaFilled(false);
  61.         optionE.setContentAreaFilled(false);optionF.setContentAreaFilled(false);
  62.         JLabel j=new JLabel("学号:");j.setBounds(30, 20,  50, 20);
  63.         JLabel  j1=new JLabel("(温馨提醒：谨慎删除哦~)");j1.setBounds(10, 600, 450, 15);
  64.         JLabel j11=new JLabel("课程号:");j11.setBounds(300, 150,  70, 30);
  65.         JLabel j12=new JLabel("课程名:");j12.setBounds(300, 250,  70, 30);
  66.         JLabel cc=new JLabel("课程号:");cc.setBounds(20, 270, 70, 20);
  67.         JTextField c=new JTextField(12);c.setBounds(90, 270, 150, 25);
  68.         JTextField c1=new JTextField(12);c1.setBounds(90, 20, 150, 25);
  69.         JTextField c11=new JTextField(10);c11.setBounds(380, 150, 100, 25);
  70.         JTextField c12=new JTextField(10);c12.setBounds(380, 250, 100, 25);
  71.  
  72.         JButton a=new JButton("确定");a.setBounds(100, 400, 100, 30);
  73.         a.setContentAreaFilled(false);
  74.         JButton b=new JButton("重置");b.setBounds(300, 400, 100, 30);
  75.         b.setContentAreaFilled(false);
  76.  
  77.         jpanel_1.add(a);jpanel_1.add(b);jpanel_3.add(j11);
  78.         jpanel_3.add(c);jpanel_3.add(cc); jpanel_3.add(c12); jpanel_1.add(j1);
  79.         jpanel_3.add(j);jpanel_3.add(c1);jpanel_3.add(c11); jpanel_3.add(j12);
  80.         jpanel_3.add(optionA);jpanel_3.add(optionB);jpanel_3.add(optionC);
  81.         jpanel_3.add(optionD);jpanel_3.add(optionE);jpanel_3.add(optionF);
  82.         this.add(jpanel_3);jpanel_2.add(title);this.add(jpanel_2);
  83.         jpanel_1.add(bgimg);this.add(jpanel_1);
  84.  
  85.         a.addActionListener(new ActionListener(){
  86.             public void actionPerformed(ActionEvent e) {
  87.                 try {
  88.                     Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  89.                     //加载对应的jdbc驱动
  90.                     String url="jdbc:sqlserver://localhost:1433;DatabaseName=高校学生管理库";
  91.                     //配置连接字符串
  92.                     String user="sa";//sa超级管理员
  93.                     String password="你的密码";//密码
  94.                     Connection conn=DriverManager.getConnection(url,user,password);
  95.                     //创建数据库连接对象
  96.                     Statement st=conn.createStatement();
  97.                     //创建SQL语句执行对象
  98.                     String a=c1.getText().trim();
  99.                     String a1=c.getText().trim();
  100.                     String  s="(Select * from dbo.Student where Sno='"+a+"')";
  101.                     ResultSet r=st.executeQuery(s);
  102.                     if(r.next()) {
  103.                         if(optionA.isSelected()) {
  104.                             String strSQL="update dbo.Student set Sname="+null+" where Sno='"+a+"'";
  105.                             st.executeUpdate(strSQL);
  106.                         }
  107.                         if(optionB.isSelected()) {
  108.                             String strSQL="update dbo.Student set Ssex="+null+" where Sno='"+a+"'";
  109.                             st.executeUpdate(strSQL);
  110.                         }
  111.                         if(optionC.isSelected()) {
  112.                             String strSQL="update dbo.Student set Sage="+null+" where Sno='"+a+"'";
  113.                             st.executeUpdate(strSQL);
  114.                         }
  115.                         if(optionD.isSelected()) {
  116.                             String strSQL="update dbo.Student set Sdept="+null+" where Sno='"+a+"'";
  117.                             st.executeUpdate(strSQL);
  118.                         }
  119.                         if(optionE.isSelected()) {
  120.                             String strSQL="update dbo.SC set Grade="+null+" where Sno='"+a+"' And Cno='"+a1+"'";
  121.                             st.executeUpdate(strSQL);
  122.                         }
  123.                         if(optionF.isSelected()) {
  124.                             String strSQL="update dbo.SC set LEVEL="+null+" where Sno='"+a+"' And Cno='"+a1+"'";
  125.                             st.executeUpdate(strSQL);
  126.                         }
  127.                         JOptionPane.showMessageDialog(null,"删除成功哦~");
  128.                     }
  129.                     else {
  130.                         String cc=c11.getText().trim();
  131.                         String strSQL="delete from dbo.Course where Cno='"+cc+"' ";
  132.                         int rr=st.executeUpdate(strSQL);
  133.                         if(rr==1) {
  134.                             JOptionPane.showMessageDialog(null,"删除成功哦~");
  135.                         }
  136.                         else {
  137.                             JOptionPane.showMessageDialog(null,"课程不存在哦~");
  138.                         }
  139.                     }
  140.                     conn.close();
  141.                 }catch (ClassNotFoundException ex) {
  142.                     System.out.println("没有找到对应的数据库驱动类");
  143.                 }
  144.                 catch (SQLException ex) {
  145.                     System.out.println("数据库连接或者是数据库操作失败");
  146.                 }
  147.             }
  148.         });
  149.         b.addActionListener(new ActionListener(){//重置清零
  150.             public void actionPerformed(ActionEvent e) {
  151.                 c1.setText("");c11.setText("");c12.setText("");
  152.                 optionA.setSelected(false);optionB.setSelected(false);optionC.setSelected(false);
  153.                 optionD.setSelected(false);optionE.setSelected(false);optionF.setSelected(false);
  154.             }
  155.         });
  156.     }
  157. }

da9edeb3ef404cf5a060c396eaec6797.png

Update源代码：

  1. package 高校学生管理库;
  2.  
  3. import java.awt.*;
  4. import java.awt.event.ActionEvent;
  5. import java.awt.event.ActionListener;
  6. import java.sql.Connection;
  7. import java.sql.DriverManager;
  8. import java.sql.ResultSet;
  9. import java.sql.SQLException;
  10. import java.sql.Statement;
  11.  
  12. import javax.swing.*;
  13.  
  14. public class Update extends JFrame{
  15.     private static final long serialVersionUID = 1L;
  16.     final int WIDTH = 550;
  17.     final int HEIGHT = 315;
  18.     public Update() {
  19.         super("修改信息");
  20.         setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
  21.         this.setSize(1020,700);
  22.         this.setLocationRelativeTo(null);
  23.         setVisible(true);
  24.  
  25.         //初始化字体
  26.         font fonts = new font();
  27.         //设置背景图片
  28.         ImageIcon img = new ImageIcon("C:\\Users\\god36c\\OneDrive\\桌面\\图六.jpg");
  29.         JLabel bgimg = new JLabel(img);
  30.         bgimg.setBounds(0,0,img.getIconWidth(),img.getIconHeight());
  31.         bgimg.setOpaque(false);//将面板设置为透明
  32.         //给盘子1创建对象
  33.         javax.swing.JPanel jpanel_1 = new javax.swing.JPanel();
  34.         jpanel_1.setBounds(0,0,WIDTH,HEIGHT);
  35.         jpanel_1.setLayout(null);//设置布局为空
  36.         jpanel_1.setOpaque(false);//设置盘子为透明
  37.         //给盘子2创建对象
  38.         javax.swing.JPanel jpanel_2 = new javax.swing.JPanel();
  39.         jpanel_2.setBounds(0,30,WIDTH,100);
  40.         FlowLayout flowLayout = new FlowLayout(FlowLayout.CENTER);
  41.         jpanel_2.setLayout(flowLayout);//设置布局为居中
  42.         jpanel_2.setOpaque(false);//设置盘子为透明
  43.         //给盘子3创建对象
  44.         javax.swing.JPanel jpanel_3 = new javax.swing.JPanel();
  45.         jpanel_3.setBounds(0,50,WIDTH,350);
  46.         jpanel_3.setLayout(null);//设置布局为空
  47.         jpanel_3.setOpaque(false);//设置盘子为透明
  48.  
  49.         JLabel title = new JLabel(" 修 改 界 面 ");
  50.         title.setFont(font.title);
  51.         title.setHorizontalAlignment(SwingConstants.CENTER);//居中
  52.  
  53.         JLabel j=new JLabel("学号:");j.setBounds(20, 30,  50, 20);
  54.         JTextField c=new JTextField(15);c.setBounds(80, 30, 120, 25);//学号
  55.         JLabel j1=new JLabel("姓名:");j1.setBounds(20, 70, 50, 20);
  56.         JTextField c1=new JTextField(15);c1.setBounds(80, 70, 100, 25);//姓名
  57.         JLabel j2=new JLabel("性别:");j2.setBounds(20, 110, 50, 30);
  58.         JTextField c2=new JTextField(15);c2.setBounds(80, 110, 100, 25);//性别
  59.         JLabel j3=new JLabel("年龄:");j3.setBounds(20, 150, 50, 30);
  60.         JTextField c3=new JTextField(15);c3.setBounds(80, 150, 100, 25);//年龄
  61.         JLabel j4=new JLabel("专业:");j4.setBounds(20, 190, 50, 30);
  62.         JTextField c4=new JTextField(15);c4.setBounds(80, 190, 100, 25);//专业
  63.         JLabel j5=new JLabel("课程:");j5.setBounds(20, 230, 50, 30);
  64.         JTextField c5=new JTextField(20);c5.setBounds(80, 230, 100, 25);//课程
  65.         JLabel j6=new JLabel("成绩:");j6.setBounds(20, 270, 50, 30);
  66.         JTextField c6=new JTextField(20);c6.setBounds(80, 270, 100, 25);//成绩
  67.         JLabel j7=new JLabel("等级:");j7.setBounds(20, 310, 50, 30);
  68.         JTextField c7=new JTextField(15);c7.setBounds(80, 310, 100, 25);//等级
  69.         JLabel j00=new JLabel("旧课程号:");j00.setBounds(290, 100, 90, 30);
  70.         JTextField c00=new JTextField(15);c00.setBounds(380, 100, 100, 25);//旧课程号
  71.         JLabel j11=new JLabel("新课程号:");j11.setBounds(290, 150, 90, 30);
  72.         JTextField c11=new JTextField(15);c11.setBounds(380, 150, 100, 25);//新课程号
  73.         JLabel j12=new JLabel("新课程名:");j12.setBounds(290, 200, 90, 30);
  74.         JTextField c12=new JTextField(15);c12.setBounds(380, 200, 100, 25);//新课程名
  75.         JLabel j13=new JLabel("新学分:");j13.setBounds(300, 250, 90, 30);
  76.         JTextField c13=new JTextField(15);c13.setBounds(380, 250, 100, 25);//新学分
  77.         JLabel j8=new JLabel("(温馨提醒：更新学生信息学号必填哦~右边一列为课程信息)");j8.setBounds(10, 600, 500, 15);
  78.  
  79.         JButton aa=new JButton("确定");aa.setBounds(100, 400, 100, 30);
  80.         aa.setContentAreaFilled(false);
  81.         JButton bb=new JButton("重置");bb.setBounds(300, 400, 100, 30);
  82.         bb.setContentAreaFilled(false);
  83.  
  84.         jpanel_3.add(j); jpanel_3.add(j1);jpanel_3.add(j2);
  85.         jpanel_3.add(j3);jpanel_3.add(j4);jpanel_3.add(j5);
  86.         jpanel_3.add(j6);jpanel_3.add(j7);jpanel_3.add(j11);
  87.         jpanel_3.add(j12);jpanel_3.add(j13);jpanel_3.add(c11);
  88.         jpanel_3.add(c12);jpanel_3.add(c13);jpanel_3.add(c);
  89.         jpanel_3.add(c1); jpanel_3.add(c2); jpanel_3.add(c3);
  90.         jpanel_3.add(c4); jpanel_3.add(c5); jpanel_3.add(c6);
  91.         jpanel_3.add(c7); jpanel_1.add(aa); jpanel_1.add(bb);
  92.         jpanel_1.add(j8);jpanel_3.add(c00);jpanel_3.add(j00);
  93.         this.add(jpanel_3);jpanel_2.add(title);this.add(jpanel_2);
  94.         jpanel_1.add(bgimg);this.add(jpanel_1);
  95.  
  96.         aa.addActionListener(new ActionListener(){
  97.             public void actionPerformed(ActionEvent e) {
  98.                 try {
  99.                     Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  100.                     //加载对应的jdbc驱动
  101.                     String url="jdbc:sqlserver://localhost:1433;DatabaseName=高校学生管理库";
  102.                     //配置连接字符串
  103.                     String user="sa";//sa超级管理员
  104.                     String password="你的密码";//密码
  105.                     Connection conn=DriverManager.getConnection(url,user,password);
  106.                     Statement st=conn.createStatement();
  107.                     //修改过布局所以顺序有点乱=。=
  108.                     String a=c.getText().trim();String a1=c1.getText().trim();
  109.                     String a2=c3.getText().trim();String a3=c5.getText().trim();
  110.                     String a4=c6.getText().trim();String a11=c11.getText().trim();
  111.                     String a12=c12.getText().trim();String a13=c13.getText().trim();
  112.                     String a5=c2.getText().trim();String a6=c4.getText().trim();String a7=c7.getText().trim();
  113.                     String a00=c00.getText().trim();
  114.  
  115.                     String  s="(Select * from dbo.Student where Sno='"+a+"')";
  116.                     ResultSet r=st.executeQuery(s);
  117.                     if(r.next()) {
  118.                         if (!a1.isEmpty()) {
  119.                             String  strSQL="update dbo.Student set Sname='"+a1+"' where Sno='"+a+"'";
  120.                             st.executeUpdate(strSQL);
  121.                         }
  122.                         if (!a2.isEmpty()) {
  123.                             String  strSQL="update dbo.Student set Sage='"+a2+"' where Sno='"+a+"'";
  124.                             st.executeUpdate(strSQL);
  125.                         }
  126.                         if (!a5.isEmpty()) {
  127.                             String  strSQL="update dbo.Student set Ssex='"+a5+"' where Sno='"+a+"'";
  128.                             st.executeUpdate(strSQL);
  129.                         }
  130.                         if (!a6.isEmpty()) {
  131.                             String  strSQL="update dbo.Student set Sdept='"+a6+"' where Sno='"+a+"'";
  132.                             st.executeUpdate(strSQL);
  133.                         }
  134.                         if (!a3.isEmpty()) {
  135.                             String  strSQL="update dbo.SC set Grade='"+a4+"' where Sno='"+a+"' And Cno='"+a3+"'" ;
  136.                             String  strSQL1="update dbo.SC set LEVEL='"+a7+"' where Sno='"+a+"' And Cno='"+a3+"'" ;
  137.                             st.executeUpdate(strSQL);
  138.                             st.executeUpdate(strSQL1);
  139.                         }
  140.                         JOptionPane.showMessageDialog(null,"修改成功哦~");
  141.                     }
  142.                     else {
  143.                         String  strSQL="update dbo.Course set Cno='"+a11+"',Cname='"+a12+"',Ccredit='"+a13+"'  where Cno='"+a00+"'";
  144.                         int rs1=st.executeUpdate(strSQL);
  145.                         if(rs1==1) {
  146.                             JOptionPane.showMessageDialog(null,"修改成功哦~");
  147.                         }
  148.                     }
  149.                     conn.close();
  150.                 }catch (ClassNotFoundException ex) {
  151.                     System.out.println("没有找到对应的数据库驱动类");
  152.                 }
  153.                 catch (SQLException ex) {
  154.                     System.out.println("数据库连接或者是数据库操作失败");
  155.                 }
  156.             }
  157.         });
  158.         //重置清零
  159.         bb.addActionListener(new ActionListener(){
  160.             public void actionPerformed(ActionEvent e) {
  161.                 c.setText("");c1.setText("");c2.setText("");
  162.                 c3.setText("");c4.setText("");c5.setText("");
  163.                 c6.setText("");c11.setText("");c12.setText("");
  164.                 c13.setText("");
  165.             }
  166.         });
  167.     }
  168. }

246ca2e69ba24289bacebb31c90a174b.png

另外，对于这增删改的界面我单独设置了字体font类。

font类 :

  1. package 高校学生管理库;
  2.  
  3. import java.awt.Font;
  4.  
  5. public class font {
  6.     public static Font title;
  7.     public static Font account;
  8.     public font() {
  9.         title= new Font("宋体",Font.BOLD,30);
  10.         account = new Font("宋体",Font.BOLD,16);
  11.     }
  12. }

SQL语句：

还有用到的SQL语言：另外，管理员是需要自己设置的哦，你也可以去设置学生细腻

  1. --照片存放表
  2. create table image
  3.  (  Sno char(10), 
  4.     ima  varchar(50),
  5.  );
  6.  
  7.  --学生表
  8. create table Student
  9. (  Sno char(9) primary key, /*列级完整性约束条件,Sno是主码 */
  10.    Sname char(20) unique, /*Sname取唯一值 */
  11.    Ssex char(2),
  12.    Sage smallint,
  13.    Sdept char(20)
  14.  );
  15.  
  16.  --Course表
  17. create table Course
  18. (	Cno char(4) primary key,/* 列级完整性约束条件,Cno是主码*/
  19. 	Cname char(40) NOT NULL, /* 列级完整性约束条件,Cname不能取空值 */
  20. 	Cpno char(4),/* Cpno的含义是先修课 */
  21. 	Ccredit int,
  22. 	foreign key(Cpno) references Course(Cno) /*表级完整性约束条件，Cpno是外码，被参照表是Course，被参照列是Cno */
  23. );
  24.  
  25. --信息表
  26. create table SC
  27. (	Sno char(9),
  28. 	Cno char(4),
  29. 	Grade int,
  30. 	LEVEL char(4),
  31. 	primary key(Sno,Cno),/*主码由两个属性构成，必须作为表级完整性进行定义 */
  32. 	foreign key(Sno) references Student(Sno), /*表级完整性约束条件，Sno是外码，被参照表是Student */
  33. 	foreign key(Cno) references Course(Cno)/*表级完整性约束条件，Cno是外码，被参照表是Course */
  34. );
  35.  
  36. --管理员表
  37. create table GLY(
  38. 	ID1 varchar(30),
  39. 	PAWD1 varchar(50)--密码
  40. );
  41.  
  42. --学生注册表
  43. create table PY(
  44. 	ID varchar(30),
  45. 	PAWD varchar(50),
  46. 	Sno char(9),
  47. 	phone  char(20)
  48. );
  49.  
  50. --学生信息
  51.  
  52. --管理员
  53.  
  54.  
  55. --插入Course数据
  56. insert into Course values('1','数据库',null,4)
  57. insert into Course values('2','高等数学A',null,2)
  58. insert into Course values('3','信息系统',null,4)
  59. insert into Course values('4','操作系统',null,3)
  60. insert into Course values('5','数据结构','5',4)
  61. insert into Course values('6','计算机网络','5',4)
  62. insert into Course values('7','离散数学','5',2)
  63. insert into Course values('8','大学英语','5',4)
  64. insert into Course values('9','计算机组成原理','5',3)
  65. insert into Course values('10','算法设计与分析','5',4)
  66. insert into Course values('11','大学物理A',null,4)
  67. insert into Course values('12','高等数学B',null,2)
  68. insert into Course values('13','大学物理B',null,4)
  69. insert into Course values('14','计算机英语',null,3)
  70. insert into Course values('15','算法导论','5',4)
  71. insert into Course values('16','数据库原理与分析','5',4)
  72. insert into Course values('17','数据挖掘','5',2)
  73. insert into Course values('18','移动应用开发','5',4)
  74. insert into Course values('19','Javaweb开发应用','5',3)
  75.  
  76. --课程等级

所需要用到的照片：

图一：

13d43d4d7cc34689be803aba18ece4fd.jpeg

图二：

 62520652936942d5b977e2d587dd1dae.jpeg

图三：

b6062c5da1b44951b513cd9e0ec66803.jpeg

图四：

df447c02029b4ff5ae83090e7a5c60a9.jpeg

 图五：

6c0a4cb215ed46d38b0e530f0ae32146.jpeg

图六：

7f8cfbe1ae3b405ca5691fe799f77f15.jpeg

图七：

46ede8ccb0e548118016a57b16c5c15f.jpeg

 图八：

22c4416170164e6287e665d2c1bb7841.jpeg

图九：

9288679a7d704d0cac253940d876d0b2.jpeg

 图十：

daf566bcc81d4a4b8b365e46d2698649.jpeg

图十一：

0bf09297d1784b6aac965cf30182a62c.jpeg

图十二：

5006e6bc22484d998baf6980911e6567.jpeg

 

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/运维做开发/article/detail/871796
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号