import java.io.*;
import java.sql.*;
import java.awt.event.*;
import java.awt.*;
import javax.swing.*;
//import java.util.*;
//import java.io.*;
//import java.net.*;
import java.lang.*;
public class SSDB
{
public static void main(String[] args)
{
MyFrame frame = new MyFrame();
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
frame.setVisible(true);
// frame.pack();
}
}
class MyFrame extends JFrame
{
public MyFrame()
{
setTitle("欢迎登陆");
setSize(LONGTH,WEDITH);
JPanel panel1=new JPanel();
panel1.setSize(180,150);
lb1=new JLabel("用户名");
lb2=new JLabel("密码");
tf1=new JTextField(20);
panel1.setLayout(new GridLayout(2,2));
panel1.add(lb1);
panel1.add(tf1);
panel1.add(lb2);
panel1.add(jpf);
JPanel panel2=new JPanel();
panel2.setSize(180,50);
bt1=new JButton("确定");
bt1.addActionListener(new LisAction());
bt2=new JButton("取消");
bt2.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent event)
{
System.exit(0);
}
});
panel2.add(bt1);
panel2.add(bt2);
add(panel1,BorderLayout.NORTH);
add(panel2,BorderLayout.SOUTH);
}
public class LisAction implements ActionListener
{
public void actionPerformed(ActionEvent event)
{
char password[]=jpf.getPassword();
String str=new String(password);
String username=tf1.getText();
if(username.equals("")||str.equals(""))
{
JOptionPane.showMessageDialog(null,"用户名或密码不能为空!","错误提示",JOptionPane.WARNING_MESSAGE);
}
else
{
try{
Class.forName("org.gjt.mm.mysql.Driver");
Connection conn=null;
conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/hit","root","ever");
Statement stmt = conn.createStatement();
ResultSet rs= stmt.executeQuery("select * from admin");
while(rs.next())
{
String uname = rs.getString(1);
String pwd = rs.getString(2);
if(username.equals(uname)&&str.equals(pwd))
{
tag=true;
rs.close();
break;
}
}
if(tag==false)
{
JOptionPane.showMessageDialog(null,"用户名或密码不正确!","登录失败",JOptionPane.WARNING_MESSAGE);
}
if(tag)
{
if(dialog==null)
{
dialog=new SS();
dialog.showDialog(MyFrame.this);
}
tag=false;
}
}catch(Exception e)
{
e.printStackTrace();
}
}
}
}
private int LONGTH=300;
private int WEDITH=200;
private JLabel lb1,lb2;
private JTextField tf1;
private JPasswordField jpf=new JPasswordField("",20);
private JButton bt1,bt2;
private boolean tag=false;
private SS dialog=null;
private String number;
private String name;
private String sex;
private int age;
//private Date birthday;
private String school;
}
class SS extends JPanel
{
public SS()
{
this.setLayout(new BorderLayout());
JPanel panel1=new JPanel();
JMenuBar jmb=new JMenuBar();
JMenu menu=new JMenu("学生管理");
JMenu menu2=new JMenu("查看");
JMenuItem xuan=new JMenuItem("增加学生");
xuan.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent event)
{
if(stu==null)
{
stu=new Student();
stu.showDialog(SS.this);
}
}
});
JMenuItem xuan1=new JMenuItem("退出");
JMenuItem cha=new JMenuItem("查看信息");
JMenuItem dele=new JMenuItem("清空信息");
dele.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent event)
{
jta.setText("");
jta.append("学号\t"+"姓名\t"+"性别\t"+"年龄\t"+"生日\t"+"学院\n");
}
});
cha.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent event)
{
try{
Class.forName("org.gjt.mm.mysql.Driver");
Connection conn=null;
conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/hit","root","ever");
Statement stmt = conn.createStatement();
ResultSet rs2= stmt.executeQuery("select * from student");
while(rs2.next())
{
String s1,s2,s3,s4,s5,s6;
s1=rs2.getString(1);
s2=rs2.getString(2);
s3=rs2.getString(3);
s4=rs2.getString(4);
s5=rs2.getString(5);
s6=rs2.getString(6);
System.out.println(s1+s2+s3+s4+s5+s6);
setstring(s1,s2,s3,s4,s5,s6);
}
rs2.close();
// stmt.close();
// conn.close();
}catch(Exception e)
{
e.printStackTrace();
}
}
});
menu2.add(cha);
menu2.add(dele);
menu.add(xuan);
menu.add(xuan1);
xuan1.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent event)
{
ok = true;
dialog.setVisible(false);
}
});
jmb.add(menu);
jmb.add(menu2);
panel1.add(jmb);
JToolBar too=new JToolBar();
panel1.add(too);
add(panel1,BorderLayout.NORTH);
JPanel panel2 = new JPanel();
jta.append("学号\t"+"姓名\t"+"性别\t"+"年龄\t"+"生日\t"+"学院\n");
jsp=new JScrollPane(jta);
panel2.add(jsp);
add(panel2, BorderLayout.CENTER);
}
public boolean showDialog(Component parent)
{
ok = false;
Frame owner = null;
if (parent instanceof Frame)
owner = (Frame) parent;
else
owner = (Frame) SwingUtilities.getAncestorOfClass(Frame.class, parent);
if (dialog == null || dialog.getOwner() != owner)
{
dialog = new JDialog(owner, true);
dialog.add(this);
dialog.pack();
}
dialog.setVisible(true);
return ok;
}
public void setstring(String str1,String str2,String str3,String age,String birthday,String str4)
{
// System.out.println("aaaaaaaaaaaaaaaa");
String show=str1+"\t"+str2+"\t"+str3+"\t"+age+"\t"+birthday+"\t"+str4+"\n";
// System.out.println(str1+"\t"+str2+"\t"+str3+"\t"+age+"\t"+birthday+"\t"+str4+"\n");
// System.out.println("bbbbbbbbbbbbbbbbb");
// System.out.println(show);
jta.append(show);
// System.out.println("cccccccccccccccccccccccccc");
}
private boolean ok;
private JDialog dialog;
public JTextArea jta=new JTextArea(10,60);
public JScrollPane jsp;
private Student stu;
}
class Student extends JPanel
{
public Student()
{
JPanel panel1 = new JPanel();
JPanel panel2 = new JPanel();
JPanel panel3 = new JPanel();
JPanel panel4 = new JPanel();
JPanel panel5 = new JPanel();
JPanel panel6 = new JPanel();
JPanel panel7 = new JPanel();
panel1.setSize(250,35);
JLabel lab1=new JLabel("非空,10数字");
JLabel lab11=new JLabel("学号:");
tf1=new JTextField(15);
lab1.setForeground(Color.red);
panel1.add(lab11);
panel1.add(tf1);
panel1.add(lab1);
panel2.setSize(250,35);
JLabel lab2=new JLabel("非空");
lab2.setForeground(Color.red);
JLabel lab22=new JLabel("姓名:");
tf2=new JTextField(15);
panel2.add(lab22);
panel2.add(tf2);
panel2.add(lab2);
panel3.setSize(250,35);
JLabel lab3=new JLabel("性别:");
group=new ButtonGroup();
button1=new JRadioButton("男",false);
button1.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent event)
{
sex=true;
}
没有合适的资源?快使用搜索试试~ 我知道了~
SSDB.rar(MysqL数据库和Java编程)
共1个文件
java:1个
5星 · 超过95%的资源 需积分: 9 9 下载量 67 浏览量
2011-01-18
20:22:40
上传
评论
收藏 3KB RAR 举报
温馨提示
这是Java最后一次实验,要求图形界面,用MysQL实现学生管理系统,主要是添加查找,内容倒不是很难,但是数据库连接部分值得参考
资源推荐
资源详情
资源评论
收起资源包目录
SSDB.rar (1个子文件)
SSDB.java 14KB
共 1 条
- 1
资源评论
- crq20112012-12-18挺不错的资料,节省我很多时间,谢谢!
Jerry_xl
- 粉丝: 51
- 资源: 5
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功