JAVA小程序簡(jiǎn)單學(xué)籍系統(tǒng)//Jtree,JDBC,Jframe

我們可以先在JAVA寫一個(gè)類打開數(shù)據(jù)庫獲取連接

package sql; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException; public class DBHelper { public static final String url = "jdbc:mysql://localhost:3306/mydatabase?serverTimezone=UTC"; public static final String name = "com.mysql.cj.jdbc.Driver"; public static final String user = "root"; public static final String password = "151879rh"; public Connection conn = null; public PreparedStatement pst = null; public DBHelper(String sql) { try { Class.forName(name); conn = DriverManager.getConnection(url, user, password); pst = conn.prepareStatement(sql); } catch (Exception e) { e.printStackTrace(); } } public void close() { try { this.conn.close(); this.pst.close(); } catch (SQLException e) { e.printStackTrace(); } } }

然后開始寫Jframe登陸窗口

package sql;import java.awt.Component; import java.awt.Event; import java.awt.Font; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.KeyAdapter; import java.awt.event.KeyEvent; import java.awt.event.WindowAdapter; import java.awt.event.WindowEvent;import javax.security.auth.kerberos.KeyTab; import javax.swing.JButton; import javax.swing.JDialog; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JPasswordField; import javax.swing.JTextField;@SuppressWarnings("serial") public class jFrame extends JDialog implements ActionListener {private JButton loginButton, cancelButton;private JLabel uidLabel, pwdLabel;private JTextField uidField;private JPasswordField pwdField;public jFrame() {this.setSize(320, 240);this.setTitle("系統(tǒng)登陸");this.setResizable(false);this.setDefaultCloseOperation(DO_NOTHING_ON_CLOSE);this.setLocationRelativeTo(null);this.setLayout(null);this.addWindowListener(new WindowAdapter() {@Overridepublic void windowClosing(WindowEvent e) {if (JOptionPane.showConfirmDialog(null, "是否要退出") == 0) {System.exit(0);}}});initComponents();}private void initComponents() {loginButton = new JButton("登陸");loginButton.setBounds(70, 160, 80, 30);this.add(loginButton);cancelButton = new JButton("取消");cancelButton.setBounds(170, 160, 80, 30);this.add(cancelButton);uidLabel = new JLabel("用戶名：");uidLabel.setBounds(50, 50, 60, 30);this.add(uidLabel);pwdLabel = new JLabel("密 碼：");pwdLabel.setBounds(50, 100, 60, 30);this.add(pwdLabel);uidField = new JTextField();uidField.setBounds(120, 50, 120, 30);this.add(uidField);pwdField = new JPasswordField();pwdField.setBounds(120, 100, 120, 30);this.add(pwdField);Font font = new Font("微軟雅黑", Font.PLAIN, 14);for (Component c : this.getContentPane().getComponents()) {c.setFont(font);if (c instanceof JButton) {((JButton) c).addActionListener(this);}}uidField.addKeyListener(new KeyAdapter() {@Overridepublic void keyPressed(KeyEvent e) {if(e.getKeyCode() == 10){pwdField.requestFocus();}}});pwdField.addKeyListener(new KeyAdapter() {@Overridepublic void keyPressed(KeyEvent e) {System.out.println(e.getKeyCode());if (e.getKeyCode() == 10) {loginButton.doClick();}}});}public static void main(String[] args) {new jFrame().setVisible(true);}@Overridepublic void actionPerformed(ActionEvent e) {if (e.getSource() == loginButton) {String username = uidField.getText();String password = new String(pwdField.getPassword());if (username.equals("admin") && password.equals("123456")) {this.setVisible(false);new newtree(this).setVisible(true);} else {JOptionPane.showMessageDialog(null, "用戶名或密碼錯(cuò)誤！", "錯(cuò)誤",JOptionPane.ERROR_MESSAGE);}} else if (e.getSource() == cancelButton) {System.exit(0);} } }

最后寫一個(gè)Jtree將學(xué)生信息裝進(jìn)去，通過mysql來獲取

