📄 xuanke5frame.java
字号:
package xscj;
import java.awt.*;
import java.awt.event.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JOptionPane;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JButton;
public class XuanKe5Frame extends JFrame implements ActionListener{
//JLabel label1 =new JLabel("课程名");
JLabel label2=new JLabel("c语言");
JLabel label3=new JLabel("国经");
JLabel label4=new JLabel("日语");
JLabel label5=new JLabel("学号");
JLabel label6=new JLabel("学期 :");
JLabel label7=new JLabel("5");
JLabel label8=new JLabel();
JLabel label9=new JLabel("提示: 输入1为选择");
TextField textField1 = new TextField();
TextField textField2 = new TextField();
TextField textField3 = new TextField();
TextField textField4 = new TextField();
// TextField textField2 = new TextField();
JButton button1=new JButton("选择");
JButton button2=new JButton("撤销");
//Button button3=new Button("选择2");
//Button button4=new Button("撤销2");
//Button button5=new Button("选择3");
//Button button6=new Button("撤销3");
//label1.setBounds(30,30,70.50);
Connection conn;
Statement stmt;
ResultSet rs;
String strurl;
public XuanKe5Frame() throws Exception
{
super("第五学期选课窗口");
setSize(400,300);
setLayout(null);
this.setLocation(200,200);
button1.setBounds(55, 185, 83, 23);
button2.setBounds(195,185, 83, 23);
// button3.setBounds(86, 125, 83, 23);
//button4.setBounds(250, 125, 83, 23);
//button5.setBounds(86, 170, 83, 23);
//button6.setBounds(250, 170, 83, 23);
button1.addActionListener(this);
button2.addActionListener(this);
// button3.addActionListener(this);
//button4.addActionListener(this);
//button5.addActionListener(this);
//button6.addActionListener(this);
//label1.setBounds(20,125, 50, 19);
label2.setBounds(45, 125, 50, 19);
label3.setBounds(125, 125,50, 19);
label4.setBounds(225, 125,50, 19);
label5.setBounds(20,45,50, 19);
label6.setBounds(165, 45,50, 19);
label8.setBounds(185, 85,100, 19);
label9.setBounds(20, 85,200, 19);
textField1.setBounds(85, 45,50, 19);
textField2.setBounds(20, 125,15, 19);
textField3.setBounds(105, 125,15, 19);
textField4.setBounds(185, 125,15, 19);
label7.setBounds(225, 45,50, 19);
add(button1);
add(button2);
//add(button3);
//add(button4);
//add(button5);
//add(button6);
//add(button1);
//add(label1);
add(label2);
add(label3);
add(label4);
add(label5);
add(label6);
add(label7);
add(textField1);
add(textField2);
add(textField3);
add(textField4);
add(label8);
add(label9);
strurl ="jdbc:odbc:student";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(strurl);
stmt = conn.createStatement();
setVisible(true);
addWindowListener(new WindowAdapter(){
public void windowClosing(WindowEvent e){
dispose();
setVisible(false);
}
});
}
public void actionPerformed(ActionEvent e)
{
String str=e.getActionCommand();
if (str.equals("选择"))
{
if(textField1.getText().equals(""))
{
label8.setText("学号不能为空");
}
else {
try
{
rs = stmt.executeQuery("select * from SC where 学号='"+textField1.getText()+"'" );
if(rs.next()){
JOptionPane.showMessageDialog(null, "字段存在重新输入", "提示",
JOptionPane.WARNING_MESSAGE);
textField1.setText("");
//textField2.setText("");
//textField3.setText("");
}
else{
if(textField2.getText().equals("")&&textField3.getText().equals("")&&textField4.getText().equals(""))
{label8.setText("您还没选择课程");}
if( textField2.getText().equals("1")&&textField3.getText().equals("1")&&textField4.getText().equals("1"))
{
stmt.execute(
"insert into SC(学号,学期,课程1,课程2,课程3) values ('" +
textField1.getText() + "','" +
label7.getText() + "','" +
label2.getText() + "','" +
label3.getText() + "','" +
label4.getText() + "')");
label8.setText("输入成功");
}
if( textField2.getText().equals("1")&&textField3.getText().equals("1")&&textField4.getText().equals(""))
{
stmt.execute(
"insert into SC(学号,学期,课程1,课程2,课程3) values ('" +
textField1.getText() + "','" +
label7.getText() + "','" +
label2.getText() + "','" +
label3.getText() + "','')");
label8.setText("输入成功");
}
if( textField2.getText().equals("1")&&textField3.getText().equals("")&&textField4.getText().equals("1"))
{
stmt.execute(
"insert into SC(学号,学期,课程1,课程2,课程3) values ('" +
textField1.getText() + "','" +
label7.getText() + "','" +
label2.getText() + "','','" +
label4.getText() + "')");
label8.setText("输入成功");
}
if( textField2.getText().equals("")&&textField3.getText().equals("1")&&textField4.getText().equals("1"))
{
stmt.execute(
"insert into SC(学号,学期,课程1,课程2,课程3) values ('" +
textField1.getText() + "','" +
label7.getText() + "','','" +
label3.getText() + "','" +
label4.getText() + "')");
label8.setText("输入成功");
}
/*if( textField2.getText().equals("1")&&textField3.getText().equals("1")&&textField4.getText().equals("1"))
{
stmt.execute(
"insert into SC(学号,学期,课程1,课程2,课程3) values ('" +
textField1.getText() + "','" +
label7.getText() + "','" +
label2.getText() + "','" +
label3.getText() + "','" +
label4.getText() + "')");
label8.setText("输入成功");
}*/
if( textField2.getText().equals("")&&textField3.getText().equals("")&&textField4.getText().equals("1"))
{
stmt.execute(
"insert into SC(学号,学期,课程1,课程2,课程3) values ('" +
textField1.getText() + "','','','" +
label3.getText() + "','" +
label4.getText() + "')");
label8.setText("输入成功");
}
if( textField2.getText().equals("")&&textField3.getText().equals("1")&&textField4.getText().equals(""))
{
stmt.execute(
"insert into SC(学号,学期,课程1,课程2,课程3) values ('" +
textField1.getText() + "','" +
label7.getText() + "','','" +
label3.getText() + "','')");
label8.setText("输入成功");
}
if( textField2.getText().equals("1")&&textField3.getText().equals("")&&textField4.getText().equals(""))
{
stmt.execute(
"insert into SC(学号,学期,课程1,课程2,课程3) values ('" +
textField1.getText() + "','" +
label7.getText() + "','" +
label2.getText() + "','','')");
label8.setText("输入成功");
}
}
}
catch (Exception eg) {
label8.setText("输入错误");
eg.printStackTrace();
}
}
}
if(str.equals("撤销"))
{
if(textField1.getText().equals(""))
{
label8.setText("学号不能为空");
}
else{
try{rs=stmt.executeQuery("select * from SC");
stmt.execute("delete from SC where 学号='"+textField1.getText()+"'");
label8.setText("删除成功");
}catch(Exception eg){
label8.setText("删除失败");
eg.printStackTrace();}
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -