jdbcsample.java

java课程的资料以及实验的代码

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

public class JDBCSample extends JFrame{
	
	JDBCSample(){
	    try{
	    String[] colHeads = { "name", "Phone", "City" };

			Connection con; 
			Statement stmt; 
			ResultSet rs; 

			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
			String url="jdbc:odbc:pubs"; 
			con=DriverManager.getConnection(url,"sa","");
			stmt = con.createStatement(); 

			rs = stmt.executeQuery("SELECT count(*) as au_count from authors");
			rs.next();
			int iCount=rs.getInt("au_count");
			
		    // 定义表格元素内容
		    Object[][] data = new Object[iCount][];
		    int i=0;
			rs = stmt.executeQuery("SELECT * from authors"); 		
			while (rs.next()) 
			{ 
				data[i]=new Object[3];
				data[i][0]= rs.getString("au_fname");
				data[i][1]= rs.getString("Phone");
				data[i][2]= rs.getString("City");
				i++;
			} 
		    
		    JTable table = new JTable(data, colHeads);
		    JScrollPane jsp = new JScrollPane(table);
		    getContentPane().add(jsp);
		    }catch(Exception e){
		    	System.out.println(e);
		    
		    }
	}

	public static void main(String[] args) {
		JDBCSample f2=new JDBCSample();
		f2.setSize(400,250);
		f2.setVisible(true);
	}
}