public void actionPerformed(ActionEvent e){ Object obj=e.getSource(); if(obj==m5){System.exit(0);} else{if(obj==add1){
card.show(pCenter,\增加学生界面\}
else{if(obj==updata1){
card.show(pCenter,\修改学生界面\}
else{if(obj==delete1){
card.show(pCenter, \删除学生界面\}
else{if(obj==add2){
card.show(pCenter, \增加课程界面\}
else{if(obj==delete2){
card.show(pCenter, \删除课程界面\}
else{if(obj==updata2){
card.show(pCenter, \修改课程界面\}
else{if(obj==add3){
card.show(pCenter, \增加选课界面\}
else{if(obj==delete3){
card.show(pCenter, \删除选课界面\}
else{if(obj==updata3){
card.show(pCenter, \修改选课界面\}
else{if(obj==学生查询){
card.show(pCenter, \学生查询界面\}}
}}}}}}}}}}
public static void main(String[] args) { new Menu(); }
SelC.java:
import java.sql.*;
import java.awt.*;
import java.awt.event.*; import javax.swing.*;
import java.util.*;
public class SelC extends JFrame { Vector rowData, columnNames; Statement stmt=null; String sql=null; JTable jt = null;
JScrollPane jsp = null;
PreparedStatement ps=null; ResultSet rs=null;
public SelC(String sql1){
columnNames = new Vector(); // 设置列名
columnNames.add(\课号\columnNames.add(\课名\
rowData=new Vector(); sql=sql1; try{
Connection dbConn1=CONN();
stmt=(Statement)dbConn1.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); rs=stmt.executeQuery(sql);
while(rs.next()){
Vector hang = new Vector();
hang.add(rs.getString(\
hang.add(rs.getString(\rowData.add(hang);}
jt=new JTable(rowData,columnNames); jsp=new JScrollPane(jt); this.add(jsp);
this.setSize(400,300); this.setVisible(true);
}catch(SQLException e1){
System.out.print(\ } }
//连接数据库方法
public static Connection CONN(){
String driverName = \ //加载JDBC驱动 String dbURL = \DatabaseName=student\ //连接服务器和数据库test
String userName = \ //默认用户名 String userPwd = \ //密码 Connection dbConn=null;
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println(\Successful!\ //如果连接成功 控制台输出Connection Successful!
} catch (Exception e) { e.printStackTrace(); }
return dbConn; } }
SelSC.java:
import java.sql.*; import javax.swing.*;
import java.util.*;
public class SelSC extends JFrame { Vector rowData, columnNames; Statement stmt=null; String sql=null; JTable jt = null; JScrollPane jsp = null; PreparedStatement ps=null; ResultSet rs=null; public SelSC(String sql1){ columnNames = new Vector(); // 设置列名 columnNames.add(\课号\ columnNames.add(\课名\ columnNames.add(\学号\ columnNames.add(\姓名\
columnNames.add(\成绩\ rowData=new Vector(); sql=sql1; try{ Connection dbConn1=CONN(); stmt=(Statement)dbConn1.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); rs=stmt.executeQuery(sql); while(rs.next()){ Vector hang = new Vector(); hang.add(rs.getString(\ hang.add(rs.getString(\ hang.add(rs.getString(\ hang.add(rs.getString(\ hang.add(rs.getString(\ rowData.add(hang);} jt=new JTable(rowData,columnNames); jsp=new JScrollPane(jt); this.add(jsp); this.setSize(400,300); this.setVisible(true); }catch(SQLException e1){ System.out.print(\ } } // 连接数据库方法 public static Connection CONN(){ String driverName = \ //加载JDBC驱动 String dbURL = \DatabaseName=student\ //连接服务器和数据库test String userName = \ //默认用户名 String userPwd = \ //密码 Connection dbConn=null; try { Class.forName(driverName); dbConn = DriverManager.getConnection(dbURL, userName, userPwd); System.out.println(\Successful!\ //如果连接成功 控制台输出Connection Successful!
} catch (Exception e) { e.printStackTrace(); } return dbConn; } }
Selstu.java:
import java.awt.*;
import java.awt.event.*; import java.sql.*; import javax.swing.*;
public class Selstu extends JPanel implements ActionListener{ JTextField 学号,姓名,系别; JButton 查找; JTextField 课号,课名; JButton 查找1; JTextField 课号1,学号1,成绩; JButton 查找2; public Selstu (){ 学号=new JTextField(12); 姓名=new JTextField(12); 系别=new JTextField(12); 课号=new JTextField(12); 课名=new JTextField(12); 课号1=new JTextField(12); 学号1=new JTextField(12); 成绩=new JTextField(12); 查找=new JButton(\查找学生信息\ 查找1=new JButton(\查找课程信息\ 查找2=new JButton(\查找选课信息\ Box box1=Box.createHorizontalBox();//横放box Box box2=Box.createHorizontalBox(); Box box4=Box.createHorizontalBox(); Box box5=Box.createHorizontalBox(); Box box6=Box.createHorizontalBox(); Box box7=Box.createHorizontalBox(); box1.add(new JLabel(\学号:\ box1.add(学号);