蜜桃视频网站在线观看,国产91精品在线,国产精品视频播放

package jiemian;
import java.awt.Color;
import java.awt.Container;
import java.awt.Dimension;
import java.awt.Font;
import java.awt.GridLayout;
import java.awt.Image;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JPasswordField;
import javax.swing.JTextField;
import javax.swing.WindowConstants;
import db.connectDb;
public class Login extends JFrame implements ActionListener {
private JLabel han_biaoti_label;
private JLabel english_biaoti_label;
private JLabel user_label;
private JTextField user_field;
private JLabel user_password_label;
private JPasswordField user_password;
private JButton login_button;
private JButton exit_button;
public Login() {
Font max = new Font("楷體", Font.BOLD, 40);// 定義字體大小
Font min = new Font("TimesRoman", Font.ITALIC, 20);
JPanel jpanel = new JPanel();// 面板
this.setContentPane(jpanel);// 為窗體添加一個(gè)面板】
GridLayout gird = new GridLayout(3, 0); // 建立一個(gè)表格的版面對(duì)象。rows代表有幾行，cols代表有幾列
jpanel.setLayout(gird);// 將表格面板添加到面板
ImageIcon iconBackground = new ImageIcon("src/background.jpg");// 導(dǎo)入背景圖片
JLabel imgLabel = new JLabel(iconBackground);// 將背景添加到一個(gè)Label標(biāo)簽中
int width = 500; // 面板寬
int height = 350; // 面板高
iconBackground.setImage(iconBackground.getImage().getScaledInstance(
width, height, Image.SCALE_DEFAULT)); // 設(shè)置背景圖片大小，且按比例縮小填充
this.getContentPane().add(imgLabel, new Integer(Integer.MIN_VALUE));// 設(shè)置imaLabel是面板的最底層
imgLabel.setSize(500, 350);
this.getLayeredPane().setLayout(null);
this.setDefaultCloseOperation(WindowConstants.EXIT_ON_CLOSE);// 設(shè)置退出按鈕有效
jpanel.setOpaque(false);// 設(shè)置面板不透明
countComponents();// 構(gòu)造一個(gè)新的 Container容器。
this.getLayeredPane().add(imgLabel, new Integer(Integer.MIN_VALUE));
imgLabel.setSize(500, 350);
this.getLayeredPane().setLayout(null);
this.setDefaultCloseOperation(WindowConstants.EXIT_ON_CLOSE);
this.setTitle("學(xué)生信息管理系統(tǒng)");
Dimension dimension = Toolkit.getDefaultToolkit().getScreenSize();// 返回當(dāng)前分辨率
this.setBounds(((int) dimension.getWidth() - 500) / 2,
((int) dimension.getHeight() - 380) / 2, width, height);// 設(shè)置窗體在屏幕上的位置，通過(guò)dimension獲取屏幕，
this.setResizable(false);// 設(shè)置窗體不可以調(diào)整大小
this.setLayout(null);// 默認(rèn)布局
this.setDefaultCloseOperation(this.EXIT_ON_CLOSE);
han_biaoti_label = new JLabel("學(xué)生信息管理系統(tǒng)");
han_biaoti_label.setBounds(50, 40, 400, 40);
han_biaoti_label.setFont(max);
this.add(han_biaoti_label);
english_biaoti_label = new JLabel("Student information Manager System");
english_biaoti_label.setBounds(110, 80, 400, 40);
english_biaoti_label.setFont(min);
this.add(english_biaoti_label);
user_label = new JLabel("用戶名:");
user_label.setBounds(100, 150, 70, 30);
user_label.setFont(min);
this.add(user_label);
user_field = new JTextField();
user_field.setBounds(190, 150, 180, 30);
this.add(user_field);
user_password_label = new JLabel("密碼:");
user_password_label.setBounds(100, 200, 70, 30);
user_password_label.setFont(min);
this.add(user_password_label);
user_password = new JPasswordField();
user_password.setBounds(190, 200, 180, 30);
this.add(user_password);
login_button = new JButton("登錄");
login_button.setBounds(120, 260, 100, 35);
login_button.setFont(min);
//System.out.println("ssss");
login_button.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
//System.out.println("ssss");
String user_name = user_field.getText();
String user_pw = user_password.getText();
try {
//System.out.println("ssss");
Connection con = null; // 定義一個(gè)MYSQL鏈接對(duì)象
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager
.getConnection(
"jdbc:mysql://127.0.0.1:3306/student_register_manager",
"root", "54zhangqi"); // 鏈接本地MYSQL
Statement stat=con.createStatement();//聲明
ResultSet res= stat.executeQuery("select * from user_register");//執(zhí)行查詢
if (res.next()) {
if (res.getString("user_name").equals(user_name)&&res.getString("user_password").equals(user_pw)) {
dispose();
new Main();
} else {
JOptionPane.showMessageDialog(null, "登錄失敗！", "提示",
JOptionPane.ERROR_MESSAGE);
}
}
} catch (Exception e2) {
System.out.println("yc"+e2.getMessage());
}
}
});
this.add(login_button);
exit_button = new JButton("退出");
exit_button.setBounds(260, 260, 100, 35);
exit_button.setFont(min);
exit_button.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
System.exit(0);
}
});
this.add(exit_button);
this.setVisible(true);
}
public static void main(String[] args) {
new Login();
}
public void actionPerformed(ActionEvent e) {
// TODO Auto-generated method stub
}
}
package jiemian;
import java.awt.Color;
import java.awt.Font;
import java.awt.GridLayout;
import java.awt.Image;
import java.awt.MenuBar;
import java.awt.Window;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import javax.swing.ImageIcon;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JMenu;
import javax.swing.JMenuBar;
import javax.swing.JMenuItem;
import javax.swing.JPanel;
import javax.swing.JPasswordField;
import javax.swing.WindowConstants;
import menuItem_jiemian.banjiInfor;
import menuItem_jiemian.banjiInforXiugai;
import menuItem_jiemian.kaifaInfor;
import menuItem_jiemian.personInforXiugai;
import menuItem_jiemian.personInformation;
import menuItem_jiemian.pwMimaxiugai;
import menuItem_jiemian.xinZeng;
public class Main extends JFrame implements ActionListener {
private JLabel jLabel1;
private JLabel jLabel2;
private JLabel jLabel3;
private JMenu help_menu;
private JMenu information_weihu;
private JMenu infor_check;
private JMenu guanyu;
public Main() {
// 創(chuàng)建窗體事件
addWindowListener(new WindowAdapter() {
public void windowClosing(final WindowEvent e) {
Main.this.dispose();
}
});
Font max=new Font("楷體",Font.BOLD,48);
Font min=new Font("楷體",Font.ITALIC,32);
JPanel jPanel = new JPanel();
this.setContentPane(jPanel);
GridLayout gridLayout = new GridLayout(3, 0);
jPanel.setLayout(gridLayout);
ImageIcon ima_main_background = new ImageIcon("src/main_background.jpg");
JLabel ima_background_label = new JLabel(ima_main_background);
int height = 500;
int width = 700;
ima_main_background.setImage(ima_main_background.getImage()
.getScaledInstance(width, height, Image.SCALE_DEFAULT));
ima_background_label.setSize(width, height);
this.getLayeredPane().add(ima_background_label,
new Integer(Integer.MIN_VALUE));
this.setDefaultCloseOperation(WindowConstants.EXIT_ON_CLOSE);
jPanel.setOpaque(false);// 設(shè)置面板不透明
this.setResizable(false);
countComponents();// 構(gòu)造一個(gè)新的 Container容器。
setTitle("學(xué)生信息管理系統(tǒng)");
setBounds(350, 150, 700, 500);// 設(shè)置位置
this.setLayout(null);
jLabel1=new JLabel("明德至善");
jLabel1.setFont(max);
jLabel1.setBounds(120, 100, 400, 50);
this.add(jLabel1);
jLabel2=new JLabel("博學(xué) 篤行");
jLabel2.setFont(max);
jLabel2.setBounds(220, 190, 400, 50);
this.add(jLabel2);
jLabel3=new JLabel("——淮南師范學(xué)院");
jLabel3.setFont(min);
jLabel3.setBounds(380, 280, 400, 50);
jLabel3.setForeground(Color.BLUE);
this.add(jLabel3);
JMenuBar bar = new JMenuBar();
information_weihu = new JMenu("信息維護(hù)");
JMenuItem person_check_infor = new JMenuItem("個(gè)人信息查詢");
person_check_infor.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
new personInformation();
}
});
JMenuItem pw_xiugai = new JMenuItem("密碼修改");
pw_xiugai.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
new pwMimaxiugai();
}
});
information_weihu.add(person_check_infor);
information_weihu.add(pw_xiugai);
infor_check=new JMenu("信息查詢");
JMenuItem banji_infor_check=new JMenuItem("班級(jí)信息查詢");
banji_infor_check.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
new banjiInfor();
}
});
JMenuItem banji_infor_tianjia=new JMenuItem("同學(xué)信息添加");
banji_infor_tianjia.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
new xinZeng();
}
});
JMenuItem banji_infor_xiugai=new JMenuItem("班級(jí)信息修改");
banji_infor_xiugai.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
new banjiInforXiugai();
}
});
JMenuItem person_infor_xiugai=new JMenuItem("個(gè)人信息修改");
person_infor_xiugai.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
new personInforXiugai();
}
});
infor_check.add(banji_infor_check);
infor_check.add(banji_infor_tianjia);
infor_check.add(banji_infor_xiugai);
infor_check.add(person_infor_xiugai);
help_menu=new JMenu("幫助");
JMenuItem help_item=new JMenuItem("幫助");
help_item.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
}
});
help_menu.add(help_item);
guanyu =new JMenu("關(guān)于");
JMenuItem guanyu_kaifa=new JMenuItem("開(kāi)發(fā)人員");
guanyu_kaifa.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
new kaifaInfor();
}
});
guanyu.add(guanyu_kaifa);
bar.add(infor_check);
bar.add(information_weihu);
bar.add(help_menu);
bar.add(guanyu);
setJMenuBar(bar);// 在窗口中添加菜單欄
this.setVisible(true);
}
public static void main(String[] args) {
new Main();
}
@Override
public void actionPerformed(ActionEvent e) {
// TODO Auto-generated method stub
}
}
package db;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class connectDb {
private Connection con;
private Statement stat;
public connectDb() {
try {
Class.forName("com.mysql.jdbc.Driver"); //MYSQL驅(qū)動(dòng)
con = DriverManager
.getConnection(
"jdbc:mysql://127.0.0.1:3306/student_register_manager",
"root", "54zhangqi"); // 鏈接本地MYSQL
stat=con.createStatement();//聲明
} catch (Exception e) {
System.out.print("MYSQL ERROR:" + e.getMessage());
}
try {
stat = con.createStatement();
} catch (SQLException e) {
e.printStackTrace();
}
}
public java.sql.ResultSet query(String sql) throws SQLException {
return stat.executeQuery(sql);
}
/**
* 執(zhí)行
* @param sql
* @return
* @throws SQLException
*/
public Boolean execute(String sql) throws SQLException {
return stat.execute(sql);
}
}
package menuItem_jiemian;
import java.awt.Color;
import java.awt.Font;
import java.awt.Window;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.sql.ResultSet;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JTextField;
import javax.swing.WindowConstants;
import db.connectDb;
import jiemian.Main;
public class personInformation extends JFrame implements ActionListener{
//學(xué)號(hào)
private JLabel jl_student_number;
private JTextField jt_student_number;
private JButton jb_student_number;
// private JLabel jl_student_name;
// private JButton jb_student_name;
//姓名
private JLabel jl_name;
private JTextField jt_name;
//性別
private JLabel jl_sex;
private JTextField jt_sex;
//民族
private JLabel jl_nation;
private JTextField jt_nation;
//照片
private JLabel jl_photo;
private JLabel photo;
//學(xué)院
private JLabel jl_xueyuan;
private JTextField jt_xueyuan;
//專業(yè)
private JLabel jl_zhuanye;
private JTextField jt_zhuanye;
//班級(jí)
private JLabel jl_banji;
private JTextField jt_banji;
//聯(lián)系方式
private JLabel jl_mobile_phone;
private JTextField jt_mobile_phone;
//QQ
private JLabel jl_qq_number;
private JTextField jt_qq_number;
//郵編
private JLabel jl_youbian;
private JTextField jt_youbian;
//父母姓名
private JLabel jl_father;
private JLabel jl_mather;
private JTextField jt_father;
private JTextField jt_mather;
//家庭住址
private JLabel jl_home_address;
private JTextField jt_home_address;
//備注
private JLabel jl_jiangcheng;
private JTextField jt_jiangcheng;
//窗體事件
public personInformation(){
addWindowListener(new WindowAdapter() {
public void WindowClose(Window event) {
personInformation.this.dispose();
}
});
Font kaiti1=new Font("kaiti", Font.BOLD, 20);
Font kaiti2=new Font("kaiti", Font.BOLD, 16);
JPanel jPanel=new JPanel();
this.setContentPane(jPanel);
// GridLayout layout=new GridLayout(3, 0);//定義grid布局
// jPanel.setLayout(layout);//向面板中添加布局
this.setDefaultCloseOperation(WindowConstants.EXIT_ON_CLOSE);
jPanel.setOpaque(false);
setTitle("學(xué)生信息查詢");
setBounds(250,50,900,600);
this.setResizable(false);// 設(shè)置窗體不可以調(diào)整大小
this.setLayout(null);
jl_student_number=new JLabel("學(xué)號(hào):");
jl_student_number.setBounds(250,25,80,30);
jl_student_number.setFont(kaiti1);
this.add(jl_student_number);
jt_student_number=new JTextField();
jt_student_number.setBounds(320, 25, 170, 30);
jt_student_number.setFont(kaiti1);
this.add(jt_student_number);
jb_student_number=new JButton("查詢");
jb_student_number.setBounds(500, 25, 100, 30);
jb_student_number.setFont(kaiti1);
jb_student_number.addActionListener(this);
this.add(jb_student_number);
jl_name=new JLabel("姓名:");
jl_name.setBounds(50, 80, 80, 30);
jl_name.setFont(kaiti1);
this.add(jl_name);
jt_name=new JTextField();
jt_name.setBounds(120, 80, 120, 30);
jt_name.setFont(kaiti2);
jt_name.setHorizontalAlignment(JTextField.CENTER);
this.add(jt_name);
jl_sex=new JLabel("性別:");
jl_sex.setBounds(270, 80, 80, 30);
jl_sex.setFont(kaiti1);
this.add(jl_sex);
jt_sex=new JTextField();
jt_sex.setBounds(340, 80, 40, 30);
jt_sex.setFont(kaiti2);
jt_sex.setHorizontalAlignment(JTextField.CENTER);
this.add(jt_sex);
jl_nation=new JLabel("民族:");
jl_nation.setBounds(410, 80, 80, 30);
jl_nation.setFont(kaiti1);
this.add(jl_nation);
jt_nation=new JTextField();
jt_nation.setBounds(480, 80, 120, 30);
jt_nation.setFont(kaiti2);
jt_nation.setHorizontalAlignment(JTextField.CENTER);
this.add(jt_nation);
jl_photo=new JLabel("照片:");
jl_photo.setBounds(630, 80, 80, 30);
jl_photo.setFont(kaiti1);
this.add(jl_photo);
photo=new JLabel();
photo.setBounds(680, 80, 100, 120);
photo.setBackground(Color.black);
this.add(photo);
jl_xueyuan=new JLabel("學(xué) 院:");
jl_xueyuan.setBounds(50, 150, 80, 30);
jl_xueyuan.setFont(kaiti1);
this.add(jl_xueyuan);
jt_xueyuan=new JTextField();
jt_xueyuan.setBounds(120, 150, 120, 30);
jt_xueyuan.setFont(kaiti2);
jt_xueyuan.setHorizontalAlignment(JTextField.CENTER);
this.add(jt_xueyuan);
jl_zhuanye=new JLabel("專業(yè):");
jl_zhuanye.setBounds(270, 150, 80, 30);
jl_zhuanye.setFont(kaiti1);
this.add(jl_zhuanye);
jt_zhuanye=new JTextField();
jt_zhuanye.setBounds(340, 150, 180, 30);
jt_zhuanye.setFont(kaiti2);
jt_zhuanye.setHorizontalAlignment(JTextField.CENTER);
this.add(jt_zhuanye);
jl_banji=new JLabel("班級(jí):");
jl_banji.setBounds(540,150, 80, 30);
jl_banji.setFont(kaiti1);
this.add(jl_banji);
jt_banji=new JTextField();
jt_banji.setBounds(610, 150, 83, 30);
jt_banji.setFont(kaiti2);
jt_banji.setHorizontalAlignment(JTextField.CENTER);
this.add(jt_banji);
jl_mobile_phone=new JLabel("聯(lián)系方式:");
jl_mobile_phone.setBounds(50, 210, 100, 30);
jl_mobile_phone.setFont(kaiti1);
this.add(jl_mobile_phone);
jt_mobile_phone=new JTextField();
jt_mobile_phone.setBounds(160, 210, 180, 30);
jt_mobile_phone.setFont(kaiti2);
jt_mobile_phone.setHorizontalAlignment(JTextField.CENTER);
this.add(jt_mobile_phone);
jl_qq_number=new JLabel("QQ號(hào):");
jl_qq_number.setBounds(360, 210, 80, 30);
jl_qq_number.setFont(kaiti1);
this.add(jl_qq_number);
jt_qq_number=new JTextField();
jt_qq_number.setBounds(425, 210, 180, 30);
jt_qq_number.setFont(kaiti2);
jt_qq_number.setHorizontalAlignment(JTextField.CENTER);
this.add(jt_qq_number);
jl_youbian=new JLabel("郵編:");
jl_youbian.setBounds(625, 210, 80, 30);
jl_youbian.setFont(kaiti1);
this.add(jl_youbian);
jt_youbian=new JTextField();
jt_youbian.setBounds(720, 210, 100, 30);
jt_youbian.setFont(kaiti2);
jt_youbian.setHorizontalAlignment(JTextField.CENTER);
this.add(jt_youbian);
jl_father=new JLabel("父親:");
jl_father.setBounds(50, 270, 80, 30);
jl_father.setFont(kaiti1);
this.add(jl_father);
jt_father=new JTextField();
jt_father.setBounds(130, 270, 100, 30);
jt_father.setFont(kaiti2);
jt_father.setHorizontalAlignment(JTextField.CENTER);
this.add(jt_father);
jl_mather=new JLabel("母親:");
jl_mather.setBounds(255, 270, 80, 30);
jl_mather.setFont(kaiti1);
this.add(jl_mather);
jt_mather=new JTextField();
jt_mather.setBounds(340, 270, 100, 30);
jt_mather.setFont(kaiti2);
jt_mather.setHorizontalAlignment(JTextField.CENTER);
this.add(jt_mather);
jl_home_address=new JLabel("家庭住址:");
jl_home_address.setBounds(50, 330, 100, 30);
jl_home_address.setFont(kaiti1);
this.add(jl_home_address);
jt_home_address=new JTextField();
jt_home_address.setBounds(160,330, 660, 30);
jt_home_address.setFont(kaiti2);
jt_home_address.setHorizontalAlignment(JTextField.CENTER);
this.add(jt_home_address);
jl_jiangcheng=new JLabel("獎(jiǎng) 懲:");
jl_jiangcheng.setBounds(50, 390, 80, 30);
jl_jiangcheng.setFont(kaiti1);
this.add(jl_jiangcheng);
jt_jiangcheng=new JTextField();
jt_jiangcheng.setBounds(150, 390, 660, 160);
jt_jiangcheng.setFont(kaiti2);
jt_jiangcheng.setHorizontalAlignment(JTextField.CENTER);
this.add(jt_jiangcheng);
this.setVisible(true);
}
public static void main(String args[]){
new personInformation();
}
@Override
public void actionPerformed(ActionEvent e) {
Object button =e.getSource();
connectDb db=new connectDb();
String student_number_check=jt_student_number.getText();
//System.out.println("sss");
if (button.equals(jb_student_number)) {
//System.out.println("sss");
String sql="select * from student_infor";
ResultSet rs = null;//執(zhí)行查詢
try {
rs=db.query(sql);
if (rs.next()) {
if (rs.getString("student_number").equals(student_number_check)) {
//System.out.println("sss"); jt_name.setText(rs.getString("student_name")); jt_sex.setText(rs.getString("student_sex"));
jt_nation.setText(rs.getString("nation")); jt_xueyuan.setText(rs.getString("xueyuan")); jt_zhuanye.setText(rs.getString("zhuanye"));
jt_banji.setText(rs.getString("banji")); jt_mobile_phone.setText(rs.getString("mobile_telephone")); jt_qq_number.setText(rs.getString("QQ_number")); jt_youbian.setText(rs.getString("youbian")); jt_father.setText(rs.getString("father_name")); jt_mather.setText(rs.getString("mather_name")); jt_home_address.setText(rs.getString("home_address")); jt_jiangcheng.setText(rs.getString("jiangcheng"));
}
}
} catch (Exception e2) {
System.out.println("出錯(cuò)"+e2.getMessage());
}
} else {
}
}
}

復(fù)制代碼

久久久久久久999_99精品久久精品一区二区爱城_成人欧美一区二区三区在线播放_国产精品日本一区二区不卡视频_国产午夜视频_欧美精品在线观看免费