a.java

java 北大青鸟 java 北大青鸟

import javax.sql.*;
import java.sql.*;

import java.util.*;
import javax.swing.JTable;

//下面这几个包一定要注意导否则是会出错的
import javax.swing.table.DefaultTableModel;

import javax.swing.*;
import javax.swing.table.JTableHeader;


import javax.swing.JFrame;
import java.awt.*;
import java.awt.event.*;
class A extends JFrame{

A() throws SQLException{	 //对面板进行处理
	super("MyTableDemo");
	
	/*做连接的初始值处理*/	
	 Connection cn = null;
	 ResultSet rs = null ;
	 Statement stat;
	 ResultSet rs2 = null ;
	 Statement stat2;
	 String DriverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
     
	 String DriverManagerURL = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=pubs";
	 
	 String userName = "sa";
	 String userpassworld ="";
	  // 创建table模板----------------------------------------
     DefaultTableModel model = new DefaultTableModel();	 
		 //下面是第一种方式去加表单的目录
	 model.setColumnIdentifiers(new Object[]{"clentID","clentName","clentAge","clentAdrr"});
	/*下面是是用字符串的方式加目录
	String astr[]={"a1","a2","a3","a4"};
	model.setColumnIdentifiers(astr);
	*/
	//-----------------------------------------------------------------
		//使用桥JDBC-ODBC加ODBC驱动	 String DriverManagerURL="jdbc:odbc:LocalServer";
		try{
		Class.forName(DriverName);
//使用桥JDBC-ODBC加ODBC驱动	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	/*下面是第一种方式时的连接*/
		cn = DriverManager.getConnection(DriverManagerURL,userName,userpassworld);
	}

	catch(java.lang.ClassNotFoundException e){
	 	System.err.println("ClassNotFoundException:");
		System.err.println(e.getMessage());
		}
		if (cn == null){
            System.err.println("Connection failed...");
            System.exit(0);			
			}			
		stat2 = cn.createStatement();
		//进行查询问
		rs2 = stat2.executeQuery("select * from authors");
		
		while(rs2.next()){
			//下面是加载数据
		model.addRow(new Object[] {rs2.getString(1), rs2.getString(2),
                                rs2.getString(3),rs2.getString(4)});	}        
			//关闭我们的记录集
		rs2.close();
		stat2.close();		
		cn.close();	
		
     //建表
     JTable table = new JTable();
     //向以有的表中加入表模板
     table.setModel(model);
     //下面是设置表的初始大小
     table.setPreferredScrollableViewportSize(new Dimension(500, 70));
     //做一个滚动面板,同时加载一个表格
	 JScrollPane scrollPane = new JScrollPane(table);
	 //将滚动面板放到窗体的中间
	        getContentPane().add(scrollPane, BorderLayout.CENTER);
        //添加监听使得窗体可以关闭
        addWindowListener(new WindowAdapter() {
            public void windowClosing(WindowEvent e) {
                System.exit(0);}});}
		
		
	public static void main(String []arg)throws SQLException{
	A a= new A();
	a.setSize(700,700);
a.setVisible(true);
			}
	}