实验选课系统代码设计与界面设计

代码设计和界面设计

1：用户主界面：

package 课程设计;

import javax.swing.*;

import java.awt.event.*;

import java.awt.*;

public class Main extends JPanel implements ActionListener{

JFrame jf;

JLabel j1,j2,j3,j4;

JButton b1,b2,b3,b4;

public void add(Component c,GridBagConstraints gc,int x,int y,int w,int h){

gc.gridx=x;

gc.gridy=y;

gc.gridwidth=w;

gc.gridheight=h;

add(c,gc);}

public void gui(){

jf=new JFrame("登录");

jf.addWindowListener(new WindowAdapter(){

public void windoeClose(WindowEvent e){

System.exit(0); } });

jf.setVisible(true);

Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();

Dimension frameSize = jf.getPreferredSize();

jf.setLocation((screenSize.width - frameSize.width)/2, (screenSize.height - frameSize.height)/2);

GridBagLayout g1=new GridBagLayout();

setLayout(g1);

jf.add(this,BorderLayout.CENTER);

GridBagConstraints gc=new GridBagConstraints();

gc.insets=new Insets(10,10,10,10);

j1=new JLabel("请您先登录");

j1.setFont(new Font("宋体",Font.BOLD,60));

j1.setForeground(Color.red);

j2=new JLabel("管理员:");

j2.setFont(new Font("宋体",Font.BOLD,30));

j2.setForeground(Color.cyan);

j3=new JLabel("老师:");

j3.setFont(new Font("宋体",Font.BOLD,30));

j3.setForeground(Color.cyan);

j4=new JLabel("学生:");

j4.setFont(new Font("宋体",Font.BOLD,30));

j4.setForeground(Color.cyan);

b1=new JButton("登录");

b2=new JButton("登录");

b3=new JButton("登录");

b4=new JButton("退出");

add(j1,gc,0,0,2,1);

add(j2,gc,0,1,1,1);

add(b1,gc,1,1,1,1);

add(j3,gc,0,2,1,1);

add(b2,gc,1,2,1,1);

add(j4,gc,0,3,1,1);

add(b3,gc,1,3,1,1);

add(b4,gc,0,5,2,1);

jf.pack();

b1.addActionListener(this);

b2.addActionListener(this);

b3.addActionListener(this);

b4.addActionListener(this);}

public void actionPerformed(ActionEvent e){

if(e.getSource()==b1){new dengru().dengru();

}

if(e.getSource()==b2){

new dengru().dengru();

}

if(e.getSource()==b3){

new dengru().dengru();

}

if(e.getSource()==b4){

System.exit(0); }}

public static void main(String [] args){

new Main().gui();

}

}

2：登录界面

package 课程设计;

import java.awt.*;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.awt.event.WindowAdapter;

import java.awt.event.WindowEvent;

import java.applet.*;

import javax.swing.*;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import javax.swing.*;

