java Swing 设计数据库前台界面

import javax.swing.*; import java.sql.*; import java.awt.*; import javax.swing.tree.*; //import javax.swing.border.*; import javax.swing.event.*; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import javax.swing.table.DefaultTableModel; import java.awt.BorderLayout; import java.awt.EventQueue; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.WindowAdapter; import java.awt.event.WindowEvent; import java.util.Vector; import javax.swing.JButton; import javax.swing.JFrame; import javax.swing.JPanel; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.UIManager; import javax.swing.border.EmptyBorder; import javax.swing.table.DefaultTableModel; public class F extends JFrame{ static ImageIcon icon = new ImageIcon("E:\\文件\\壁纸\\壁纸\\Alienware01.jpg"); static JLabel L1 = new JLabel(icon); static JPanel panel = new JPanel(); static Box baseBox,box,box1,box2,box3,box4,box5; static JButton register =new JButton("注册"); static JButton Login = new JButton("登陆"); static JButton Exit = new JButton("退出"); static String[] s = {"管理员","用户"}; static JComboBox combo1 = new JComboBox(s); static JLabel la = new JLabel("在线图书管理信息系统");JLabel lb = new JLabel("请输入用户名：");JLabel lc = new JLabel("请输入密码："); static JTextField t_name = new JTextField(10); static JPasswordField t_password = new JPasswordField(10); public F(){ this.setLayout(null); la.setBounds(550, 0, 400, 50); la.setFont(new java.awt.Font("华文行楷",1,25)); la.setForeground(Color.white); lb.setBounds(550,80,150,50); lb.setForeground(Color.white); lc.setForeground(Color.white); lc.setBounds(550,110,150,50); register.setBounds(530,160,70,30); Login.setBounds(630,160,70,30); Exit.setBounds(730,160,70,30); t_name.setBounds(650,95,150,20); t_password.setBounds(650,125,150,20); combo1.setBounds(600,40,170,20); L1.setBounds(-40,-50,1500,1000); this.add(la); this.add(lb); this.add(lc); this.add(t_name); this.add(t_password); this.add(combo1); this.add(register); this.add(Login); this.add(Exit); this.getContentPane().add(L1); register.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ register1(); } }); Login.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { // TODO Auto-generated method stub check(); } } ); Exit.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e) { // TODO Auto-generated method stub System.exit(0); } } ); } public static void main(String args[]){ EventQueue.invokeLater(new Runnable() { public void run() { try { F frame = new F(); //frame.getLayeredPane().add(L1); frame.setVisible(true); frame.setTitle("欢迎界面"); GraphicsDevice myDevice = GraphicsEnvironment.getLocalGraphicsEnvironment() .getDefaultScreenDevice(); myDevice.setFullScreenWindow(frame); frame.add(panel,BorderLayout.CENTER); frame.validate(); } catch (Exception e) { e.printStackTrace(); } } }); } public static void register1(){ new WindowFlow2("注册界面"); } public void check(){ Connection con ; PreparedStatement pre; ResultSet rs; try{Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");} catch(ClassNotFoundException e){System.out.println(""+e);} try{ String uri = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=在线图书销售管理信息系统"; String user = "sa"; String password = "123456"; con = DriverManager.getConnection(uri, user, password); String a = t_name.getText(); char[] b = t_password.getPassword(); String c = new String(b); String d = (String)combo1.getSelectedItem(); if(d.equals("用户")) { pre = con.prepareStatement("SELECT * FROM Users where Uno = ?"); pre.setString(1,a); rs = pre.executeQuery(); if(rs.next() == false) JOptionPane.showMessageDialog(null,"不存在此用户","消息对话 框",JOptionPane.WARNING_MESSAGE); else{ String code = rs.getString(3); if(!c.equals(code)) JOptionPane.showMessageDialog(null,"输入密码错误","消息对话 框",JOptionPane.WARNING_MESSAGE); else { JOptionPane.showMessageDialog(null,"登陆成功","消息对话 框",JOptionPane.PLAIN_MESSAGE); frame2(a); dispose(); } } con.close(); } else { pre = con.prepareStatement("SELECT * FROM Managers where Mno = ?"); pre.setString(1,a); rs = pre.executeQuery(); if(rs.next() == false) JOptionPane.showMessageDialog(null,"不存在此管理人员","消息对话 框",JOptionPane.WARNING_MESSAGE); else{ String code = rs.getString(3); if(!c.equals(code)) JOptionPane.showMessageDialog(null,"输入密码错误","消息对话 框",JOptionPane.WARNING_MESSAGE); else { JOptionPane.showMessageDialog(null,"登陆成功","消息对话 框",JOptionPane.PLAIN_MESSAGE); frame3(a); dispose(); } } con.close(); } } catch(SQLException e){ System.out.println(e); } } public static void frame2(String s){ String a = t_name.getText(); new WindowFlow(a); } public static void frame3(String s){ String aa =t_name.getText(); new WindowFlow3(aa); } } //注册界面 class WindowFlow2 extends JFrame{ JLabel r1 = new JLabel("姓名："); JLabel r2 = new JLabel("账号："); JLabel r3 = new JLabel("密码："); JTextField t1 = new JTextField(10); JTextField t2 = new JTextField(10); JTextField t3 = new JTextField(10); JButton b1 = new JButton("确定"); WindowFlow2(String s){ b1.addActionListener(new ActionListener(){ Connection con ; PreparedStatement pre; ResultSet rs; public void actionPerformed(ActionEvent a){ String w1 = t1.getText(); String w2 = t1.getText(); String w3 = t1.getText(); try{ String uri = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=在线图书销售管理信息系统"; String user = "sa"; String password = "123456"; con = DriverManager.getConnection(uri, user, password); String sql = "insert into Users values(?,?,?) "; pre = con.prepareStatement(sql,Statement.RETURN_GENERATED_KEYS); pre.setString(1, w1); pre.setString(2, w2); pre.setString(3, w3); int k =pre.executeUpdate(); if(k==1) JOptionPane.showMessageDialog(null,"注册成功","提示框",JOptionPane.PLAIN_MESSAGE); pre.close(); con.close(); } catch(SQLException e){ JOptionPane.showMessageDialog(null,"注册失败"+e,"提示框",JOptionPane.ERROR_MESSAGE); } } }); setLayout(new FlowLayout()); setTitle(s); add(r1); add(t1); add(r2); add(t2); add(r3); add(t3); add(b1); setBounds(260,100,600,200); setResizable(false); setVisible(true); } } //用户界面 class WindowFlow extends JFrame implements TreeSelectionListener{ JMenuBar menubar; JTree tree; JPanel panel = new JPanel(); JMenu menu1 ,menu2 ,menu3 ; JMenuItem item1,item2,item3; DefaultMutableTreeNode root,node1,node2,node3,node4, nodeson1,nodeson2,nodeson3,nodeson4,nodeson5; JTextField inputText; String b; JLabel label2,label1; JTable table,table2,table3; Object a[][]; Object v[][]; Object x[][]; Object name[] ={"用户名","用户号","书籍名","书籍号","订购数量","订购单价"}; Object name2[]={"书籍编号","书籍名","库存量"}; Object name3[]={"