《数据库课程设计——户籍管理系统(由JAVA编写,附源代码).doc》由会员分享，可在线阅读，更多相关《数据库课程设计——户籍管理系统(由JAVA编写,附源代码).doc（150页珍藏版）》请在三一文库上搜索。
1、户籍管理系统（由JAVA编写）软件支持：本软件开发是在eclipse-SDK-3.2-win32集成环境下编辑、调试与运行的；（Java语言编写,需要装JDK） 设备支持：WindowsXP，512内存；数 据 库：Microsoft SQL Server 2000 系统管理员：（仅一个）帐号：admin 密码：admin123普通用户：（可由管理员创建）帐号：huang 密码：huang本系统主程序为 : DengLu.java ，编译后运行bin 文件夹下的DengLu.class文件即可运行主程序，弹出登录界面：主界面：查看户口信息：查看户成员信息浏览户口信息添加户口信息修改户口信息删除
2、户口信息：查询居民信息：浏览全部居民信息：添加居民信息：修改居民信息：删除居民信息：浏览所有用户信息：添加用户：删除用户：源代码：DengLu.javaimport javax.swing.JOptionPane;import javax.swing.SwingUtilities;import javax.swing.JPanel;import javax.swing.JFrame;import javax.swing.JButton;import java.awt.Rectangle;import javax.swing.JLabel;import javax.swing.ImageIcon
3、;import javax.swing.JTextField;import javax.swing.JPasswordField;import java.awt.*;import java.awt.event.KeyEvent;public class DengLu extends JFrame private static final long serialVersionUID = 1L;private JPanel jContentPane = null;private JButton jButton = null;private JButton jButton1 = null;priva
4、te JLabel jLabel = null;private JTextField 用户名 = null;private JPasswordField 密码 = null;private JLabel jLabel1 = null;private JLabel jLabel2 = null;private DBOperation db=new DBOperation(); / jve:decl-index=0:private int i=0;private JButton jButton2 = null;/* * This method initializes jButton * * ret
5、urn javax.swing.JButton */private JButton getJButton() if (jButton = null) jButton = new JButton();jButton.setBounds(new Rectangle(169, 227, 70, 23);jButton.setMnemonic(KeyEvent.VK_ENTER);jButton.setToolTipText(输入用户名、密码登陆);jButton.setText(登录);jButton.addActionListener(new java.awt.event.ActionListen
6、er() public void actionPerformed(java.awt.event.ActionEvent e) String user=用户名.getText(); String password=new String(密码.getPassword();if(user.equals()JOptionPane.showMessageDialog(null,用户名不能为空！);elseif(db.CheckUser(user, password)if(db.IsAdmin(user)MainMenu m= new MainMenu();m.setVisible(true);setVi
7、sible(false);elseMainMenuUser m= new MainMenuUser();m.setVisible(true);setVisible(false);elseJOptionPane.showMessageDialog(null,用户名不存在或密码错误！ +剩余次数:+(2-i);i+;if(i=3)JOptionPane.showMessageDialog(null,用户名密码尝试次数已达3次，系统将退出！);System.exit(0););return jButton;/* * This method initializes jButton1 * * retur
8、n javax.swing.JButton */private JButton getJButton1() if (jButton1 = null) jButton1 = new JButton();jButton1.setBounds(new Rectangle(263, 227, 70, 23);jButton1.setToolTipText(退出系统);jButton1.setText(退出);jButton1.addActionListener(new java.awt.event.ActionListener() public void actionPerformed(java.aw
9、t.event.ActionEvent e) System.exit(0););return jButton1;/* * This method initializes 用户名 * * return javax.swing.JTextField */private JTextField get用户名() if (用户名 = null) 用户名 = new JTextField();用户名.setBounds(new Rectangle(227, 158, 110, 23);return 用户名;/* * This method initializes 密码 * * return javax.s
10、wing.JPasswordField */private JPasswordField get密码() if (密码 = null) 密码 = new JPasswordField();密码.setBounds(new Rectangle(227, 198, 110, 23);return 密码;/* * This method initializes jButton2 * * return javax.swing.JButton */private JButton getJButton2() if (jButton2 = null) jButton2 = new JButton();jBu
11、tton2.setBounds(new Rectangle(346, 160, 63, 19);jButton2.setText(注册);jButton2.addActionListener(new java.awt.event.ActionListener() public void actionPerformed(java.awt.event.ActionEvent e) Zhuce z= new Zhuce();z.setVisible(true);/setVisible(false););return jButton2;/* * param args */public static v
12、oid main(String args) / TODO 自动生成方法存根SwingUtilities.invokeLater(new Runnable() public void run() DengLu thisClass = new DengLu();thisClass.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);thisClass.setVisible(true););/* * This is the default constructor */public DengLu() super();initialize();/* * This
13、 method initializes this * * return void */private void initialize() this.setContentPane(getJContentPane();this.setSize(600, 400);this.setResizable(false);this.setTitle(登录到户籍管理系统); /得到当前屏幕大小this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); Dimension screenSize = Toolkit.getDefaultToolkit().getScr
14、eenSize(); /得到frame的大小 Dimension frameSize = this.getSize(); if (frameSize.height screenSize.height) frameSize.height = screenSize.height; if (frameSize.width screenSize.width) frameSize.width = screenSize.width; /设置frame在屏幕上显示的位置 this.setLocation( (screenSize.width - frameSize.width) / 2, (screenSi
15、ze.height - frameSize.height) / 2);/* * This method initializes jContentPane * * return javax.swing.JPanel */private JPanel getJContentPane() if (jContentPane = null) jLabel2 = new JLabel();jLabel2.setBounds(new Rectangle(0, 0, 600, 400);/jLabel2.setIcon(new ImageIcon(getClass().getResource(/DengLu.
16、jpg);jLabel2.setText();jLabel1 = new JLabel();jLabel1.setBounds(new Rectangle(167, 198, 58, 23);jLabel1.setText(密 码：);jLabel = new JLabel();jLabel.setBounds(new Rectangle(167, 158, 58, 23);jLabel.setText(用户名：);jContentPane = new JPanel();jContentPane.setLayout(null);jContentPane.add(getJButton(), nu
17、ll);jContentPane.add(getJButton1(), null);jContentPane.add(getJButton2(), null);jContentPane.add(jLabel, null);jContentPane.add(get用户名(), null);jContentPane.add(get密码(), null);jContentPane.add(jLabel1, null);jContentPane.add(jLabel2, null);return jContentPane; / jve:decl-index=0:visual-constraint=12
18、9,34*MainMenu.javaimport java.awt.Rectangle;import java.awt.Toolkit;import javax.swing.JPanel;import javax.swing.JFrame;import javax.swing.JMenuBar;import javax.swing.JMenu;import javax.swing.JMenuItem;import java.awt.Dimension;import javax.swing.JLabel;import javax.swing.ImageIcon;public class Main
19、Menu extends JFrame private static final long serialVersionUID = 1L;private JPanel jContentPane = null;private JMenuBar jJMenuBar = null;private JMenu jMenu = null;private JMenuItem 返回登录 = null;private JMenuItem 退出系统 = null;private JMenu jMenu1 = null;private JMenuItem 查询户口 = null;private JMenuItem
20、添加户口 = null;private DengLu denglu;private AddH addh = new AddH(); / jve:decl-index=0:visual-constraint=188,630private Search search= new Search(); / jve:decl-index=0:visual-constraint=335,633private JMenuItem 删除户口 = null;private JMenuItem 修改户口 = null;private DelH delh= new DelH(); / jve:decl-index=0
21、:visual-constraint=10,619private ChangeH changeh= new ChangeH(); / jve:decl-index=0:visual-constraint=464,678private JMenu jMenu2 = null;private JMenuItem 查询居民 = null;private JMenuItem 添加居民 = null;private JMenuItem 删除居民 = null;private JMenuItem 修改居民 = null;private SearchP searchp= new SearchP(); / j
22、ve:decl-index=0:visual-constraint=30,835private AddP addp= new AddP(); / jve:decl-index=0:visual-constraint=182,911private DelP delp= new DelP(); / jve:decl-index=0:visual-constraint=273,763private ChangeP changep= new ChangeP(); / jve:decl-index=0:visual-constraint=10,978private JMenu jMenu3 = null
23、;private JMenuItem 添加用户 = null;private JMenuItem 删除用户 = null;private JMenuItem 浏览所有用户 = null;private AddU addu= new AddU(); / jve:decl-index=0:visual-constraint=10,725private SearchU searchu= new SearchU(); / jve:decl-index=0:visual-constraint=398,794private DelU delu= new DelU(); / jve:decl-index=0
24、:visual-constraint=149,752private JLabel 菜单首页背景 = null;private JMenu jMenu4 = null;private JMenuItem 关于户籍管理系统 = null;private About about=new About();/* * This is the default constructor */public MainMenu() super();initialize();/* * This method initializes this * * return void */private void initiali
25、ze() searchu.setSize(new Dimension(96, 92);changep.setSize(new Dimension(117, 116);delp.setSize(new Dimension(79, 90);addu.setSize(new Dimension(104, 67);delu.setSize(new Dimension(86, 64);addp.setSize(new Dimension(96, 57);changeh.setSize(new Dimension(113, 80);searchp.setSize(new Dimension(129, 64
26、);delh.setSize(new Dimension(103, 95);search.setSize(new Dimension(109, 75);addh.setSize(new Dimension(107, 85);this.setJMenuBar(getJJMenuBar();this.setContentPane(getJContentPane();this.setTitle(欢迎使用户籍管理系统);this.setResizable(false);this.setSize(900, 600);this.setDefaultCloseOperation(JFrame.EXIT_ON
27、_CLOSE); Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize(); /得到frame的大小 Dimension frameSize = this.getSize(); if (frameSize.height screenSize.height) frameSize.height = screenSize.height; if (frameSize.width screenSize.width) frameSize.width = screenSize.width; /设置frame在屏幕上显示的位置 thi
28、s.setLocation( (screenSize.width - frameSize.width) / 2, (screenSize.height - frameSize.height) / 2); /* * This method initializes jContentPane * * return javax.swing.JPanel */private JPanel getJContentPane() if (jContentPane = null) 菜单首页背景 = new JLabel();菜单首页背景.setBounds(new Rectangle(0, 0, 900, 60
29、0);/菜单首页背景.setIcon(new ImageIcon(getClass().getResource(/Mainmenu.jpg);菜单首页背景.setText(JLabel);jContentPane = new JPanel();jContentPane.setLayout(null);jContentPane.add(菜单首页背景, null);return jContentPane;/* * This method initializes jJMenuBar * * return javax.swing.JMenuBar */private JMenuBar getJJMen
30、uBar() if (jJMenuBar = null) jJMenuBar = new JMenuBar();jJMenuBar.add(getJMenu();jJMenuBar.add(getJMenu1();jJMenuBar.add(getJMenu2();jJMenuBar.add(getJMenu3();jJMenuBar.add(getJMenu4();return jJMenuBar;/* * This method initializes jMenu * * return javax.swing.JMenu */private JMenu getJMenu() if (jMe
31、nu = null) jMenu = new JMenu();jMenu.setText(菜单);jMenu.add(get返回登录();jMenu.add(get退出系统();return jMenu;/* * This method initializes 返回登录 * * return javax.swing.JMenuItem */private JMenuItem get返回登录() if (返回登录 = null) 返回登录 = new JMenuItem(返回登录界面);返回登录.addActionListener(new java.awt.event.ActionListene
32、r() public void actionPerformed(java.awt.event.ActionEvent e) denglu = new DengLu();setVisible(false);denglu.setVisible(true););return 返回登录;/* * This method initializes 退出系统 * * return javax.swing.JMenuItem */private JMenuItem get退出系统() if (退出系统 = null) 退出系统 = new JMenuItem(退出系统);退出系统.addActionListe
33、ner(new java.awt.event.ActionListener() public void actionPerformed(java.awt.event.ActionEvent e) System.exit(0););return 退出系统;/* * This method initializes jMenu1 * * return javax.swing.JMenu */private JMenu getJMenu1() if (jMenu1 = null) jMenu1 = new JMenu();jMenu1.setText(户口管理);jMenu1.add(get查询户口(
34、);jMenu1.add(get添加户口();jMenu1.add(get删除户口();jMenu1.add(get修改户口();return jMenu1;/* * This method initializes 查询户口 * * return javax.swing.JMenuItem */private JMenuItem get查询户口() if (查询户口 = null) 查询户口 = new JMenuItem(查询户口信息);查询户口.addActionListener(new java.awt.event.ActionListener() public void actionP
35、erformed(java.awt.event.ActionEvent e) hidepane();search=new Search();jContentPane.add(search,null);search.setVisible(true);setTitle(查询户口信息);search.setBounds(new Rectangle(0, 0, 900,600););return 查询户口;void hidepane()addh.setVisible(false);addp.setVisible(false);addu.setVisible(false);about.setVisibl
36、e(false);changeh.setVisible(false);changep.setVisible(false);delh.setVisible(false);delp.setVisible(false);delu.setVisible(false);search.setVisible(false);searchp.setVisible(false);searchu.setVisible(false);菜单首页背景.setVisible(false);/* * This method initializes 添加户口 * * return javax.swing.JMenuItem *
37、/private JMenuItem get添加户口() if (添加户口 = null) 添加户口 = new JMenuItem(添加户口信息);添加户口.addActionListener(new java.awt.event.ActionListener() public void actionPerformed(java.awt.event.ActionEvent e) hidepane();addh=new AddH();jContentPane.add(addh,null);addh.setVisible(true);setTitle(添加户口信息);addh.setBounds
38、(new Rectangle(0, 0, 900,600););return 添加户口;/* * This method initializes 删除户口 * * return javax.swing.JMenuItem */private JMenuItem get删除户口() if (删除户口 = null) 删除户口 = new JMenuItem(删除户口信息);删除户口.addActionListener(new java.awt.event.ActionListener() public void actionPerformed(java.awt.event.ActionEvent
39、 e) hidepane();delh=new DelH();jContentPane.add(delh,null);delh.setVisible(true);setTitle(删除户口信息);delh.setBounds(new Rectangle(0, 0, 900,600););return 删除户口;/* * This method initializes 修改户口 * * return javax.swing.JMenuItem */private JMenuItem get修改户口() if (修改户口 = null) 修改户口 = new JMenuItem(修改户口信息);修改户口.addActionListener(new java.awt.event.ActionListener() public void actionPerformed(java.awt.event.ActionEvent e) hidepane();changeh=new ChangeH();jContentPane.add(changeh,null);changeh.setVisible(true);setTitle(修改户口信息);