学生信息管理系统JAVA.doc

《学生信息管理系统JAVA.doc》由会员分享，可在线阅读，更多相关《学生信息管理系统JAVA.doc（13页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、/*/import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class DB / public static Connection getConn() / mysqljdbctry Class.forName(com.mysql.jdbc.Driver); catch (ClassNotFoundException e) e.printStackTrace();

2、/ String ip = localhost;String dbName = jdbc;String url = jdbc:mysql:/ + ip + / + dbName;/ mysql jdbcConnection conn = null;try conn = DriverManager.getConnection(url, root, 1234); catch (SQLException e) e.printStackTrace();return conn;public static void close(ResultSet rs) if (rs != null) try rs.cl

3、ose(); catch (SQLException e) e.printStackTrace();public static void close(Statement pstmt) if (pstmt != null) try pstmt.close(); catch (SQLException e) e.printStackTrace();public static void close(Connection conn) if (conn != null) try conn.close(); catch (SQLException e) e.printStackTrace();public

4、 static void rollback(Connection conn) if (conn != null) try conn.rollback(); catch (SQLException e) e.printStackTrace();/*删除类*/import java.sql.Connection;import java.sql.SQLException;import java.sql.Statement;public class Drop public void drop(MainFrame frame, String number, String choice) Connecti

