;
ResultSet res = stm.executeQuery(sql); //执行Sql语句获取查询结果集
while(res.next()){
String a=res.getString("课程编号");
String b=res.getString("课程名");
String c=res.getString("学时");
String d=res.getString("学分");
String k=res.getString("课程类别");
String f=res.getString("开始时间");
String g=res.getString("结束时间");
String h=res.getString("教室");
String i=res.getString("教师");
String j=res.getString("总人数");
lis1.add(a+" "+b+" "+c+" "+d+" "+k+" "+f+" "+g+" "+h+" "+i+" "+j);
}
} catch (Exception q) {
// TODO Auto-generated catch block
q.printStackTrace();
}}
if(ob==but5){
this.dispose();
Showwin2 x=new Showwin2();
x.setSize(350,350);
}}}
(11)
import java.awt.GridLayout;
import java.awt.TextField;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
public class inputgrade {
public static void main(String[] args) {
// TODO Auto-generated method stub
Showwin4 win=new Showwin4();
win.setSize(350,350);
win.setVisible(true);
win.addWindowListener(new WindowAdapter()
{
public void windowClosing(WindowEvent e)
{
System.exit(0);
}
});/**/}}
class Showwin4 extends JFrame implements ActionListener,TextListener{
String nn,male,data;
JLabel lab1=new JLabel("请输入:");
TextField tex1=new TextField();
JLabel lab3=new JLabel("请输入课程号:");
TextField tex3=new TextField();
JLabel lab4=new JLabel("请输入成绩:");
TextField tex4=new TextField();
JButton but=new JButton("确定");
JButton bu1=new JButton("返回");
Showwin4(){
super("学生成绩输入");
setLayout(new GridLayout(10,10));
add(lab1);add(tex1);
add(lab3);add(tex3);
add(lab4);add(tex4);
add(but);
add(bu1);
tex1.addTextListener(this);
tex3.addTextListener(this);
tex4.addTextListener(this);
but.addActionListener(this);
bu1.addActionListener(this);
pack();
show();
} //@Override
public void actionPerformed(ActionEvent e) {
// TODO Auto-generated method stub
if(e.getSource()==but){
try {
nn=tex1.getText();
male=tex3.getText();
data=tex4.getText();
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url = "jdbc:sqlserver://localhost:1433;databasename=课程设计";
Connection conn = DriverManager.getConnection(url,"sa","123456");
Statement stm = conn.createStatement();
String sql = "insert into 成绩信息(,课程号,成绩)values('"+nn+"','"+male+"','"+data+"')";
stm.executeUpdate(sql);
} catch (Exception a) {
// TODO Auto-generated catch block
a.printStackTrace();
};}
if(e.getSource()==bu1){
this.dispose();
showwin l=new showwin();
l.setSize(350,350);
}}//@Override
public void textValueChanged(TextEvent e) {
// TODO Auto-generated method stub
}}
(12)
import java.awt.GridLayout;
import java.awt.TextField;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
public class denglu {
public static void main(String args[])
{
deng win=new deng();
win.setSize(350,350);
win.setVisible(true);
win.addWindowListener(new WindowAdapter()
{
public void windowClosing(WindowEvent e)
{
System.exit(0);
}});}
class deng extends JFrame implements ActionListener,TextListener{
String nn;
JLabel lab=new JLabel("请输入用户名:");
TextField tex=new TextField();
JLabel lab1=new JLabel("请输入密码:");
TextField tex1=new TextField();
JButton but=new JButton("确定");
deng(){
super("登录");
setLayout(new GridLayout(10,10));
add(lab);
add(tex);
add(lab1);
add(tex1);
add(but);
but.addActionListener(this);
pack();
show();
}//@Override
public void actionPerformed(ActionEvent e) {
// TODO Auto-generated method stub
if(e.getSource()==but){
String x=tex.getText();
String y=tex1.getText();
String z;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url = "jdbc:sqlserver://localhost:1433;databasename=课程设计";
Connection conn = DriverManager.getConnection(url,"sa","123456");
Statement stm = conn.createStatement();
String sql = "select * from 用户信息 where 用户名='"+x+"' and 密码='"+y+"'";
ResultSet res = stm.executeQuery(sql); //执行Sql语句获取查询结果集
if(res.next()){
if(res.getString("权限").equals("1"))
{
this.dispose();
showwin t=new showwin();
t.setSize(350,350);
}
else
{
this.dispose();
showwinwin t=new showwinwin();
t.setSize(350,350);
}}
else{
new cuowu();
}
} catch (Exception g) {
// TODO Auto-generated catch block
g.printStackTrace();
}}
}//@Override
public void textValueChanged(TextEvent e) {
// TODO Auto-generated method stub
}}
(13)
import java.awt.GridLayout;
import java.awt.TextField;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
public class delzz {
public static void main(String[] args) {
// TODO Auto-generated method stub
delz win=new delz();
win.setSize(350,350);
win.setVisible(true);
win.addWindowListener(new WindowAdapter()
{
public void windowClosing(WindowEvent e)
{
System.exit(0);
}});/**/}
}class delz extends JFrame implements ActionListener,TextListener{
String nn,name,male,data,loc,mz,clas;
JLabel lab1=new JLabel("请输入系编号:");
TextField tex1=new TextField();
JLabel lab3=new JLabel("请输入专业编号:");
TextField tex3=new TextField();
JLabel lab6=new JLabel("请输入班级:");
TextField tex6=new TextField();
JButton but=new JButton("确定");
JButton bu1=new JButton("返回");
delz(){
super("组织信息删除");
setLayout(new GridLayout(10,10));
add(lab1);add(tex1);
add(lab3);add(tex3);
add(lab6);add(tex6);
add(but);
add(bu1);
tex1.addTextListener(this);
tex3.addTextListener(this);
tex6.addTextListener(this);
but.addActionListener(this);
bu1.addActionListener(this);
pack();
show();
}//@Override
public void actionPerformed(ActionEvent e) {
// TODO Auto-generated method stub
if(e.getSource()==but){
try {
nn=tex1.getText();
male=tex3.getText();
mz=tex6.getText();
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url = "jdbc:sqlserver://localhost:1433;databasename=课程设计";
Connection conn = DriverManager.getConnection(url,"sa","123456");
Statement stm = conn.createStatement();
String sql = "delete from 组织信息 where 系编号='"+nn+"' and 专业编号='"+male+"' and 班级=
上一篇:
BBS论坛系统毕业设计说明书
下一篇:
电信运营支持系统的设计与开发毕业论文