?? window.java
字號:
import java.awt.*;
import javax.swing.*;
import javax.swing.event.*;
import javax.swing.tree.DefaultMutableTreeNode;
import java.awt.event.*;
import java.sql.*;
class Window extends JFrame implements ActionListener,TreeSelectionListener
{
MenuBar m_bar=new MenuBar();
Menu m_user=new Menu("用戶管理"),m_student=new Menu("學生管理"),m_dormitory=new Menu("宿舍管理");
MenuItem m_users=new MenuItem("用戶綜合管理"),s_insert=new MenuItem("學生信息添加"),
s_delete=new MenuItem("學生信息刪除"),s_update=new MenuItem("學生信息修改"),
d_update=new MenuItem("宿舍信息查詢");
MenuItem m_exit=new MenuItem("退出");
Menu m_help=new Menu("聯系我們");
JToolBar t_bar=new JToolBar();
JButton b_insert,b_delete,b_update,bd_update;
JTree tree=null;
JScrollPane jp1,jp2;
JSplitPane js;
JSplitPane sp;
Connection con;
Statement sta;
String conURL="jdbc:mysql://localhost/login?user=root&password=root";
JTable table;
ResultSet rs;
Window()
{
super("宿舍管理系統");
setBounds(150,150,500,300);
this.setResizable(false);
b_insert=new JButton("學生信息添加");
b_delete=new JButton("學生信息刪除");
b_update=new JButton("學生信息修改");
bd_update=new JButton("宿舍信息查詢");
m_bar.add(m_user);
m_bar.add(m_student);
m_bar.add(m_dormitory);
m_user.add(m_users);m_users.setEnabled(true);
m_user.add(m_exit);m_exit.setEnabled(true);
m_student.add(s_insert);s_insert.setEnabled(true);
m_student.add(s_delete);s_delete.setEnabled(true);
m_student.add(s_update);s_update.setEnabled(true);
m_dormitory.add(d_update);d_update.setEnabled(true);
this.setMenuBar(m_bar);
setLayout(new BorderLayout());
add(t_bar,"North");
t_bar.add(b_insert);t_bar.add(b_delete);t_bar.add(b_update);t_bar.add(bd_update);
DefaultMutableTreeNode root;
DefaultMutableTreeNode[][] treeNode;
String[][] data={
{"一層","101宿舍","102宿舍","103宿舍","104宿舍","105宿舍"},
{"二層","201宿舍","202宿舍","203宿舍","204宿舍","205宿舍"},
{"三層","301宿舍","302宿舍","303宿舍","304宿舍","305宿舍"},
{"四層","401宿舍","402宿舍","403宿舍","404宿舍","405宿舍"},
{"五層","501宿舍","502宿舍","503宿舍","504宿舍","505宿舍"},
{"六層","601宿舍","602宿舍","603宿舍","604宿舍","605宿舍"}
};
jp2=new JScrollPane();
root=new DefaultMutableTreeNode("北海樓");
treeNode=new DefaultMutableTreeNode[7][8];
for(int i=0;i<data.length;i++)
{
treeNode[i][0]=new DefaultMutableTreeNode(data[i][0]);
root.add(treeNode[i][0]);
for(int j=1;j<6;j++)
{
treeNode[i][0].add(new DefaultMutableTreeNode(data[i][j]));
}
}
tree=new JTree(root);
jp1=new JScrollPane();
jp1.setViewportView(tree);
sp=new JSplitPane(JSplitPane.HORIZONTAL_SPLIT,true,jp1,jp2);
sp.setDividerLocation(150);
add(sp,"Center");
s_insert.addActionListener(this);
s_delete.addActionListener(this);
s_update.addActionListener(this);
d_update.addActionListener(this);
m_exit.addActionListener(this);
m_users.addActionListener(this);
tree.addTreeSelectionListener(this);
b_insert.addActionListener(this);
b_delete.addActionListener(this);
b_update.addActionListener(this);
bd_update.addActionListener(this);
// new ConSql().consql();
ConSql();
setVisible(true);
}
public void valueChanged(TreeSelectionEvent e)
{
if(e.getSource()==tree)
{
DefaultMutableTreeNode node=(DefaultMutableTreeNode)tree.getLastSelectedPathComponent();
if(node.isLeaf())
{
String str=node.toString();
int z=0;
if(str.equals("101宿舍"))
{
String[] s_data={
"姓名","學號","性別","所在宿舍"};
Object[][] s_d={{"","","",""},{"","","",""},{"","","",""},{"","","",""}};
String s,s1,s2,s3;
try{
con=DriverManager.getConnection(conURL);
rs=sta.executeQuery("select * from student");
int i=0;
while(rs.next())
{
s=rs.getString("name").trim();
s1=rs.getString("s_number").trim();
s2=rs.getString("sex").trim();
s3=rs.getString("d_number").trim();
if(s3.equals("101"))
{
s_d[i][0]=s;
s_d[i][1]=s1;
s_d[i][2]=s2;
s_d[i][3]=s3;
i++;
}
}
}
catch(SQLException e1)
{
e1.printStackTrace();
}
table=new JTable(s_d,s_data);
jp2.setViewportView(table);
}
else if(str.equals("102宿舍"))
{
String[] s_data1={
"姓名","學號","性別","所在宿舍"};
Object[][] s_d={{"","","",""},{"","","",""},{"","","",""},{"","","",""}};
String s,s1,s2,s3;
try{
con=DriverManager.getConnection(conURL);
rs=sta.executeQuery("select * from student");
int i=0;
while(rs.next())
{
s=rs.getString("name").trim();
s1=rs.getString("s_number").trim();
s2=rs.getString("sex").trim();
s3=rs.getString("d_number").trim();
if(s3.equals("102")){
s_d[i][0]=s;
s_d[i][1]=s1;
s_d[i][2]=s2;
s_d[i][3]=s3;
i++;
}
}
}
catch(SQLException e1)
{
e1.printStackTrace();
}
table=new JTable(s_d,s_data1);
jp2.setViewportView(table);
}
else if(str.equals("103宿舍"))
{
String[] s_data2={
"姓名","學號","性別","所在宿舍"};
Object[][] s_d={{"","","",""},{"","","",""},{"","","",""},{"","","",""}};
String s,s1,s2,s3;
try{
con=DriverManager.getConnection(conURL);
rs=sta.executeQuery("select * from student");
int i=0;
while(rs.next())
{
s=rs.getString("name").trim();
s1=rs.getString("s_number").trim();
s2=rs.getString("sex").trim();
s3=rs.getString("d_number").trim();
if(s3.equals("103"))
{
s_d[i][0]=s;
s_d[i][1]=s1;
s_d[i][2]=s2;
s_d[i][3]=s3;
i++;
}
}
}
catch(SQLException e1)
{
e1.printStackTrace();
}
table=new JTable(s_d,s_data2);
jp2.setViewportView(table);
}
else if(str.equals("104宿舍"))
{
String[] s_data3={
"姓名","學號","性別","所在宿舍"};
Object[][] s_d={{"","","",""},{"","","",""},{"","","",""},{"","","",""}};
String s,s1,s2,s3;
try{
con=DriverManager.getConnection(conURL);
rs=sta.executeQuery("select * from student");
int i=0;
while(rs.next())
{
s=rs.getString("name").trim();
s1=rs.getString("s_number").trim();
s2=rs.getString("sex").trim();
s3=rs.getString("d_number").trim();
if(s3.equals("104"))
{
s_d[i][0]=s;
s_d[i][1]=s1;
s_d[i][2]=s2;
s_d[i][3]=s3;
i++;
}
}
}
catch(SQLException e1)
{
e1.printStackTrace();
}
table=new JTable(s_d,s_data3);
jp2.setViewportView(table);
}
else if(str.equals("105宿舍"))
{
String[] s_data4={
"姓名","學號","性別","所在宿舍"};
Object[][] s_d={{"","","",""},{"","","",""},{"","","",""},{"","","",""}};
String s,s1,s2,s3;
try{
con=DriverManager.getConnection(conURL);
rs=sta.executeQuery("select * from student");
int i=0;
while(rs.next())
{
s=rs.getString("name").trim();
s1=rs.getString("s_number").trim();
s2=rs.getString("sex").trim();
s3=rs.getString("d_number").trim();
if(s3.equals("105"))
{
s_d[i][0]=s;
s_d[i][1]=s1;
s_d[i][2]=s2;
s_d[i][3]=s3;
i++;
}
}
}
catch(SQLException e1)
{
e1.printStackTrace();
}
table=new JTable(s_d,s_data4);
jp2.setViewportView(table);
}
else
{
}
}
}
}
public void actionPerformed(ActionEvent e)
{
if((e.getSource()==b_insert)||(e.getSource()==s_insert))
{
new B_insert();
}
else if((e.getSource()==b_delete)||(e.getSource()==s_delete))
{
new B_delete();
}
else if((e.getSource()==b_update)||(e.getSource()==s_update))
{
new B_update();
}
else if((e.getSource()==bd_update)||(e.getSource()==d_update))
{
new BD_update();
}
}
public void ConSql()
{
try{
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection(conURL);
sta=con.createStatement();
}
catch(ClassNotFoundException e){
e.printStackTrace();
}
catch(SQLException e){
e.printStackTrace();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -