public void actionPerformed(ActionEvent e) {
Object ob=e.getSource();
if(ob==but5){
this.dispose();
Showwin1 b=new Showwin1();
b.setSize(350,350);
}}}
(8)
import java.awt.GridLayout;
import java.awt.List;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JButton;
import javax.swing.JFrame;
public class seekc {
public static void main(String args[])
{
seek s=new seek();
s.setSize(450,350);
s.setVisible(true);
s.addWindowListener(new WindowAdapter()
{
public void windowClosing(WindowEvent e)
{
System.exit(0);
}});}}
class seek extends JFrame implements ActionListener
{
List lis1=new List();
JButton but5=new JButton("返回");
seek(){
super("查询结果");
setLayout(new GridLayout(2,1));
but5.addActionListener(this);
add(lis1);
add(but5);
lis1.add("课程编号"+" "+"课程名"+" "+"学时"+" "+"学分"+" "+"课程类别"+" "+"开始时间"+" "+"结束时间"+" "+"教室"+" "+"教师"+" "+"总人数");
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 课程信息";
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 e=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+" "+e+" "+f+" "+g+" "+h+" "+i+" "+j);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
pack();
show();
}//@Override
public void actionPerformed(ActionEvent e) {
Object ob=e.getSource();
if(ob==but5){
this.dispose();
Showwin2 m=new Showwin2();
m.setSize(350,350);
}}}
(9)
import java.awt.GridLayout;
import java.awt.List;
import java.awt.TextField;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
public class searchzz {
public static void main(String args[])
{
searchz s=new searchz();
s.setSize(350,350);
s.setVisible(true);
s.addWindowListener(new WindowAdapter()
{
public void windowClosing(WindowEvent e)
{
System.exit(0);
}}); }}
class searchz extends JFrame implements ActionListener
{
List lis1=new List();
JButton but5=new JButton("返回");
JButton but6=new JButton("确定");
JLabel lab=new JLabel("请输入你要查找的系名称:");
TextField tex=new TextField();
searchz(){
super("查询");
setLayout(new GridLayout(6,1));
but6.addActionListener(this);
but5.addActionListener(this);
add(lab);
add(tex);
add(but6);
add(lis1);
add(but5);
lis1.add("系编号"+" "+"系名称"+" "+"专业编号"+" "+"专业名称"+" "+"专业学制"+" "+"班级"+" "+"辅导员");
pack();
show();
}//@Override
public void actionPerformed(ActionEvent e) {
Object ob=e.getSource();
if(ob==but6){
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 s=tex.getText();
String sql = "select * from 组织信息 where 系名称='"+s+"'";
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("辅导员");
lis1.add(a+" "+b+" "+c+" "+d+" "+k+" "+f+" "+g);
}
} catch (Exception q) {
// TODO Auto-generated catch block
q.printStackTrace();
}}
if(ob==but5){
this.dispose();
Showwin7 b=new Showwin7();
b.setSize(350,350);
}}
(10)
import java.awt.GridLayout;
import java.awt.List;
import java.awt.TextField;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
public class searchkc {
public static void main(String args[])
{
search s=new search();
s.setSize(450,350);
s.setVisible(true);
s.addWindowListener(new WindowAdapter()
{
public void windowClosing(WindowEvent e)
{
System.exit(0);
}});}}
class search extends JFrame implements ActionListener
{
List lis1=new List();
JButton but5=new JButton("返回");
JButton but6=new JButton("确定");
JLabel lab=new JLabel("请输入你要查找的课程名:");
TextField tex=new TextField();
search(){
super("查询");
setLayout(new GridLayout(6,1));
but6.addActionListener(this);
but5.addActionListener(this);
add(lab);
add(tex);
add(but6);
add(lis1);
add(but5);
lis1.add("课程编号"+" "+"课程名"+" "+"学时"+" "+"学分"+" "+"课程类别"+" "+"开始时间"+" "+"结束时间"+" "+"教室"+" "+"教师"+" "+"总人数");
pack();
show();
}//@Override
public void actionPerformed(ActionEvent e) {
Object ob=e.getSource();
if(ob==but6){
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 s=tex.getText();
String sql = "select * from 课程信息 where 课程名='"+s+"'"
上一篇:
BBS论坛系统毕业设计说明书
下一篇:
电信运营支持系统的设计与开发毕业论文