《学生选课系统(连接Mysql数据库)》由会员分享，可在线阅读，更多相关《学生选课系统(连接Mysql数据库)（18页珍藏版）》请在金锄头文库上搜索。
1、/*JDBC连接数据库*/package immoc4.bao;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class JDBC private static final String URL = jdbc:mysql:/localhost:3306/a?characterEncoding=utf8;private static final Strin
2、g USER = root;private static final String PASSWORD = 995923;private static Connection conn = null;static try Class.forName(com.mysql.jdbc.Driver);conn = DriverManager.getConnection(URL, USER, PASSWORD); catch (ClassNotFoundException e) e.printStackTrace(); catch (SQLException e) e.printStackTrace();
3、public static Connection getConnection() return conn;/*登录界面*/package immoc4.bao;import java.awt.FlowLayout;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.SQLException;import java.util.Scanner;import javax.swing.JButton;import javax.swing.JFrame;import javax.sw
4、ing.JLabel;import javax.swing.JTextField;public class View extends JFramestatic GongNeng gn = new GongNeng();static Student s = new Student();static JTextField text1;static JTextField text2;static JButton button;public void denglu()setLayout(new FlowLayout();add(new JLabel(用户 id:);text1 = new JTextF
5、ield(20);add(text1);add(new JLabel(密码:)；text2 = new JTextField(20);add(text2);button = new JButton(登 录)；add(button);setVisible(true);/关闭窗口setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);public static void main(String args)View dl = new View();dl.setBounds(300, 300, 300, 200); dl.setTitle(学生选课管理系统); d
6、l.denglu();button.addActionListener(new ActionListener() public void actionPerformed(ActionEvent e) / TODO Auto-generated method stub dl.dispose();s.setStudent_id(Integer.parseInt(text1.getText(); s.setStudent_code(text2.getText();try gn.correspond(s); catch (SQLException e1) / TODO Auto-generated c
7、atch block e1.printStackTrace(););/*主界面*/回S3尊加课程删除课程查间课程课程号删除回1=. I回 以添加课程删除课程修改课程查闻课程课程号查间package immoc4.bao;import javax.swing.*;import immoc4.bao.Course;import java.awt.*;import java.awt.event.*;import java.sql.SQLException;public class Card extends JFrame/* JFrame的布局管理器是BorderLayout*/Course g =
8、new Course();GongNeng gn = new GongNeng();JPanel p;/位于中心区域的面板JButton b1,b2,b3,b4;/位于北部区域的四个按钮JButton add;JButton delete;JButton update;JButton query;JLabel add_id,add_name,add_teacher_name;JLabel delete_id;JLabel update_id,update_name,update_teacher_name;JLabel query_id;JLabel query_show;JTextField
9、text_add_id,text_add_name,text_add_teacher_name;JTextField text_delete_id;JTextField text_update_id,text_update_name,text_update_teacher_name;JTextField text_query_id;JTextArea area_query_show;CardLayout c;/设置面板p的布局Card()super();this.setVisible(true);this.setBounds(400,300,400,300);p = new JPanel();
10、/实例化 p c = new CardLayout();/实例化 c p.setLayout(c);/设置面板 p 的布局为 c,等价于 p = new JPanel(c);实例化4个按钮和标签b1 = new JButton(添加课程)；b2 = new JButton(删除课程)；b3 = new JButton(修改课程)；b4 = new JButton(查询课程)；实例化4个子面板并设定相应背景颜色JPanel p1 = new JPanel();JPanel p2 = new JPanel();JPanel p3 = new JPanel();JPanel p4 = new JPa
11、nel();/ p1.setLayout(p1.setBackground(Color.green);p2.setBackground(Color.pink);p3.setBackground(Color.orange);p4.setBackground(Color.lightGray);把上面4个面板添加到中心面板p中，并把4个面板分别用编号为1,2,3,4代替 p.add(p1,1);p.add(p2,2);p.add(p3,3);p.add(p4,4);/实例化位于南部区域的面板，并添加4个按钮 JPanel pnorth = new JPanel();pnorth.add(bl);pn
12、orth.add(b2);pnorth.add(b3);pnorth.add(b4);把p,psourth分别添加到本JFrame的中心区域和南部区域this.add(p);/等价于 this.add(p,BorderLayout.CENTER);因为默认是把组件添加到中 部this.add(pnorth,BorderLayout.NORTH);/添加课程add_id = new JLabel(课程号)；text_add_id = new JTextField(30);add_name = new JLabel(课程名)；text_add_name = new JTextField(30);a
13、dd_teacher_name = new JLabel(教师名);text_add_teacher_name = new JTextField(30);add = new JButton(添加)；为按钮b1添加监听器，当被按下时显示面板p中的前一个子面板b1.addActionListener(new ActionListener()Overridepublic void actionPerformed(ActionEvent e) / TODO Auto-generated method stubc.show(p,1);/显示p中的上一个面板p1.add(add_id);p1.add(te
14、xt_add_id);p1.add(add_name);p1.add(text_add_name);p1.add(add_teacher_name);p1.add(text_add_teacher_name);p1.add(add);setVisible(true););add.addActionListener(new ActionListener()Overridepublic void actionPerformed(ActionEvent e) / TODO Auto-generated method stubg.setId(Integer.parseInt(text_add_id.getText();g.setName(text_add_name.getText();g.setTeacher_name(text_add_teacher_name.getText();try gn.addcourse(g); catch (Exception e1) / TODO Auto
