mainstudyunauto[anank].java

(1)功能模块: A :个人开户功能 B :查询功能 查询个人用户信息 查询各个房间使用信息 查询寄存物品信息 C :增加寄存物品模块 用JAVA实现宾馆客房管理系统

///////////////////////////////////////////////////////////////
//
//文件描述：非自动读取－选择性
//
////////////////////////////////////////////////////////////////
package SysStudy ;
import javax.swing.*;
import java.awt.*;
import java.sql.*;
import java.awt.event.*;
import java.util.*;
import javax.swing.table.* ;
import java.util.Date ;

public class MainStudyUnAuto
{
	static int number = 1;//记录上次自动读取的位置！
	static int rowOfTable = 1 ;//记录读取数据的个数！
	static int setTime = 1 ;
	
	static JFrame frame ;
	static JLabel lblPoint ;
	static JTextArea txtPoint ;
	static JButton btnBack ;
	static GridBagLayout gbl ;
	static GridBagConstraints gbc ;
	static Container content ;
	
	public static void time(int n)
	{
		for(int i = 0; i < n; i++)
		    for(int j = 0; j < 80000000; j++) ;
	}
	public static void init()
	{
		JFrame.setDefaultLookAndFeelDecorated(true);//把JFrame设置城修饰的外观！
        //
	    frame = new JFrame("知识点读取----非自动---选择性");
		frame.setSize(600, 200) ;
		//
	    lblPoint = new JLabel("----------------------------------------------------知识点-----------------------------------------------") ;
	    lblPoint.setBorder(BorderFactory.createLineBorder(Color.pink)) ;
		txtPoint = new JTextArea(3, 40) ;
		txtPoint.setBorder(BorderFactory.createLineBorder(Color.blue)) ;
		btnBack = new JButton("返回") ;
		gbl = new GridBagLayout() ;
		gbc = new GridBagConstraints() ;
		content = frame.getContentPane() ;
		content.setLayout(gbl) ;
	    //
	    gbc.gridx = 0 ;
	    gbc.gridy = 0 ;
	    gbc.gridwidth = 8 ;
	    gbc.gridheight = 1 ;
	    gbl.setConstraints(lblPoint, gbc) ;
	    content.add(lblPoint) ;
	    //
	    gbc.gridx = 0 ;
	    gbc.gridy = gbc.gridy + 1 ;
	    gbc.gridwidth = 8 ;
	    gbc.gridheight = 3 ;
	    gbl.setConstraints(txtPoint, gbc) ;
	    content.add(txtPoint) ;
	    //
	    gbc.gridx = 7 ;
	    gbc.anchor = GridBagConstraints.EAST ;//这样便可以使得按钮放在最右边了！
	    gbc.gridy = gbc.gridy + 3 ;
	    gbc.gridwidth = 1 ;
	    gbc.gridheight = 1 ;
	    gbc.ipadx = 6 ;
	    gbc.ipady = -4 ;
	    gbl.setConstraints(btnBack, gbc) ;
	    content.add(btnBack) ;
	    //
	    btnBack.addActionListener(new ActionListener()
	        {
	        	public void actionPerformed(ActionEvent e)
	        	{
	        		//把此时number写入到数据库中
	        		try
					{
						Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
					}
					catch(Exception es)
					{
						JOptionPane.showMessageDialog(null, e.toString()) ;
					}
					try
					{
						Connection con = DriverManager.getConnection("jdbc:odbc:Hotel") ;
						Statement  smt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                        			            			 ResultSet.CONCUR_UPDATABLE);
                        try
                        {
                        	smt.executeUpdate("update table_Number set 号码="+number+" where 名称='已读取个数'") ;
                        	JOptionPane.showMessageDialog(null, "返回时候更新号码到数据库成功！"+number) ;
                        }
                        catch(SQLException co)
                        {
                        	JOptionPane.showMessageDialog(null, co.toString()) ;
                        }
                    }
                    catch(SQLException c)
                    {
                    	JOptionPane.showMessageDialog(null, c.toString()) ;
                    }
	        	}//处理函数结束！
	        }) ;//监听类结束！
	    //
		frame.pack() ;
		frame.setLocation(140, 140) ;
		frame.setVisible(true) ;
	}
	
	public MainStudyUnAuto()
	{
		init() ;
	
	}
	
	public static void main(String args[])
	{
		new MainStudyUnAuto() ;
		//载入初始化信息
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
		}
		catch(Exception e)
		{
			JOptionPane.showMessageDialog(null, e.toString()) ;
		}
		try
		{
			Connection con = DriverManager.getConnection("jdbc:odbc:Hotel") ;
			Statement  smt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                        			             ResultSet.CONCUR_UPDATABLE);
            try
            {
            	ResultSet rst = smt.executeQuery("select * from table_Number") ;
            	rst.absolute(1) ;
            	number = rst.getInt(2) ;
            	JOptionPane.showMessageDialog(null, "载入初始信息成功：number"+number) ;
            }
            catch(SQLException h)
            {
            	JOptionPane.showMessageDialog(null, h.toString()) ;
            }
            
            smt.close() ;
            con.close() ;
        }
        catch(SQLException ee)
        {
        	JOptionPane.showMessageDialog(null, ee.toString()) ;
        }
		
		
	    //进行读取操作
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
		}
		catch(Exception e)
		{
			JOptionPane.showMessageDialog(null, e.toString()) ;
		}
		//连接数据库
		try
		{
			Connection con = DriverManager.getConnection("jdbc:odbc:Hotel") ;
			Statement  smt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                        			             ResultSet.CONCUR_UPDATABLE);
            int num = 1 ;
            try
            {
            	ResultSet rst = smt.executeQuery("select * from tab_SysStudy") ;
            	rst.beforeFirst() ;
            	
            	while(rst.next())
            	{
            		if(num == number)
            		    break ;
            	    num++ ;
            	}
            	

        
            	
            	while(rst.next())
                {
                	JOptionPane.showMessageDialog(null, "这个地方现在应该也要执行！") ;
                	//对txtPoint进行颜色设置
                	if(rowOfTable % 2 == 0)
                	    txtPoint.setBackground(Color.cyan) ;
                	else if(rowOfTable % 3 == 0)
                	    txtPoint.setBackground(Color.green) ;
                	else if(rowOfTable % 5 == 0)
                	    txtPoint.setBackground(Color.orange) ;
                	else if(rowOfTable % 7 == 0)
                	    txtPoint.setBackground(Color.red) ;
                	else if(rowOfTable % 8 == 0)
                	    txtPoint.setBackground(Color.darkGray) ;
                    else
                        txtPoint.setBackground(Color.pink) ;
                        
                    int intNumber = rst.getInt(1) ;
                    String strPoint = rst.getString(2) ;
                    frame.setTitle("知识点："+intNumber) ;
                    txtPoint.setText(strPoint) ;
                    number++ ;
                    time(setTime) ;
                }
                
            	
            }
            catch(SQLException ee)
            {
            	JOptionPane.showMessageDialog(null, ee.toString()) ;
            }
            smt.close() ;
		    con.close() ;
            
            
		}
		catch(SQLException ee)
		{
			JOptionPane.showMessageDialog(null, ee.toString()) ;
		}
		
	}

}