数据库课程设计——户籍管理系统(由JAVA编写,附源代码).doc

户籍管理系统（由JAVA编写）软件支持：本软件开发是在eclipse-SDK-3.2-win32集成环境下编辑、调试与运行的；（Java语言编写,需要装JDK） 设备支持：WindowsXP，512内存；数 据 库：Microsoft SQL Server 2000 系统管理员：（仅一个）帐号：admin 密码：admin123普通用户：（可由管理员创建）帐号：huang 密码：huang本系统主程序为 : DengLu.java ，编译后运行bin 文件夹下的DengLu.class文件即可运行主程序，弹出登录界面：主界面：查看户口信息：查看户成员信息浏览户口信息添加户口信息修改户口信息删除户口信息：查询居民信息：浏览全部居民信息：添加居民信息：修改居民信息：删除居民信息：浏览所有用户信息：添加用户：删除用户：源代码：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;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;private 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 * * return 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.ActionListener() 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);setVisible(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 * * return 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.awt.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.swing.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();jButton2.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 void 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 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().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在屏幕上显示的位置 this.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) jLabel2 = new JLabel();jLabel2.setBounds(new Rectangle(0, 0, 600, 400);/jLabel2.setIcon(new ImageIcon(getClass().getResource("/DengLu.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(), null);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="129,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 MainMenu 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 添加户口 = null;private DengLu denglu;private AddH addh = new AddH(); / jve:decl-index=0:visual-constraint="188,630"private Search search= new Search(); / jve:decl-index=0:visual-constraint="335,633"private JMenuItem 删除户口 = null;private JMenuItem 修改户口 = null;private DelH delh= new DelH(); / jve:decl-index=0:visual-constraint="10,619"private ChangeH changeh= new ChangeH(); / jve:decl-index=0:visual-constraint="464,678"private JMenu jMenu2 = null;private JMenuItem 查询居民 = null;private JMenuItem 添加居民 = null;private JMenuItem 删除居民 = null;private JMenuItem 修改居民 = null;private SearchP searchp= new SearchP(); / jve:decl-index=0:visual-constraint="30,835"private AddP addp= new AddP(); / jve:decl-index=0:visual-constraint="182,911"private DelP delp= new DelP(); / jve:decl-index=0:visual-constraint="273,763"private ChangeP changep= new ChangeP(); / jve:decl-index=0:visual-constraint="10,978"private JMenu jMenu3 = null;private JMenuItem 添加用户 = null;private JMenuItem 删除用户 = null;private JMenuItem 浏览所有用户 = null;private AddU addu= new AddU(); / jve:decl-index=0:visual-constraint="10,725"private SearchU searchu= new SearchU(); / jve:decl-index=0:visual-constraint="398,794"private DelU delu= new DelU(); / jve:decl-index=0:visual-constraint="149,752"private 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 initialize() 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);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_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在屏幕上显示的位置 this.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, 600);/菜单首页背景.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 getJJMenuBar() 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 (jMenu = 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.ActionListener() 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("退出系统");退出系统.addActionListener(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查询户口();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 actionPerformed(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.setVisible(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 */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(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();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("修改户口信息");