import java.awt.BorderLayout;_import java.awt.BorderLayout; import java.awt.Color; import java.awt.F...

importjava.awt.BorderLayout;importjava.awt.Color;importjava.awt.Font;importjava.beans.Statement;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.Resu...

import java.awt.BorderLayout;

import java.awt.Color;

import java.awt.Font;

import java.beans.Statement;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.Vector;

import javax.swing.JButton;

import javax.swing.JFrame;

import javax.swing.JScrollPane;

import javax.swing.JTable;

public class Stmessege1 extends JFrame {

private static final long serialVersionUID = 1L;

private JTable table;// 声明表格

void Stmessege11(){

JFrame f=new JFrame();

setSize(460, 420);+

setVisible(true);

Font font = new Font("楷体", Font.BOLD, 18);

JButton btn2 = new JButton("查询学生学籍信息");

btn2.setForeground(Color.blue);

btn2.setSize(200,38);

btn2.setLocation(35, 300);

btn2.setFont(font);

f.add(btn2);

}

public Vector getDataVector() throws SQLException, ClassNotFoundException {

Connection conn = null;

java.sql.Statement stmt = null;

Class.forName("com.mysql.jdbc.Driver");

String dburl = "jdbc:mysql://localhost:3306/hp";

String dbuser = "root";

String dbpassword = "19920102";

conn = DriverManager.getConnection(dburl, dbuser, dbpassword);

stmt = conn.createStatement();

String sql = "select* from xsgli";

ResultSet rs = stmt.executeQuery(sql);

Vector dataVector = new Vector();

while (rs.next()) {

Vector rowVector = new Vector();

for (int i = 1; i <= 7; i++) {

if (i == 2 || i == 4) {

rowVector.add(String.valueOf(rs.getInt(i)));

} else {

rowVector.add(rs.getString(i));

}

}

dataVector.add(rowVector);

}

return dataVector;

}

public Vector getColumnVector() {

Vector columnVector = new Vector();

columnVector.add("姓名");

columnVector.add("学号");

columnVector.add("性别");

columnVector.add("班级");

columnVector.add("系别");

columnVector.add("成绩");

columnVector.add("专业");

return columnVector;

}

public Stmessege1() throws SQLException, ClassNotFoundException {

super();

setTitle("学生学籍数据显示");

setBounds(100, 100, 382, 223);

setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

Connection conn = null;

Statement stmt = null;

Class.forName("com.mysql.jdbc.Driver");

String dburl = "jdbc:mysql://localhost:3306/hp";

String dbuser = "root";

String dbpassword = "19920102";

conn = DriverManager.getConnection(dburl, dbuser, dbpassword);

java.sql.Statement st = conn.createStatement();

String sql = "select* from xsgli";

ResultSet rs = st.executeQuery(sql);

Vector columnVector = getColumnVector();

Vector dataVector = getDataVector();

final JScrollPane scrollPane = new JScrollPane();

getContentPane().add(scrollPane, BorderLayout.CENTER);

table = new JTable(dataVector, columnVector);

table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);

scrollPane.setViewportView(table);

}

}

为什么添加按钮会不显示》？？？？？？

展开