不知道你“以列为单位”什么意思,试试吧:
private JScrollPane tableScrollPane;
tableScrollPane=new JScrollPane(jTable);
private JScrollPane tableScrollPane;
tableScrollPane=new JScrollPane(jTable);
解决方案 »
- 关于java中参数使用(String... name1)中的参数有什么特别的用处吗?
- 0x01<<8+0x3f 与 (0x01<<8)+0x3f 为什么结果不一样?
- 画图的问题
- 关于javamail的问题,大家帮忙看看!
- sun的webrowset接口的实现写xml时为何没有对binary数据进行处理?
- 傻问题:main前为什么一定要加static
- 如何使用calendar类提出这个日期变量的一部分值?
- 一个在JNI中创建JVM的超难问题
- 帮帮小弟!
- Exception
- 请教:如何将一个固定大小的String转换为整数二维数组(对,不是一维)
- 谁能告诉我win32comm.dll哪里能下载到啊?
import java.sql.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.util.*;
import javax.swing.table.*;public class tableTest extends JFrame {
public static void main( String args[] )
{
new tableTest();
}
private Connection connection;
private Statement statement;
private ResultSet resultSet;
private ResultSetMetaData rsmd;
private JButton submitQuery;
private JTable table;
public tableTest()
{
super( "输入SQL语句,按提交按钮查看结果。" );
Container c = getContentPane();
c.setLayout( new BorderLayout() );
String url = "jdbc:odbc:空军国防生";
String username = "";
String password = "";
try
{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
connection = DriverManager.getConnection(
url, username, password );
}
catch ( ClassNotFoundException cnfex )
{
System.err.println("装载 JDBC/ODBC 驱动程序失败。" );
cnfex.printStackTrace();
System.exit( 1 );
}
catch ( SQLException sqlex )
{
System.err.println( "无法连接数据库" );
sqlex.printStackTrace();
System.exit( 1 );
}
Vector columnHeads = new Vector();
Vector rows = new Vector();
try
{
String query = "SELECT * FROM studentsmessage";
statement = connection.createStatement();
resultSet = statement.executeQuery( query );
rsmd = resultSet.getMetaData();
for ( int i = 1; i <= rsmd.getColumnCount(); ++i )
columnHeads.addElement( rsmd.getColumnName( i ) );
while ( resultSet.next() )
{
Vector currentRow = new Vector();
for ( int i = 1; i <= rsmd.getColumnCount(); ++i )
{
currentRow.addElement( resultSet.getString( i ) );
}
rows.addElement(currentRow);
}
}
catch ( SQLException sqlex )
{
sqlex.printStackTrace();
}
table = new JTable( rows, columnHeads );
table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
try
{
for(int i = 0; i < rsmd.getColumnCount(); ++i )
{
TableColumn Col1 = table.getColumnModel().getColumn(i);
Col1.setPreferredWidth(100);
}
}
catch ( SQLException sqlex )
{
sqlex.printStackTrace();
}
JScrollPane scroller = new JScrollPane( table );
scroller.setHorizontalScrollBarPolicy(JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);
c.add( scroller, BorderLayout.CENTER );
//c.validate(); addWindowListener(
new WindowAdapter()
{
public void windowClosing( WindowEvent e )
{
System.exit( 0 );
}
}
);
setSize( 500, 200 );
show();
}
}