public class dengru extends JPanel implements ActionListener {

private JLabel use,password;

private JTextField k1;//用户名输入框

private JPasswordField k2;//密码输入框

private JButton b1,b2;

JFrame ck;

public void add(Component c,GridBagConstraints gc,int x,int y,int w,int h){ gc.gridx=x;

gc.gridy=y;

gc.gridwidth=w;

gc.gridheight=h;

add(c,gc);}

public void dengru(){

ck=new JFrame();

ck=new JFrame("学生实验选课登录系统");

ck.setVisible(true);

ck.addWindowListener(new WindowAdapter(){

public void windowClose(WindowEvent e){

System.exit(0);}

});//窗口可独立关闭；

Dimension screenSize=Toolkit.getDefaultToolkit().getScreenSize();

Dimension frameSize = ck.getPreferredSize();

ck.setLocation((screenSize.width - frameSize.width)/2, (screenSize.height - frameSize.height)/2);//窗口显示在屏幕中间

GridBagLayout gf=new GridBagLayout();

setLayout(gf);

ck.add(this,BorderLayout.CENTER);

GridBagConstraints gc=new GridBagConstraints();

gc.insets=new Insets(10,10,10,10);

use=new JLabel("用户名");

password=new JLabel("密码");

b1=new JButton("登录");

b2=new JButton("退出");

k1=new JTextField(12);

k2=new JPasswordField(12);

add(use,gc,0,0,1,1);

add(k1,gc,1,0,4,1);

add(password,gc,0,1,1,1);

add(k2,gc,1,1,4,1);

add(b1,gc,1,3,1,1);

add(b2,gc,2,3,1,1);

ck.pack();

b1.addActionListener(this);

b2.addActionListener(this);}

public void actionPerformed(ActionEvent e){

String driverName="com.microsoft.jdbc.sqlserver.SQLServerDriver";

String dbURL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=学生实验选课系统";

String userName="XJB";

String userPwd="123";

Connection conn=null;

try{Class.forName(driverName);

conn=DriverManager.getConnection(dbURL,userName,userPwd);

}catch(Exception e1){

e1.printStackTrace();//抛出异常，输出堆积的痕迹}

if(e.getSource()==b1){

try{ PreparedStatement pre1=conn.prepareStatement("select * from student

where sno=? and spassword=?");

pre1.setString(1, k1.getText());

pre1.setString(2, k2.getText());

ResultSet rs1=pre1.executeQuery();

if(rs1.next()){

JOptionPane.showMessageDialog(null,"登录成功");

new loginstudent().gui();

ck.dispose();

}else{

if(e.getSource()==b1){PreparedStatement

pre2=conn.prepareStatement("select * from teacher where tno=? and tpassword=?");

pre2.setString(1, k1.getText());

pre2.setString(2, k2.getText());

ResultSet rs2=pre2.executeQuery();

if(rs2.next()){

JOptionPane.showMessageDialog(null,"登录成功");

new loginteacher().gui();

ck.dispose();

}else{

if(e.getSource()==b1){PreparedStatement

pre3=conn.prepareStatement("select * from administrtor where ano=? and apassword=?");

pre3.setString(1, k1.getText());

pre3.setString(2, k2.getText());

ResultSet rs3=pre3.executeQuery();

if(rs3.next()){

JOptionPane.showMessageDialog(null,"登录成功");

new login().gui();

ck.dispose();

}else{

JOptionPane.showMessageDialog(null,"登录失败,请输入正确的用户名和密码");}}}}}}

catch(Exception e2){

e2.printStackTrace();}}

if(e.getSource()==b2){

ck.dispose();}

}

public static void main(String[]agrs){

dengru jf=new dengru();

jf.dengru();}}

3:管理员（教师）登录界面

package 课程设计;

import javax.swing.*;

import java.awt.event.*;

import java.awt.*;

public class loginteacher implements ActionListener{

JFrame jf;

JButton b1,b2,b3,b4,b5;

JLabel j;

public void gui(){

jf=new JFrame("实验选课系统");

jf.setVisible(true);

jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

JPanel p1=new JPanel(new BorderLayout());//创建一个容器有五个部分组成

JPanel p2=new JPanel(new FlowLayout());//创建一个容器，一行为单位

JPanel p3=new JPanel(new FlowLayout());//创建一个容器，一行为单位

p1.setBackground(Color.GRAY);

j=new JLabel("欢迎进入学生实验选课系统");

j.setForeground(Color.red);//设置字体颜色

j.setFont(new Font("BOLD",Font.BOLD,35));//设置字体大小

p1.add(p2,"North");

p1.add(p3,"Center");

jf.setContentPane(p1);

//jf.add(p1);

b1=new JButton("查询");

b2=new JButton("添加");

b3=new JButton("删除");

b4=new JButton("更新");

b5=new JButton("退出");

p2.add(j,JLabel.CENTER);

p3.add(b1);

p3.add(b2);

p3.add(b3);

p3.add(b4);

p3.add(b5);

//jf.setSize(400,300);

jf.pack();//使所有组件都能完整显示

b1.addActionListener(this);

b2.addActionListener(this);

b3.addActionListener(this);

b4.addActionListener(this);

b5.addActionListener(this);

}

/*创建一个监听器*/ public void actionPerformed(ActionEvent e){ if(e.getSource()==b1){

new ChaXun().gui();

}

if(e.getSource()==b2){

new Add().gui();

}

if(e.getSource()==b3){

new delete().shanchu();

}

if(e.getSource()==b5){

System.exit(0);

}

}

/*每一个主类中必须有一个主方法*/ public static void main(String [] args){ new login().gui();}}

4：学生登录界面

package 课程设计;

import javax.swing.*;

import java.awt.event.*;

import java.awt.*;

import java.sql.Connection;

import java.sql.DriverManager;

public class loginstudent extends JPanel implements ActionListener{

JFrame jf,jf1,jf2;

JButton b1,b2,b5,b3,b4;

JLabel j,j1;

JButton b6,b7,b8;

/*定义排版时组建的参数*/

public void add(Component c,GridBagConstraints gc,int x,int y,int w,int h){

gc.gridx=x;

gc.gridy=y;

gc.gridwidth=w;

gc.gridheight=h;

add(c,gc);

}

public void gui1(){

jf1=new JFrame("学生选课");

jf1.addWindowListener(new WindowAdapter(){

public void windoeClose(WindowEvent e){

System.exit(0);

}

});

jf1.setVisible(true);

Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();

Dimension frameSize = jf1.getPreferredSize();

jf1.setLocation((screenSize.width - frameSize.width)/2, (screenSize.height - frameSize.height)/2);

GridBagLayout g1=new GridBagLayout();

setLayout(g1);

jf1.add(this,BorderLayout.CENTER);

GridBagConstraints gc=new GridBagConstraints();

gc.insets=new Insets(10,10,10,10);//设置组建上下左右的间隔

b6=new JButton("选修");

b7=new JButton("浏览");

b8=new JButton("退出");

add(b6,gc,0,0,1,1);

add(b7,gc,1,0,1,1);

add(b8,gc,0,1,1,1);

jf1.pack();

b6.addActionListener(this);

b7.addActionListener(this);

b8.addActionListener(this);

}

public void gui2(){

jf2=new JFrame("选课");

jf2.addWindowListener(new WindowAdapter(){

public void windoeClose(WindowEvent e){

System.exit(0);

}

});

jf2.setVisible(true);

}

public void gui(){

jf=new JFrame("实验选课系统");

jf.setVisible(true);

jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

JPanel p1=new JPanel(new BorderLayout());//创建一个容器有五个部分组成

JPanel p2=new JPanel(new FlowLayout());//创建一个容器，一行为单位

JPanel p3=new JPanel(new FlowLayout());//创建一个容器，一行为单位

p1.setBackground(Color.GRAY);

j=new JLabel("欢迎进入学生实验选课系统");

j.setForeground(Color.red);//设置字体颜色

j.setFont(new Font("BOLD",Font.BOLD,35));//设置字体大小

p1.add(p2,"North");

p1.add(p3,"Center");

jf.setContentPane(p1);

//jf.add(p1);

b1=new JButton("查询");

b2=new JButton("选课");

b5=new JButton("退出");

p2.add(j,JLabel.CENTER);

p3.add(b1);

p3.add(b2);

p3.add(b5);

//jf.setSize(400,300);

jf.pack();//使所有组件都能完整显示

b1.addActionListener(this);

b2.addActionListener(this);

b5.addActionListener(this);

}

/*创建一个监听器*/ public void actionPerformed(ActionEvent e){

String driverName="com.microsoft.jdbc.sqlserver.SQLServerDriver";

String dbURL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=学生实验选课系统";

String userName="XJB";

String userPwd="123";

Connection conn=null;

try{

Class.forName(driverName);

conn=DriverManager.getConnection(dbURL,userName,userPwd);

}catch(Exception e1){

e1.printStackTrace();//抛出异常，输出堆积的痕迹}

if(e.getSource()==b1){

new ChaXun().gui();

}

if(e.getSource()==b2){

gui1();

}

if(e.getSource()==b5){

System.exit(0);

}

}

/*每一个主类中必须有一个主方法*/ public static void main(String [] args){ new login().gui();}}

5：查询界面

package 课程设计;

import javax.swing.*;

import java.awt.*;

import java.awt.event.*;

import java.sql.*;

import java.sql.*;

public class ChaXun extends JPanel implements ActionListener{

JButton b1,b2,b3,b4;

JFrame jf,jf1;

JTextField t;

JLabel j1,j2,j3,j4,j5,j6;

JTextField t1,t2,t3,t4,t5,t6;

public void add(Component c,GridBagConstraints gc,int x,int y,int w,int h){ gc.gridx=x;

gc.gridy=y;

gc.gridwidth=w;

gc.gridheight=h;

add(c,gc);}

public void gui2(){

jf1=new JFrame();

jf1=new JFrame("学生实验选课查询结果");

jf1.setVisible(true);

jf1.addWindowListener(new WindowAdapter(){

public void windowClose(WindowEvent e){

System.exit(0);}

});//窗口可独立关闭；

Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();

Dimension frameSize = jf1.getPreferredSize();

jf1.setLocation((screenSize.width - frameSize.width)/2, (screenSize.height - frameSize.height)/2);//窗口显示在屏幕中间

GridBagLayout gl=new GridBagLayout();

setLayout(gl);

jf1.add(this,BorderLayout.CENTER);

GridBagConstraints gc=new GridBagConstraints();

gc.insets=new Insets(10,10,10,10);//设置组建上下左右的间隔

j1=new JLabel("学号:");

j2=new JLabel("姓名:");

j3=new JLabel("性别:");

j4=new JLabel("年龄：");

j5=new JLabel("专业：");

j6=new JLabel("年级：");

t1=new JTextField(4);

t2=new JTextField(4);

t3=new JTextField(4);

t4=new JTextField(4);

t5=new JTextField(4);

t6=new JTextField(4);

b4=new JButton("退出");

add(j1,gc,0,0,1,1);

add(t1,gc,1,0,10,1);

add(j2,gc,0,1,1,1);

add(t2,gc,1,1,10,1);

add(j3,gc,0,2,1,1);

add(t3,gc,1,2,10,1);

add(j4,gc,0,3,1,1);

add(t4,gc,1,3,10,1);

add(j5,gc,0,4,1,1);

add(t5,gc,1,4,10,1);

add(j6,gc,0,5,1,1);

add(t6,gc,1,5,10,1);

add(b4,gc,2,6,2,1);

jf1.pack();//包装，使所有组件都能完整显示

b4.addActionListener(this);

}

public void gui(){

jf=new JFrame();

jf=new JFrame("学生实验选课查询");

jf.setVisible(true);

jf.addWindowListener(new WindowAdapter(){

public void windowClose(WindowEvent e){

System.exit(0);}

});//窗口可独立关闭；

Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();

Dimension frameSize = jf.getPreferredSize();

jf.setLocation((screenSize.width - frameSize.width)/2, (screenSize.height - frameSize.height)/2);//窗口显示在屏幕中间

JPanel pane=new JPanel(new BorderLayout());//边框布局

JPanel p1=new JPanel(new FlowLayout());//顺序布局

JPanel p2=new JPanel(new FlowLayout());

// jf.setContentPane(pane);

jf.add(pane);

pane.add(p1,"North");

pane.add(p2,"Center");

b1=new JButton("确定");

b2=new JButton("退出");

b3=new JButton("消除");

JLabel j=new JLabel("请输入要查询的学号");

t=new JTextField(8);

p1.add(j);

p1.add(t);

p2.add(b1);

p2.add(b3);

p2.add(b2);

jf.pack();//包装，使所有组件都能完整显示

b1.addActionListener(this);

b2.addActionListener(this);

b3.addActionListener(this);}

public void actionPerformed(ActionEvent e){

String driverName="com.microsoft.jdbc.sqlserver.SQLServerDriver";

String dbURL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=学生实验选课系统";

String userName="XJB";

String userPwd="123";

Connection conn=null;

try{Class.forName(driverName);

conn=DriverManager.getConnection(dbURL,userName,userPwd);

}catch(Exception e1){

e1.printStackTrace();//抛出异常，输出堆积的痕迹}

if(e.getSource()==b1){

try{

PreparedStatement pre=conn.prepareStatement("select * from student where student.sno=?");

pre.setString(1, t.getText());

ResultSet rs=pre.executeQuery();

if(rs.next()){

String sname=rs.getString("sname");

String ssex=rs.getString("ssex");

String sno=rs.getString("sno");

String sage=rs.getString("sage");

String sdept =rs.getString("sdept");

String sgrade=rs.getString("sgrade");

gui2();

t1.setText(sno);

t2.setText(sname);

t3.setText(ssex);

t4.setText(sage);

t5.setText(sdept);

t6.setText(sgrade);

jf.dispose();

}else{

JOptionPane.showMessageDialog(null,"查询失败");

}

}catch(Exception e1){

e1.printStackTrace();//抛出异常，输出堆积的痕迹}}

if(e.getSource()==b2){

jf.dispose();

//new login().gui();

}

if(e.getSource()==b3){

t.setText("");}}}

6：添加界面

package 课程设计;

import javax.swing.*;

import java.awt.event.*;

import java.sql.*;

import java.awt.*;

public class Add extends JPanel implements ActionListener{

JFrame jf;

JButton b1,b2,b3;

JLabel j1,j2,j3,j4,j5,j6,j7,j8;

JTextField t1,t2,t3,t4,t5,t6,t7,t8;

/*定义排版时组建的参数*/public void add(Component c,GridBagConstraints gc,int x,int y,int w,int h){

gc.gridx=x;

gc.gridy=y;

gc.gridwidth=w;

gc.gridheight=h;

add(c,gc);}

public void gui(){

jf=new JFrame("添加学生实验选课信息系统");

jf.addWindowListener(new WindowAdapter(){

public void windowClose(WindowEvent e){

System.exit(0);}});

jf.setVisible(true);

Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();

Dimension frameSize = jf.getPreferredSize();

jf.setLocation((screenSize.width - frameSize.width)/2, (screenSize.height - frameSize.height)/2);

GridBagLayout gl=new GridBagLayout();

setLayout(gl);

jf.add(this,BorderLayout.CENTER);

GridBagConstraints gc=new GridBagConstraints();

gc.insets=new Insets(10,10,10,10);//设置组建上下左右的间隔

b1=new JButton("添加");

b2=new JButton("消除");

b3=new JButton("退出");

t1=new JTextField(10);

t2=new JTextField(10);

t3=new JTextField(10);

t4=new JTextField(10);

t5=new JTextField(10);

t6=new JTextField(10);

t7=new JTextField(10);

t8=new JTextField(10);

j1=new JLabel("学生选课信息");

j2=new JLabel("学号");

j3=new JLabel("姓名");

j4=new JLabel("性别");

j5=new JLabel("年龄");

j6=new JLabel("专业");

j7=new JLabel("年级");

j8=new JLabel("密码");

add(j1,gc,0,0,3,1);

add(j2,gc,0,1,1,1);

add(t1,gc,1,1,1,1);

add(j3,gc,0,2,1,1);

add(t2,gc,1,2,1,1);

add(j4,gc,0,3,1,1);

add(t3,gc,1,3,1,1);

add(j5,gc,0,4,1,1);

add(t4,gc,1,4,1,1);

add(j6,gc,0,5,1,1);

add(t5,gc,1,5,1,1);

add(j7,gc,0,6,1,1);

add(t6,gc,1,6,1,1);

add(j8,gc,0,7,1,1);

add(t7,gc,1,7,1,1);

add(b1,gc,0,8,1,1);

add(b2,gc,1,8,1,1);

add(b3,gc,2,8,1,1);

jf.pack();

b1.addActionListener(this);

b2.addActionListener(this);

b3.addActionListener(this);

}

public void actionPerformed(ActionEvent e){

String driverName="com.microsoft.jdbc.sqlserver.SQLServerDriver";

String dbURL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=学生实验选课系统";

String userName="XJB";

String userPwd="123";

Connection conn=null;

try{

Class.forName(driverName);

conn=DriverManager.getConnection(dbURL,userName,userPwd);

}catch(Exception e1){

e1.printStackTrace();

}

if(e.getSource()==b1){

try{

String str=t2.getText().replaceAll(" ","");

//System.out.print(str.length());

PreparedStatement pre=conn.prepareStatement("insert into student values(?,?,?,?,?,?,?)");

pre.setString(1, t1.getText());

pre.setString(2, str);

pre.setString(3, t3.getText());

pre.setString(4, t3.getText());

pre.setString(5, t3.getText());

pre.setString(6, t3.getText());

pre.setString(7, t3.getText());

if(str.length()==0){

JOptionPane.showMessageDialog(null,"用户名不能为为空");

}else{

int a=pre.executeUpdate();

if(a==1){

JOptionPane.showMessageDialog(null,"添加成功");

}else{

JOptionPane.showMessageDialog(null,"添加失败"); }}

}catch(Exception e1){

JOptionPane.showMessageDialog(null,"添加失败");//弹出消息提示框}} if(e.getSource()==b2){

t1.setText("");

t2.setText("");

t3.setText("");

t4.setText("");

t5.setText("");

t6.setText("");

t7.setText("");

}

if(e.getSource()==b3){

jf.dispose();;}}}

7：删除界面

package 课程设计;

import javax.swing.*;

import java.sql.*;

import java.awt.*;

import java.awt.event.*;

public class delete extends JPanel implements ActionListener {

JFrame jf;

JLabel j1,j2;

JButton b1,b2,b3;

JTextField t1;

public void add(Component c,GridBagConstraints gc,int x,int y,int w,int h){ gc.gridx=x;

gc.gridy=y;

gc.gridwidth=w;

gc.gridwidth=h;

add(c,gc);}

public void shanchu(){

jf =new JFrame("删除学生信息系统界面");

jf.addWindowListener(new WindowAdapter(){

public void windowClose(){

System.exit(0);}});

jf.setVisible(true);

Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();

Dimension frameSize = jf.getPreferredSize();

jf.setLocation((screenSize.width - frameSize.width)/2, (screenSize.height - frameSize.height)/2);//窗口显示在屏幕中间

GridBagLayout gl=new GridBagLayout();

setLayout(gl);

jf.add(this,BorderLayout.CENTER);

GridBagConstraints gc=new GridBagConstraints();

gc.insets=new Insets(10,10,10,10);//设置组建上下左右的间隔

j1=new JLabel("请输入要删除学生的学号");

j2=new JLabel("学号：");

b1=new JButton("删除");

b2=new JButton("清除");

b3=new JButton("退出");

t1=new JTextField(10);

add(j1,gc,1,0,2,1);

add(j2,gc,0,1,1,1);

add(t1,gc,1,1,10,1);

add(b1,gc,0,2,1,1);

add(b2,gc,1,2,1,1);

add(b3,gc,2,2,1,1);

jf.pack();

b1.addActionListener(this);

b2.addActionListener(this);

b3.addActionListener(this);}

public void actionPerformed(ActionEvent e){

String driverName="com.microsoft.jdbc.sqlserver.SQLServerDriver";

String dbURL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=学生实验选课系统";

String userName="XJB";

String userPwd="123";

Connection conn=null;

try{Class.forName(driverName);

conn=DriverManager.getConnection(dbURL,userName,userPwd);

}catch(Exception e1){

e1.printStackTrace();}

if(e.getSource()==b1){

try{String str=t1.getText().replaceAll(" ","");

//System.out.print(str.length());

PreparedStatement pre=conn.prepareStatement("delete form student where sno=?");

pre.setString(1, t1.getText());

if(str.length()==0){

JOptionPane.showMessageDialog(null,"学号不能为空");

}else{int a=pre.executeUpdate();

if(a==1){ JOptionPane.showMessageDialog(null,"删除成功");

}else{ JOptionPane.showMessageDialog(null,"删除失败");

}}}catch(Exception e1){JOptionPane.showMessageDialog(null,"删除失败");//弹出消息提示框}}

if(e.getSource()==b2){

t1.setText("");}

if(e.getSource()==b3){

jf.dispose();}}}

8:选课界面

package 课程设计;

import java.awt.*;

import javax.swing.*;

import java.sql.*;

import java.util.*;

import javax.swing.filechooser.*;

import java.io.*;

import java.awt.event.*;

public class AddSC extends JPanel implements ActionListener{

JTextField 课号,学号,实验名称;

JButton 录入;

public AddSC(){

try {UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName());}

catch(Exception e){System.err.println("不能设置外观: "+e);}

课号=new JTextField(12);

学号=new JTextField(12);

实验名称=new JTextField(12);

录入=new JButton("录入");

录入.addActionListener(this);

Box box1=Box.createHorizontalBox();//横放box

Box box2=Box.createHorizontalBox();

Box box3=Box.createHorizontalBox();

Box box4=Box.createHorizontalBox();

box1.add(new JLabel(" 课号:"));

box1.add(课号);

box2.add(new JLabel(" 学号:"));

box2.add(学号);

box3.add(new JLabel("实验名称:"));

box3.add(实验名称);

box4.add(录入);

Box boxH=Box.createVerticalBox();//竖放box

boxH.add(box1);

boxH.add(box2);

boxH.add(box3);

boxH.add(box4);

boxH.add(Box.createVerticalGlue());

JPanel messPanel=new JPanel();

messPanel.add(boxH);

setLayout(new BorderLayout());

add(messPanel,BorderLayout.CENTER);

validate();

}

public void actionPerformed(ActionEvent c){

String driverName="com.microsoft.jdbc.sqlserver.SQLServerDriver";

String dbURL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=实验选课";

String userName="YJD";

String userPwd="";

Connection conn=null;

try{Class.forName(driverName);

conn=DriverManager.getConnection(dbURL,userName,userPwd);

System.out.println("success");

}catch(Exception e1){

e1.printStackTrace();}

Object obj=c.getSource();

if(obj==录入){

if(课号.getText().equals("")||学号.getText().equals("")){

JOptionPane.showMessageDialog(this,"填写课号与学号才能录入！" );} else{

ResultSet rs=null,rs1=null,rsC=null,rsS=null;

String sql,sql1,sqlS,sqlC;

sqlC="select * from C where Cno='"+课号.getText()+"'";

sqlS="select * from S where Sno='"+学号.getText()+"'";

sql1="select * from SC where Cno='"+课号.getText()+"' and Sno='"+学号.getText()+"'";

sql="insert into SC values('"+课号.getText()+"','"+学号.getText()+"','"+实验名称.getText()+"')";

try{Statement