java表格数据显示为零_java对数据库数据用表格形式输出，为什么界面里面不显示表格，请具体之处那句代码错误...

mportjava.awt.BorderLayout;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;importjava...

mport java.awt.BorderLayout;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.Vector;

import javax.swing.BorderFactory;

import javax.swing.JFrame;

import javax.swing.JScrollPane;

import javax.swing.JTable;

import javax.swing.border.BevelBorder;

import javax.swing.table.DefaultTableModel;

public class Search extends JFrame{

private Connection con;

Search(){

setDefaultCloseOperation(DISPOSE_ON_CLOSE);

setBounds(200, 200, 600, 400);

setLayout(new BorderLayout());

Vector vector = new Vector();

vector.add("vfirstname".toUpperCase());

vector.add("vlastname".toUpperCase());

vector.add("csex".toUpperCase());

vector.add("dtestdate".toUpperCase());

vector.add("ntestscore".toUpperCase());

try {

Class.forName("oracle.jdbc.driver.OracleDriver");

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

try {

con = DriverManager.getConnection("jdbc:oracle:thin:@192.168.9.45:1521:recruit","user1","user1");

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

try {

Statement stat = con.createStatement();

String s="select vfirstname, vlastname,csex,dtestdate,ntestscore from externalcandidate";

Vector data=new Vector();

ResultSet rs = stat.executeQuery(s);

while (rs.next()) {

String s1 = rs.getString(1);

String s2 = rs.getString(2);

String s3 = rs.getString(3);

String s4 = rs.getString(4);

String s5 = rs.getString(5);

Vector row = new Vector();

row.add(s1);

row.add(s2);

row.add(s3);

row.add(s4);

row.add(s5);

data.add(row);

}

DefaultTableModel tableModel = new DefaultTableModel(data,vector);

JTable table = new JTable(tableModel);

table.setShowHorizontalLines(true);

JScrollPane scrollPane = new JScrollPane();

scrollPane.setBorder(BorderFactory.createBevelBorder(BevelBorder.LOWERED));

scrollPane.add(table);

add(scrollPane);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

public static void main(String[] args) {

new Search().setVisible(true);

}

}

展开