JAVA小程序简单学籍系统//Jtree,JDBC,Jframe
我们可以先在JAVA写一个类打开数据库获取连接
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("系统登陆");
this.setResizable(false);
this.setDefaultCloseOperation(DO_NOTHING_ON_CLOSE);
this.setLocationRelativeTo(null);
this.setLayout(null);
this.addWindowListener(new WindowAdapter() {
@Override
public 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() {
@Override
public void keyPressed(KeyEvent e) {
if(e.getKeyCode() == 10){
pwdField.requestFocus();
}
}
});
pwdField.addKeyListener(new KeyAdapter() {
@Override
public 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);
}
@Override
public 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, "用户名或密码错误！", "错误",
JOptionPane.ERROR_MESSAGE);
}
} else if (e.getSource() == cancelButton) {
System.exit(0);
}
}
}
最后写一个Jtree将学生信息装进去，通过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("信息与计算机学院");
DefaultMutableTreeNode node1=new DefaultMutableTreeNode("电子信息");
DefaultMutableTreeNode node2=new DefaultMutableTreeNode("物流工程");
DefaultMutableTreeNode node3=new DefaultMutableTreeNode("网络工程");
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网络一班");
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);//创建DBHelper对象
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_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();//关闭连接
} catch (SQLException e) {
e.printStackTrace();
}
}
if(str.equals("16网络一班"))
{ 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();
}
}
将三个类放进一个包里运行，默认使用的是package sql，是学校当时学java时候的一个小作业，都是基本的东西，供初学者参考
扫一扫
859
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
