学生选课系统(连接Mysql数据库).doc

《学生选课系统(连接Mysql数据库).doc》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、../*JDBC连接数据库*/packageimmoc4.bao;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;publicclassJDBC{privatestaticfinalStringURL="jdbc:mysql://localhost:3306/a?characterEncoding=utf8";privatestaticfin

2、alStringUSER="root";privatestaticfinalStringPASSWORD="995923";privatestaticConnectionconn=null;static{try{Class.forName("com.mysql.jdbc.Driver");conn=DriverManager.getConnection(URL,USER,PASSWORD);}catch(ClassNotFoundExceptione){e.printStackTrace();}catch(SQLExceptione){e.printSta

3、ckTrace();}}publicstaticConnectiongetConnection(){returnconn;}}/*登录界面*/word教育资料..packageimmoc4.bao;importjava.awt.FlowLayout;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.sql.SQLException;importjava.util.Scanner;importjavax.swing.JButton;importjav

4、ax.swing.JFrame;importjavax.swing.JLabel;importjavax.swing.JTextField;publicclassViewextendsJFrame{staticGongNenggn=newGongNeng();staticStudents=newStudent();staticJTextFieldtext1;staticJTextFieldtext2;staticJButtonbutton;publicvoiddenglu(){setLayout(newFlowLayout());add(newJLabel

5、("用户id:"));text1=newJTextField(20);add(text1);add(newJLabel("密码:"));text2=newJTextField(20);add(text2);button=newJButton("登录");add(button);setVisible(true);setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);//关闭窗口}publicstaticvoidmain(String[]args){Viewdl=newView();word教育资料..dl.setBou

6、nds(300,300,300,200);dl.setTitle("学生选课管理系统");dl.denglu();button.addActionListener(newActionListener(){publicvoidactionPerformed(ActionEvente){//TODOAuto-generatedmethodstubdl.dispose();s.setStudent_id(Integer.parseInt(text1.getText()));s.setStudent_code(text2.getText());try{gn.cor

7、respond(s);}catch(SQLExceptione1){//TODOAuto-generatedcatchblocke1.printStackTrace();}}});}}/*主界面*/word教育资料..word教育资料..packageimmoc4.bao;importjavax.swing.*;importimmoc4.bao.Course;importjava.awt.*;importjava.awt.event.*;importjava.sql.SQLException;publicclassCardextendsJFrame{/**

8、JFrame的布局管理器是BorderLayout*/Course