5、on con = null;Statement s = null;con = DB.getConn();try if(number.isEmpty()frame.text.append(关键字不能为空！删除失败！nn);return;s = con.createStatement();String str = delete from student where + choice + = + numbertry s.executeUpdate(str);frame.text.append(删除完成！nn); catch (Exception e) / TODO Auto-generated ca

6、tch blockframe.text.append(删除失败！nn);e.printStackTrace();DB.close(s);DB.close(con); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();/*添加类*/import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.SQLException;public class Insert public void insertData(M

7、ainFrame frame, String number, String name,String dept, String grade) / public void insertData() throws SQLException Connection con = null;PreparedStatement s = null;int grades = 0;if (number.isEmpty() | name.isEmpty() frame.text.append(学号或姓名不能为空,插入失败！);return;if(!grade.isEmpty()grades = Integer.par

8、seInt(grade);String str = insert into student values (?,?,?,?);con = DB.getConn();try s = con.prepareStatement(str);s.setString(1, number);s.setString(2, name);s.setString(3, dept);s.setInt(4, grades);try s.executeUpdate();frame.text.append(插入成功！); catch (Exception e) / TODO Auto-generated catch blo

9、ckframe.text.append(插入失败！); catch (SQLException e) DB.close(s);DB.close(con);import java.awt.Button;import java.awt.Choice;import java.awt.Color;import java.awt.FlowLayout;import java.awt.Font;import java.awt.Frame;import java.awt.Graphics;import java.awt.Image;import java.awt.Label;import java.awt.

10、Menu;import java.awt.MenuBar;import java.awt.MenuItem;import java.awt.Panel;import java.awt.TextArea;import java.awt.TextField;import java.awt.Toolkit;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.awt.event.WindowAdapter;import java.awt.event.WindowEvent;public c

11、lass MainFrame extends Frame implements ActionListener private static final long serialVersionUID = 1L;private MenuItem select, insert, delete, update;private TextField rescan, scan, number, name, dept, grade;private Panel panel;private Choice choice;private int flag = 0;private MenuBar jmb;TextFiel

12、d username, password, repassword;Button submit, zhuce;TextArea text;public static void main(String args) / TODO Auto-generated method stubMainFrame frame = new MainFrame();frame.frame();/* 创建主窗口*/public void frame() setSize(400, 400);setTitle(学生信息管理);setLocation(400, 200);/ setDefaultCloseOperation(

13、JFrame.EXIT_ON_CLOSE);/ pack();this.addWindowListener(new WindowAdapter() public void windowClosing(WindowEvent e) setVisible(false);System.exit(-1);setResizable(false);setVisible(true);denglu();public void paint(Graphics g) Image image = Toolkit.getDefaultToolkit().getImage(src/welcom.jpg);g.drawIm

14、age(image, 0, 20, 400, 400, this);/* 对窗口的菜单栏标签进行初始化并添加监听*/public void init() panel = new Panel();jmb = new MenuBar();setMenuBar(jmb);Menu file = new Menu(菜单);Menu exit = new Menu(选项);jmb.add(file);jmb.add(exit);(select = new MenuItem(查询);(insert = new MenuItem(添加);(delete = new MenuItem(删除);(update

15、= new MenuItem(修改);exit.add(new MenuItem(退出登陆);exit.add(new MenuItem(返回);exit.addActionListener(this);select.addActionListener(this);insert.addActionListener(this);delete.addActionListener(this);update.addActionListener(this);/* 事件监听 */Overridepublic void actionPerformed(ActionEvent e) / TODO Auto-g

16、enerated method stubString actionCommand = e.getActionCommand();boolean flags = false;if (登陆.equals(actionCommand) flags = new User().isRight(this, username.getText().trim(),password.getText().trim();if (flags) init();this.removeAll();if (注册.equals(actionCommand) addUser();if (提交.equals(actionComman

17、d) flags = false;flags = this.isEmpty(username.getText().trim(), password.getText().trim(), repassword.getText().trim();if (flags) flags = false;flags = new User().addUser(this,username.getText().trim(), password.getText().trim();if(flags)this.removeAll();denglu();if (重置.equals(actionCommand) userna

18、me.setText();password.setText();repassword.setText();if (退出登陆.equals(actionCommand) this.removeAll();this.remove(jmb);denglu();if (返回.equals(actionCommand) this.removeAll();if (查询.equals(actionCommand) selects();flag = 1;if (添加.equals(actionCommand) insert();flag = 2;if (删除.equals(actionCommand) del

19、ete();flag = 3;if (修改.equals(actionCommand) update();flag = 4;if (确定.equals(actionCommand) if (flag = 1) text.setText();new Select().select(this, scan.getText().trim(),choice.getSelectedItem(); else if (flag = 2) text.setText();new Insert().insertData(this, number.getText().trim(), name.getText().tr

20、im(), dept.getText().trim(), grade.getText().trim(); else if (flag = 3) text.setText();new Drop().drop(this, scan.getText().trim(),choice.getSelectedItem();new Select().select(this, , all); else text.setText();new Update().update(this, scan.getText().trim(), rescan.getText().trim(), choice.getSelect

21、edItem();/* 创建登录窗口 */public void denglu() panel = new Panel();Font font = new Font(宋体, 20, 18);panel.setBackground(Color.gray);panel.setLayout(null);username = new TextField(20);password = new TextField(20);Label lusername = new Label(用户名：);Label lpassword = new Label(密 码：);submit = new Button(登陆);z

22、huce = new Button(注册);lusername.setFont(font);username.setFont(font);lpassword.setFont(font);password.setFont(font);lusername.setBounds(90, 70, 60, 50);username.setBounds(180, 80, 120, 25);lpassword.setBounds(90, 108, 60, 50);password.setBounds(180, 113, 120, 25);submit.setBounds(180, 150, 50, 30);z

23、huce.setBounds(240, 150, 50, 30);panel.add(lusername);panel.add(username);panel.add(lpassword);panel.add(password);panel.add(submit);panel.add(zhuce);submit.addActionListener(this);zhuce.addActionListener(this);add(panel);init();this.remove(jmb);/* 注册窗口*/public void addUser() this.removeAll();panel

24、= new Panel();Font font = new Font(宋体, 20, 18);panel.setBackground(Color.gray);panel.setLayout(null);username = new TextField(20);password = new TextField(20);repassword = new TextField(20);/ username.setFont();Label lusername = new Label(用户名：);Label lpassword = new Label(密 码：);Label rlpassword = ne

25、w Label(重 复：);submit = new Button(提交);zhuce = new Button(重置);lusername.setFont(font);username.setFont(font);lpassword.setFont(font);password.setFont(font);rlpassword.setFont(font);repassword.setFont(font);lusername.setBounds(90, 70, 60, 50);username.setBounds(180, 80, 130, 25);lpassword.setBounds(90

26、, 108, 60, 50);password.setBounds(180, 120, 130, 25);rlpassword.setBounds(90, 152, 60, 50);repassword.setBounds(180, 160, 130, 25);submit.setBounds(180, 200, 50, 30);zhuce.setBounds(250, 200, 50, 30);panel.add(lusername);panel.add(username);/ username.setLocation(100, 100);panel.add(lpassword);panel

27、.add(password);panel.add(rlpassword);panel.add(repassword);panel.add(submit);panel.add(zhuce);submit.addActionListener(this);zhuce.addActionListener(this);add(panel);init();this.remove(jmb);/* 创建查询窗口*/public void selects() this.removeAll();panel = new Panel();panel.add(new Label(查找的关键字:);panel.setLa

28、yout(new FlowLayout(FlowLayout.LEFT);submit = new Button(确定);scan = new TextField(30);choice = new Choice();text = new TextArea(10, 50);text.setEditable(false);choice.add(name);choice.add(number);choice.add(dept);choice.add(all);panel.add(scan);panel.add(new Label(查找方式:);panel.add(choice);panel.add(

29、submit);panel.add(text);submit.addActionListener(this);add(panel);init();/* 创建插入窗口 */public void insert() this.removeAll();submit = new Button(确定);panel = new Panel();panel.setLayout(new FlowLayout(FlowLayout.LEFT);panel.add(new Label(学号:);number = new TextField(40);panel.add(number);panel.add(new L

30、abel(姓名:);name = new TextField(40);panel.add(name);panel.add(new Label(系别:);dept = new TextField(40);panel.add(dept);panel.add(new Label(成绩:);grade = new TextField(40);panel.add(grade);panel.add(submit);text = new TextArea(10, 50);text.setEditable(false);panel.add(text);submit.addActionListener(this

31、);add(panel);init();/* 创建删除窗口 */public void delete() this.removeAll();panel = new Panel();panel.add(new Label(删除的关键字);panel.setLayout(new FlowLayout(FlowLayout.LEFT);submit = new Button(确定);text = new TextArea(10, 50);text.setEditable(false);scan = new TextField(30);choice = new Choice();choice.add(

32、name);choice.add(number);choice.add(dept);panel.add(scan);panel.add(new Label(删除方式:);panel.add(choice);panel.add(submit);panel.add(text);submit.addActionListener(this);add(panel);init();/* 创建修改窗口*/public void update() this.removeAll();panel = new Panel();panel.setLayout(new FlowLayout(FlowLayout.LEF

33、T);submit = new Button(确定);scan = new TextField(30);rescan = new TextField(30);choice = new Choice();text = new TextArea(10, 50);text.setEditable(false);choice.add(name);choice.add(number);choice.add(dept);choice.add(grade);panel.add(new Label(要修改的学号：);panel.add(scan);panel.add(new Label(修改后的内容：);pa

34、nel.add(rescan);panel.add(new Label(要修改的内容：);panel.add(choice);panel.add(submit);panel.add(text);submit.addActionListener(this);add(panel);init();/* 对注册的窗口输入内容进行判断是否为空*/public boolean isEmpty(String username, String password, String repassword) if (username.isEmpty() this.username.setText(用户名不能为空);r

35、eturn false;if (password.isEmpty() this.password.setText(密码不能为空);return false;if (password.equals(repassword) = false) this.password.setText(密码不一致);return false;return true;/*/import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class Sel

36、ect public void select(MainFrame frame, String number, String choice) Connection con = null;Statement s = null;ResultSet rs = null;boolean flag = false;if (number.isEmpty() & all.equals(choice) = false) frame.text.append();return;con = DB.getConn();String str = select * from student where + choice +

37、 = + numberif (all.equals(choice) str = select * from student;try s = con.createStatement();rs = s.executeQuery(str);frame.text.append(ttttttnn);while (rs.next() byte namebuffer = new byte512;byte deptbuffer = new byte512;namebuffer = rs.getBytes(name);deptbuffer = rs.getBytes(dept);String name = ne

38、w String(namebuffer);String dept = new String(deptbuffer);flag = true;frame.text.append(rs.getString(number) + tt + name + tt+ dept + tt + rs.getString(grade) + n);if (flag = false)frame.text.append();DB.close(rs);DB.close(s);DB.close(con); catch (SQLException e) /*更新类*/import java.sql.Connection;im

39、port java.sql.SQLException;import java.sql.Statement;public class Update public void update(MainFrame frame, String scan, String rescan,String choice) Connection con = null;Statement s = null;if(scan.isEmpty()|rescan.isEmpty()frame.text.append(内容不能为空！，更新失败！);return;con = DB.getConn();String sql = up

40、date student set + choice + = + rescan+ where number = + + scan + ;if (grade.equals(choice) sql = update student set + choice + =+ Integer.parseInt(rescan) + where number = + + scantry s = con.createStatement();s.executeUpdate(sql);frame.text.append(修改成功！);DB.close(s);DB.close(s); catch (SQLException e) / TODO Auto-generated catch blockframe.text.append(修改失败！);e.printStackTrace();/*用户管理类*/import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class User public boolean isRight(MainFrame frame, String