jdbcsample.java

简单的奖学金评定系统

import javax.swing.*;
import javax.swing.table.*;
import java.sql.*;
import java.awt.*;
import java.awt.event.*;
class JDBCSample
{
	JDesktopPane desktop = new JDesktopPane();
	Jdbcsql jsql=new Jdbcsql();
	Desktop dsk=new Desktop();
	int i=0,k=0;
	Object[][] data=new Object[26][6];
	JTable jtb5;
    String[] columnNames5;


	void Lianjie(String args)	
	{
		try
		{
			Class.forName(jsql.drv);
		}
		catch(ClassNotFoundException e)
		{
			System.out.println("Unable to load Driver Class");
				
		}
		try
		{
			Connection con = DriverManager.getConnection(jsql.con,"ST103","3103");
			Statement stmt=con.createStatement();
			//*****************奖学金评定 开始************************
			if(args==jsql.sql11)
			{
				int i=0;
					
				columnNames5=jsql.col3;
				ResultSet rs1=stmt.executeQuery(args);
				while(rs1.next())
				{
					data[i][0]=rs1.getString("sid");
					data[i][1]=rs1.getString("sname");
					data[i][2]=rs1.getString("a");
					data[i][3]=rs1.getString("grade");
					data[i][4]=rs1.getString("ty");
					data[i][5]=rs1.getString("amount");
					i++;
					break;
					
				}
				rs1.close();
				ResultSet rs2=stmt.executeQuery(jsql.sql12);
			
				int j=0;
				while(rs2.next())
				{
					j++;
					if(j>0)
						break;
				}

				while(rs2.next())
				{
					data[i][0]=rs2.getString("sid");
					data[i][1]=rs2.getString("sname");
					data[i][2]=rs2.getString("a");
					data[i][3]=rs2.getString("grade");
					data[i][4]=rs2.getString("ty");
					data[i][5]=rs2.getString("amount");

					i++;
					if(i==3)
						break;
					
				}
				rs2.close();
			 
				ResultSet rs3=stmt.executeQuery(jsql.sql13);	
				
				j=0;
				while(rs3.next())
				{
					j++;
					if(j>2)
						break;
				}
				while(rs3.next())
				{
					data[i][0]=rs3.getString("sid");
					data[i][1]=rs3.getString("sname");
					data[i][2]=rs3.getString("a");
					data[i][3]=rs3.getString("grade");
					data[i][4]=rs3.getString("ty");
					data[i][5]=rs3.getString("amount");
					i++;
				}
				rs3.close();
				jtb5=new JTable(data,columnNames5);	
			}
			else
			{
				//****************************奖学金评定 结束*****************************
				ResultSet rs=stmt.executeQuery(args);
				//*****************计算机021班学学生信息****************
				if(args==jsql.sql1)
				{
					columnNames5=jsql.col;
					while(rs.next())
					{
						data[i][0]=rs.getString("sid");
						data[i][1]=rs.getString("sname");
						data[i][2]=rs.getString("sdept");
						data[i][3]=rs.getString("sgrade");
						data[i][4]=rs.getString("sclass");
						data[i][5]=rs.getString("sgender");
						i++;
					}
					jtb5=new JTable(data,columnNames5);

				}
				//****************************计算机021班学生信息   结束*****************************
				//*****************计算机021班选课信息 开始****************
				if(args==jsql.sql2)
				{
					columnNames5=jsql.col2;
					while(rs.next())
					{
						data[i][0]=rs.getString("cid");
						data[i][1]=rs.getString("cname");
						data[i][2]=rs.getString("cgrade");
					
						i++;
					}
					jtb5=new JTable(data,columnNames5);
				}

				//***************************计算机021班选课信息  结束*****************************
				//*****************计算机021学号排序****************
				if(args==jsql.sql3)
				{
					
					columnNames5=jsql.col;
					while(rs.next())
					{
						data[i][0]=rs.getString("sid");
						data[i][1]=rs.getString("sname");
						data[i][2]=rs.getString("sdept");
						data[i][3]=rs.getString("sgrade");
						data[i][4]=rs.getString("sclass");
						data[i][5]=rs.getString("sgender");
						i++;

					}
					jtb5=new JTable(data,columnNames5);			
				}			
				//****************************计算机021学号排序  结束*****************************
				//*****************计算机021全体平均成绩   开始**************************************
				if(args==jsql.sql4)
				{

					columnNames5=jsql.col4;
					while(rs.next())
					{
						data[i][0]=rs.getString("sid");
						data[i][1]=rs.getString("sname");
						data[i][2]=rs.getString("a");
					
						i++;

					}
					jtb5=new JTable(data,columnNames5);		
				}
			

				//****************************计算机021全体平均成绩   结束*****************************
				//*****************平均成绩前7名 开始*****************************
				if(args==jsql.sql6)
				{
	
					columnNames5=jsql.col4;
					while(rs.next())
					{
				
						data[i][0]=rs.getString("sid");
						data[i][1]=rs.getString("sname");
						data[i][2]=rs.getString("a");
					
						i++;
					}
					jtb5=new JTable(data,columnNames5);	
				}
			
			

				//****************************平均成绩前七名   结束***********************
				//*****************每科的平均成绩 开始**** ************
				if(args==jsql.sql7)
				{

					columnNames5=jsql.col1;
					while(rs.next())
					{
				
				
						data[i][0]=rs.getString("cid");
						data[i][1]=rs.getString("cname");
						data[i][2]=rs.getString("a");
					
						i++;

					}jtb5=new JTable(data,columnNames5);		
				} 		
				rs.close();
				stmt.close();
				con.close();   



			}
				//****************************每科平均成绩   结束****  7  *************************
//表图形******************************************************************************************
//新建列表现器------------------------//
DefaultTableCellRenderer tcr = new DefaultTableCellRenderer() 
{
public Component getTableCellRendererComponent(JTable jtb, 
Object value, boolean isSelected, boolean hasFocus, 
int row, int column) 
{
                    
if(row%2 == 0)
setBackground(Color.white); //设置奇数行底色
else if(row%2 == 1)
setBackground(new Color(206,180,255));  //设置偶数行底色
                    
return super.getTableCellRendererComponent(jtb, value, 
isSelected, hasFocus, row, column);
}
};
			//设置列表现器------------------------//
			
for(i = 0; i < columnNames5.length; i++) 
{
jtb5.getColumn(columnNames5[i]).setCellRenderer(tcr);
}

jtb5.setPreferredScrollableViewportSize(new Dimension(500,300));            
			
//*************************************************************************************************************

}//try  结束…
catch(SQLException se)
{
System.out.println("SQL exception: "+se.getMessage());
se.printStackTrace(System.out);
}
} //Lianjie 结束…………………………………………………………………………………………
	
}