show.java

java课程设计-家庭理财系统。。 第一个小作品

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


 class Show {
	 String[][] playerInfo= new String[10000][5];
	int xuhao=0;
	 public Show(){
		this.getplayerInfo();
		
			
		
	}

	 public void getplayerInfo(){
		  
	 	try {
					    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //加载access数据库驱动
				   } catch (ClassNotFoundException e1) {
				    e1.printStackTrace();
				   }
				   try{
				   Connection conn = DriverManager.getConnection("jdbc:odbc:STU"); //建立连接这里student为数据库名
				   Statement stmt = conn.createStatement();					   ResultSet rs=stmt.executeQuery("select * from Moneymanager");//将查询得到的结果集给rs
				   int i=0;
				   while(rs.next()){
					   playerInfo[i][0]=String.valueOf(i+1);
					   playerInfo[i][1]=String.valueOf((rs.getInt("收入")));
					   playerInfo[i][2]=String.valueOf((rs.getInt("支出")));
					   playerInfo[i][3]=rs.getString("时间");
					   playerInfo[i][4]=rs.getString("备注");
						 i++;
					  }
				   xuhao=i;conn.close();stmt.close();
				   }catch(SQLException e1){
		    		   e1.getStackTrace();
				   } 

				  // new Table().table.updateUI();
		 }
	 
	 
	//new Table().table.setValueAt(String.valueOf(i+1), 1, 1);
	 
	public static void main(String[] args) {
		

	}

}