京东优惠券网站建设,怎么注册网站 个人,精仿腾讯3366小游戏门户网站源码织梦最新内核带全部数据!,wordpress中文免费企业主题设计要求
本课程设计#xff0c;涉及输入输出、GUI设计、数据库操作等本课程重要概念和编程技能#xff0c;全面巩固和加深学生对java程序设计的相关概念的理解#xff0c;全面强化java编程技能#xff0c;培养学生综合运用所学知识和技能分析问题和解决问题的能力。培养学…设计要求
本课程设计涉及输入输出、GUI设计、数据库操作等本课程重要概念和编程技能全面巩固和加深学生对java程序设计的相关概念的理解全面强化java编程技能培养学生综合运用所学知识和技能分析问题和解决问题的能力。培养学生的团队精神和协作能力。 课程设计内容要求
一、数据库设计
创建库mydb在mysql中进行 数据表设计
1 学生通讯信息表
employee:no, name, sex, class, phone,email
二、功能设计
功能模块选择菜单用户登录 3录入模块: 学生信息表按相应id录入。数据的插入、修改、删除
三、界面设计
1用户登录 2主窗体
四、设计要求
采用GUI编程 2画出功能模块图 3Java GUI编程实现要求各功能模块功能清晰、单一。各功能模块命名规范界面友好代码注释完整准确。
一、功能介绍
该系统主要是用于管理学生基本通讯信息主要功能包括两方面的 1.管理学生信息其中包括添加删除修改等操作。 2.查询信息其中查询学生电话、邮件等信息。
二、设计过程
1.登录界面denglu.java
登录时输入账号密码未填写、输入错误账号密码都会提出错误提示框。在填写正确账号和密码后会提示正确并跳转到主窗体。 package 课程设计;
import java.awt.BorderLayout;
import java.awt.EventQueue;import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.border.EmptyBorder;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTextField;
import javax.swing.JPasswordField;
import javax.swing.JButton;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;public class denglu extends JFrame {private JPanel contentPane;private JTextField textField;private JPasswordField passwordField;/*** Launch the application.*/public static void main(String[] args) {EventQueue.invokeLater(new Runnable() {public void run() {try {denglu frame new denglu();frame.setVisible(true);} catch (Exception e) {e.printStackTrace();}}});}/*** Create the frame.*/public denglu() {setTitle(登录界面\r\n);setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);setBounds(100, 100, 450, 300);contentPane new JPanel();contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));setContentPane(contentPane);contentPane.setLayout(null);JLabel lblNewLabel new JLabel(账号);lblNewLabel.setBounds(33, 27, 68, 18);contentPane.add(lblNewLabel);JLabel lblNewLabel_1 new JLabel(密码);lblNewLabel_1.setBounds(33, 71, 68, 18);contentPane.add(lblNewLabel_1);textField new JTextField();textField.setBounds(115, 24, 196, 24);contentPane.add(textField);textField.setColumns(10);passwordField new JPasswordField();passwordField.setBounds(115, 68, 196, 24);contentPane.add(passwordField);JButton btnNewButton new JButton(登录);btnNewButton.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent arg0) {if ((textField.getText().equals(admin)false)||(passwordField.getText().equals(1234)false)) {JOptionPane.showMessageDialog(null, 账号或者密码错误请重新输入);textField.setText();passwordField.setText();}else{JOptionPane.showMessageDialog(null, 正确 );new zhuchuangti().setVisible(true);dispose();}}});btnNewButton.setBounds(33, 126, 113, 27);contentPane.add(btnNewButton);JButton btnNewButton_1 new JButton(退出);btnNewButton_1.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent e) {System.exit(0);}});btnNewButton_1.setBounds(198, 126, 113, 27);contentPane.add(btnNewButton_1);}}2. 学生通讯录界面zhuchuangti.Java
学生通讯录有学号、姓名、班级、性别、邮箱、电话号码 package 课程设计;
import javax.activation.DataSource;
import javax.naming.spi.DirStateFactory.Result;
import javax.swing.*;import com.mysql.cj.jdbc.AbandonedConnectionCleanupThread;import java.awt.*;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
import java.sql.*;/**
* This code was edited or generated using CloudGardens Jigloo
* SWT/Swing GUI Builder, which is free for non-commercial
* use. If Jigloo is being used commercially (ie, by a corporation,
* company or business for any purpose whatever) then you
* should purchase a license for each developer using Jigloo.
* Please visit www.cloudgarden.com for details.
* Use of Jigloo implies acceptance of these licensing terms.
* A COMMERCIAL LICENSE HAS NOT BEEN PURCHASED FOR
* THIS MACHINE, SO JIGLOO OR THIS CODE CANNOT BE USED
* LEGALLY FOR ANY CORPORATE OR COMMERCIAL PURPOSE.
*/
public class zhuchuangti extends JFrame
{public zhuchuangti() {}private JTextArea jTextArea1;private JLabel jLabel1;private JTextField jTextField1;private JLabel jLabel2;private JLabel jLabel3;private JLabel jLabel4;private JLabel jLabel5;private JLabel jLabel6;private JScrollPane jScrollPane1;private JButton jButton6;private JButton jButton5;private JButton jButton4;private JButton jButton3;private JButton jButton1;private JButton jButton2;private JTextField jTextField6;private JTextField jTextField5;private JTextField jTextField4;private JTextField jTextField3;private JTextField jTextField2;public static final String url jdbc:mysql://localhost:3306/mydb?useSSLFALSEserverTimezoneGMT; public static final String name com.mysql.cj.jdbc.Driver; public static final String user root; public static final String password 12345; {this.setBounds(100,100,771,400);this.setTitle(学生通讯录管理系统);Container s getContentPane();s.setBounds(-8, -30, 558, 362);{jScrollPane1 new JScrollPane();s.add(jScrollPane1);jScrollPane1.setBounds(12, 12,720, 120);{jTextArea1 new JTextArea();jScrollPane1.setViewportView(jTextArea1);jTextArea1.setBounds(12, 12, 460, 120);}}{jLabel1 new JLabel();s.add(jLabel1);jLabel1.setText(\u5b66 \u53f7\uff1a);jLabel1.setBounds(12, 146, 48, 18);}{jTextField1 new JTextField();s.add(jTextField1);jTextField1.setBounds(60, 144, 78, 24);}{jTextField2 new JTextField();s.add(jTextField2);jTextField2.setBounds(226, 144, 78, 24);}{jLabel2 new JLabel();s.add(jLabel2);jLabel2.setText(\u59d3\u540d\uff1a);jLabel2.setBounds(187, 146, 39, 18);}{jTextField3 new JTextField();s.add(jTextField3);jTextField3.setBounds(394, 144, 78, 24);}{jLabel3 new JLabel();s.add(jLabel3);jLabel3.setText(\u6027\u522b\uff1a);jLabel3.setBounds(355, 145, 39, 18);}{jLabel4 new JLabel();s.add(jLabel4);jLabel4.setText(班级);jLabel4.setBounds(12, 180, 54, 17);}{jTextField4 new JTextField();s.add(jTextField4);jTextField4.setBounds(60, 180, 78, 24);}{jLabel5 new JLabel();s.add(jLabel5);jLabel5.setText(电话);jLabel5.setBounds(185, 180, 43, 17);}{jTextField5 new JTextField();s.add(jTextField5);jTextField5.setBounds(226, 180, 78, 24);}{jLabel6 new JLabel();s.add(jLabel6);jLabel6.setText(邮箱);jLabel6.setBounds(355, 180, 43, 17);}{jTextField6 new JTextField();s.add(jTextField6);jTextField6.setBounds(394, 180, 78, 24);}{jButton1 new JButton();s.add(jButton1);jButton1.setText(显示学生信息);jButton1.setBounds(12, 221, 135, 24);jButton1.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent evt) {System.out.println(jButton1.actionPerformed, eventevt);//TODO add your code for jButton1.actionPerformedtry {Class.forName(name);System.out.println(驱动加载成功);} catch (ClassNotFoundException e) {// TODO: handle exceptionSystem.out.println(SQLException:e.getMessage());}try {Connection conDriverManager.getConnection(url,user,password);Statement stmtcon.createStatement();ResultSet rsstmt.executeQuery(select * from employee);jTextArea1.setText(null);while(rs.next()){jTextArea1.append(学号rs.getString(no)\t);jTextArea1.append(姓名rs.getString(name)\t);jTextArea1.append(性别rs.getString(sex)\t);jTextArea1.append(班级rs.getString(class)\t);jTextArea1.append(电话rs.getString(phone)\t);jTextArea1.append(邮箱rs.getString(mail)\n);}con.close();rs.close();stmt.close();} catch (Exception e) {// TODO: handle exception}}});}{jButton2 new JButton();s.add(jButton2);jButton2.setText(查询学生信息);jButton2.setBounds(168, 221, 131, 24);jButton2.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent evt) {System.out.println(jButton2.actionPerformed, eventevt);//TODO add your code for jButton2.actionPerformedtry {Class.forName(name);System.out.println(驱动加载成功);} catch (ClassNotFoundException e) {// TODO: handle exceptionSystem.out.println(SQLException:e.getMessage());}try {Connection conDriverManager.getConnection(url,user,password);Statement stmtcon.createStatement();String sqlstrselect * from employee where nojTextField1.getText();ResultSet rsstmt.executeQuery(sqlstr);while(rs.next()){jTextArea1.setText(null);jTextArea1.append(学号rs.getString(no)\t);jTextArea1.append(姓名rs.getString(name)\t);jTextArea1.append(性别rs.getString(sex)\t);jTextArea1.append(班级rs.getString(class)\t);jTextArea1.append(电话rs.getString(phone)\t);jTextArea1.append(邮箱rs.getString(mail)\n);}stmt.executeUpdate(sqlstr);con.close();rs.close();stmt.close();} catch (Exception e) {jTextField1.setText();jTextField2.setText();jTextField3.setText();jTextField4.setText();jTextField5.setText();jTextField6.setText();// TODO: handle exception}}});}{jButton3 new JButton();s.add(jButton3);jButton3.setText(插入学生信息);jButton3.setBounds(321, 221, 140, 24);jButton3.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent evt) {System.out.println(jButton3.actionPerformed, eventevt);//TODO add your code for jButton3.actionPerformedtry {Class.forName(name);System.out.println(驱动加载成功);} catch (ClassNotFoundException e) {// TODO: handle exceptionSystem.out.println(SQLException:e.getMessage());}try {Connection conDriverManager.getConnection(url,user,password);Statement stmtcon.createStatement();String sqlstrinsert into employee values(jTextField1.getText(),jTextField2.getText(),jTextField3.getText(),jTextField4.getText(),jTextField5.getText(),jTextField6.getText());stmt.executeUpdate(sqlstr);con.close();stmt.close();jTextField1.setText();jTextField2.setText();jTextField3.setText();jTextField4.setText();jTextField5.setText();jTextField6.setText();} catch (Exception e) {// TODO: handle exception}}});}{jButton4 new JButton();s.add(jButton4);jButton4.setText(修改学生信息);jButton4.setBounds(12, 260, 135, 24);jButton4.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent evt) {System.out.println(jButton4.actionPerformed, eventevt);//TODO add your code for jButton4.actionPerformedtry {Class.forName(name);System.out.println(驱动加载成功);} catch (ClassNotFoundException e) {// TODO: handle exceptionSystem.out.println(SQLException:e.getMessage());}try {Connection conDriverManager.getConnection(url,user,password);Statement stmtcon.createStatement();String sqlstrupdate employee set namejTextField2.getText() ,sexjTextField3.getText() ,classjTextField4.getText() ,phonejTextField5.getText() ,mailjTextField6.getText() where nojTextField1.getText();stmt.executeUpdate(sqlstr);con.close();stmt.close();jTextField1.setText();jTextField2.setText();jTextField3.setText();jTextField4.setText();jTextField5.setText();jTextField6.setText();} catch (Exception e) {// TODO: handle exception}}});}{jButton5 new JButton();s.add(jButton5);jButton5.setText(删除学生信息);jButton5.setBounds(167, 260, 132, 24);jButton5.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent evt) {System.out.println(jButton5.actionPerformed, eventevt);//TODO add your code for jButton5.actionPerformedtry {Class.forName(name);System.out.println(驱动加载成功);} catch (ClassNotFoundException e) {// TODO: handle exceptionSystem.out.println(SQLException:e.getMessage());}try {Connection conDriverManager.getConnection(url,user,password);Statement stmtcon.createStatement();String sqlstrdelete from employee where nojTextField1.getText();stmt.executeUpdate(sqlstr);con.close();stmt.close();jTextField1.setText();jTextField2.setText();jTextField3.setText();jTextField4.setText();jTextField5.setText();jTextField6.setText();} catch (Exception e) {// TODO: handle exception}}});}{jButton6 new JButton();s.add(jButton6);jButton6.setText(\u9000\u51fa);jButton6.setBounds(321, 260, 140, 24);jButton6.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent evt) {System.out.println(jButton6.actionPerformed, eventevt);//TODO add your code for jButton6.actionPerformedSystem.exit(0);}});}{ getContentPane().setLayout(null);this.setAlwaysOnTop(false);}}
}三、界面展示
1登录 2显示学生信息 3查询学生信息 4添加学生信息 5修改学生信息 6删除学生信息 四、联系与交流
q:969060742 完整文档、代码、sql、程序资源
