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());
百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库JAVA数据库课程设计--学生选课管理系统的(8)在线全文阅读。
相关推荐：