package sql; import java.sql.ResultSet; import java.sql.SQLException; import java.awt.*; import java.awt.event.*; import java.io.*; import java.sql.SQLException; import javax.swing.JTextField; import javax.swing.*; import javax.swing.tree.*; import javax.swing.event.*; public class newtree extends JFrame implements TreeSelectionListener { JTextArea text=new JTextArea(100,100);JTree tree=null;private jFrame login;public newtree(jFrame login) { this.login = login;Container contentpane=getContentPane();DefaultMutableTreeNode root=new DefaultMutableTreeNode("信息與計(jì)算機(jī)學(xué)院");DefaultMutableTreeNode node1=new DefaultMutableTreeNode("電子信息");DefaultMutableTreeNode node2=new DefaultMutableTreeNode("物流工程");DefaultMutableTreeNode node3=new DefaultMutableTreeNode("網(wǎng)絡(luò)工程");DefaultMutableTreeNode node4=new DefaultMutableTreeNode("通信工程");root.add(node1); root.add(node2); root.add(node3); root.add(node4); DefaultMutableTreeNode leafnode=new DefaultMutableTreeNode("16電子一班");node1.add(leafnode);leafnode=new DefaultMutableTreeNode("16電子二班");node1.add(leafnode);leafnode=new DefaultMutableTreeNode("16物流一班");node2.add(leafnode);leafnode=new DefaultMutableTreeNode("16網(wǎng)絡(luò)一班");node3.add(leafnode);leafnode=new DefaultMutableTreeNode("16通信一班");node4.add(leafnode);leafnode=new DefaultMutableTreeNode("16通信二班");node4.add(leafnode);tree =new JTree(root);JScrollPane scrollpane=new JScrollPane(text);scrollpane.setHorizontalScrollBarPolicy(JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);scrollpane.setVerticalScrollBarPolicy(JScrollPane.VERTICAL_SCROLLBAR_ALWAYS);JSplitPane splitpane=new JSplitPane(JSplitPane.HORIZONTAL_SPLIT,true,tree,scrollpane); contentpane.add(splitpane);tree.addTreeSelectionListener(this);pack();setVisible(true);setBounds(30,30,500,500);}static String sql = null; static DBHelper db1 = null; static ResultSet ret = null; public void valueChanged(TreeSelectionEvent eo) { if(eo.getSource()==tree){DefaultMutableTreeNode node=(DefaultMutableTreeNode)tree.getLastSelectedPathComponent();if(node.isLeaf()){String str=node.toString();if(str.equals("16電子一班")){ text.setText("");sql = "select *from tb_dianzi1";//SQL語句 db1 = new DBHelper(sql);//創(chuàng)建DBHelper對(duì)象 try { ret = db1.pst.executeQuery();//執(zhí)行語句，得到結(jié)果集 while (ret.next()) { String uid = ret.getString(1); String ufname = ret.getString(2); String uxuehao = ret.getString(3);String usex = ret.getString(4);text.append(uid + "\t" + ufname + "\t" + uxuehao + "\t"+ usex+"\n");} ret.close(); db1.close();//關(guān)閉連接 } catch (SQLException e) { e.printStackTrace(); } }if(str.equals("16電子二班")){ text.setText("");sql = "select *from tb_dianzi2"; db1 = new DBHelper(sql); try { ret = db1.pst.executeQuery(); while (ret.next()) { String uid = ret.getString(1); String ufname = ret.getString(2); String uxuehao = ret.getString(3);String usex = ret.getString(4);text.append(uid + "\t" + ufname + "\t" + uxuehao + "\t"+ usex+"\n");} ret.close(); db1.close(); } catch (SQLException e) { e.printStackTrace(); } }if(str.equals("16通信一班")){ text.setText("");sql = "select *from tb_tongxin1"; db1 = new DBHelper(sql); try { ret = db1.pst.executeQuery(); while (ret.next()) { String uid = ret.getString(1); String ufname = ret.getString(2); String uxuehao = ret.getString(3);String usex = ret.getString(4);text.append(uid + "\t" + ufname + "\t" + uxuehao + "\t"+ usex+"\n");} ret.close(); db1.close(); } catch (SQLException e) { e.printStackTrace(); } }if(str.equals("16通信二班")){ text.setText("");sql = "select *from tb_tongxin2"; db1 = new DBHelper(sql); try { ret = db1.pst.executeQuery();while (ret.next()) { String uid = ret.getString(1); String ufname = ret.getString(2); String uxuehao = ret.getString(3);String usex = ret.getString(4);text.append(uid + "\t" + ufname + "\t" + uxuehao + "\t"+ usex+"\n");}ret.close(); db1.close(); } catch (SQLException e) { e.printStackTrace(); } }if(str.equals("16物流一班")){ text.setText("");sql = "select *from tb_wuliu1"; db1 = new DBHelper(sql); try { ret = db1.pst.executeQuery(); while (ret.next()) { String uid = ret.getString(1); String ufname = ret.getString(2); String uxuehao = ret.getString(3);String usex = ret.getString(4);text.append(uid + "\t" + ufname + "\t" + uxuehao + "\t"+ usex+"\n");} ret.close(); db1.close();//關(guān)閉連接 } catch (SQLException e) { e.printStackTrace(); } }if(str.equals("16網(wǎng)絡(luò)一班")){ text.setText("");sql = "select *from tb_wangluo"; db1 = new DBHelper(sql); try { ret = db1.pst.executeQuery(); while (ret.next()) { String uid = ret.getString(1); String ufname = ret.getString(2); String uxuehao = ret.getString(3);String usex = ret.getString(4);text.append(uid + "\t" + ufname + "\t" + uxuehao + "\t"+ usex+"\n");}ret.close(); db1.close(); } catch (SQLException e) { e.printStackTrace(); } }}}}public static void main(String[] args) { new tree();} }

將三個(gè)類放進(jìn)一個(gè)包里運(yùn)行，默認(rèn)使用的是package sql，是學(xué)校當(dāng)時(shí)學(xué)java時(shí)候的一個(gè)小作業(yè)，都是基本的東西，供初學(xué)者參考

總結(jié)

以上是生活随笔為你收集整理的JAVA小程序简单学籍系统参考代码，登陆小程序，Jtree //Jtree,JDBC,Jframe的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。