JAVA数据库课程设计--学生选课管理系统的(8)

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(学号);

box1.add(new JLabel(\姓名:\ box1.add(姓名); box1.add(new JLabel(\系别:\ box1.add(系别); box2.add(查找); box4.add(new JLabel(\课号:\ box4.add(课号); box4.add(new JLabel(\课名:\ box4.add(课名); box6.add(查找1); box5.add(new JLabel(\课号:\ box5.add(课号1); box5.add(new JLabel(\学号:\ box5.add(学号1); box5.add(new JLabel(\成绩:\ box5.add(成绩); box7.add(查找2); Box boxH1=Box.createVerticalBox();//竖放box boxH1.add(box1); boxH1.add(box2); boxH1.add(Box.createVerticalGlue()); Box boxH2=Box.createVerticalBox();//竖放box boxH2.add(box4); boxH2.add(box6); boxH2.add(Box.createVerticalGlue()); Box boxH3=Box.createVerticalBox();//竖放box boxH3.add(box5); boxH3.add(box7); boxH3.add(Box.createVerticalGlue()); 查找.addActionListener(this); 查找1.addActionListener(this); 查找2.addActionListener(this); JPanel messPanel=new JPanel(); JPanel picPanel=new JPanel(); JPanel threePanel=new JPanel(); messPanel.add(boxH1); picPanel.add(boxH2); threePanel.add(boxH3); setLayout(new BorderLayout());