mainstudyauto[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 MainStudyAuto
{
	static int row = 1 ;//记录读取的行
	static int rowOfTable = 0 ;
	static JFrame frame ;
	static JButton btnShow, btnNext, btnUpdate ;
	static JTextArea txtPoint, txtMain ;
	static JLabel lblPoint, lblMain ;
	static JPanel panUp, panUnder ;
	static GridBagLayout gbl ;
	static GridBagConstraints gbc ;
	static Container content ;
	
	public static void init()
	{
		JFrame.setDefaultLookAndFeelDecorated(true);//把JFrame设置城修饰的外观！
        //
	    frame = new JFrame("知识点读取----自动-----选择性");
		frame.setSize(600, 200) ;
		//
		
		content = frame.getContentPane() ;
		gbl = new GridBagLayout() ;
		gbc = new GridBagConstraints() ;
		gbc.fill = GridBagConstraints.NONE ;
		content.setLayout(gbl) ;
		//////////////////////////////////////////////////////////////
		//对panUp进行布局！
		//////////////////////////////////////////////////////////////
		lblPoint = new JLabel("知识简要:", SwingConstants.LEFT) ;
        txtPoint = new JTextArea(3, 40) ;
		txtPoint.setBorder(BorderFactory.createEtchedBorder()) ;
		txtPoint.setBackground(Color.white) ;
		//txtPoint.setFont(font) ;
		panUp = new JPanel(new BorderLayout()) ;
		panUp.add(lblPoint, "West") ;
		panUp.add(txtPoint, "East") ;
		//////////////////////////////////////////////////////////////
		//对panUnder进行布局！
		//////////////////////////////////////////////////////////////
		lblMain = new JLabel("知识阐述:", SwingConstants.LEFT) ;
	    txtMain = new JTextArea(4, 40) ;
		txtMain.setBorder(BorderFactory.createEtchedBorder()) ;
		txtMain.setBackground(Color.white) ;
		panUnder = new JPanel(new BorderLayout()) ;
		panUnder.add(lblMain, "West") ;
		panUnder.add(txtMain, "East") ;
		//
		gbc.gridx = 0 ;
		gbc.gridy = 0 ;
		gbc.gridwidth = 6 ;
		gbc.gridheight = 3 ;
		gbl.setConstraints(panUp, gbc) ;
		content.add(panUp) ;
		//
		gbc.gridx = 0 ;
		gbc.gridy = gbc.gridy + 6 ;
		gbc.gridwidth = 6 ;
		gbc.gridheight = 4 ;
		gbl.setConstraints(panUnder, gbc) ;
		content.add(panUnder) ;
		//
		btnShow = new JButton("显示描述") ;
		btnShow.addActionListener(new ActionListener()
		    {
		    	public void actionPerformed(ActionEvent e)
		    	{
		    		frame.setVisible(false) ;
		    		frame.dispose() ;
		    		init() ;
		    		frame.setResizable(false) ;
		    		try
		            {
			    		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
					}
					catch(Exception te)
					{
						JOptionPane.showMessageDialog(null, te.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 tab_SysStudy where 知识等级=1") ;
            				rst.absolute(row) ;
            				txtMain.setBackground(Color.pink) ;
            				txtPoint.setText(rst.getString(2)) ;
            				txtMain.setText(rst.getString(3)) ;
            			}
            			catch(SQLException ee)
            			{
            				JOptionPane.showMessageDialog(null, ee.toString()) ;
            			}
            
            
					}
					catch(SQLException ee)
					{
						JOptionPane.showMessageDialog(null, ee.toString()) ;
					}
		    		
		    	}//处理函数结束！
		    	
				
		    }) ;//监听类结束！
		gbc.gridx = gbc.gridx + 6 ;
		gbc.gridy = gbc.gridy ;
		gbc.gridwidth = 1 ;
		gbc.gridheight = 1 ;
		gbc.ipadx = 20 ;
		gbc.ipady = -2 ;
		gbl.setConstraints(btnShow, gbc) ;
		content.add(btnShow) ;
		//
		btnNext = new JButton("查看下条") ;
		btnNext.addActionListener(new ActionListener()
	        {
	        	public void actionPerformed(ActionEvent e)
	        	{
	        		frame.setVisible(false) ;
	        		frame.dispose() ;
	        		new MainStudyUnAuto() ;
	        		row++ ;
	        		if(row > rowOfTable)
	        		{
	        			JOptionPane.showMessageDialog(null, "知识点已经读取完毕\n共读取知识点"+(row-1)+"个") ;
	        		}
	        		if(row <= rowOfTable)
	        		{
	        		
	        		try
		            {
			    		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
					}
					catch(Exception te)
					{
						JOptionPane.showMessageDialog(null, te.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 tab_SysStudy where 知识等级=1") ;
            				rst.absolute(row) ;
            				txtPoint.setText(rst.getString(2)) ;
            				txtMain.setText(rst.getString(3)) ;
            			}
            			catch(SQLException ee)
            			{
            				JOptionPane.showMessageDialog(null, ee.toString()) ;
            			}
            
            
					}
					catch(SQLException ee)
					{
						JOptionPane.showMessageDialog(null, ee.toString()) ;
					}
					}
	        		
	        	}//处理函数结束！
	        }) ;//监听类结束！
		gbc.gridx = gbc.gridx ;
		gbc.gridy = gbc.gridy + 1 ;
		gbc.gridwidth = 1 ;
		gbc.gridheight = 1 ;
		gbc.ipadx = 20 ;
		gbc.ipady = -4 ;
		gbl.setConstraints(btnNext, gbc) ;
		content.add(btnNext) ;
		//
		btnUpdate = new JButton("修改等级") ;
		btnUpdate.addActionListener(new ActionListener()
		    {
		    	public void actionPerformed(ActionEvent e)
		    	{
		    		boolean bool = false ;
		    		Object[] grades = {"0", "1"} ;
                    Object selectedGrade =JOptionPane.showInputDialog(null, "请为单词选择一个等级：",
                                                           "单词等级选择框", JOptionPane.INFORMATION_MESSAGE,null,
                                                           grades, grades[0]) ;
                    String temp = selectedGrade.toString() ;
                    int intGrade = Integer.parseInt(temp) ;
                    ////////////////////////////////////////////////////////////////////
                    //下面进行数据相关操作
                    ////////////////////////////////////////////////////////////////////
                    try
                    {
                    	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
                    }
                    catch(Exception ee)
                    {
                    	JOptionPane.showMessageDialog(null, ee.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 tab_SysStudy") ;
                        	rst.absolute(row) ;
                        	int intTemp = rst.getInt(1) ;
                        	smt.executeUpdate("update tab_SysStudy set 知识等级="+intGrade+" where 序列号码="+intTemp) ;
                        	bool = true ;
                        }
                        catch(SQLException n)
                        {
                        	JOptionPane.showMessageDialog(null, n.toString()) ;
                        }
                    }
                    catch(SQLException eee)
                    {
                    	JOptionPane.showConfirmDialog(null, eee.toString()) ;
                    }
                    if(bool)
                        JOptionPane.showMessageDialog(null, "修改成功！") ;
		    	}//处理函数结束！
		    }) ;//监听类结束！
		gbc.gridx = gbc.gridx ;
		gbc.gridy = gbc.gridy + 1 ;
		gbc.gridwidth = 1 ;
		gbc.gridheight = 1 ;
		gbc.ipadx = 20 ;
		gbc.ipady = -4 ;
		gbl.setConstraints(btnUpdate, gbc) ;
		content.add(btnUpdate) ;
		//
		frame.pack() ;
		frame.setLocation(140, 140) ;
		frame.setVisible(true) ;
	}
	
	public MainStudyAuto()
	{
		init() ;
		frame.setVisible(false) ;
		content.remove(panUnder) ;
		frame.pack() ;
		frame.setLocation(140, 140) ;
		frame.setResizable(false) ;
		frame.setVisible(true) ;
	}
	
	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 tab_SysStudy where 知识等级=1") ;
            	while(rst.next())
            	    rowOfTable++ ;
            	rst.absolute(1) ;
            	txtPoint.setText(rst.getString(2)) ;
            	txtMain.setText(rst.getString(3)) ;
            }
            catch(SQLException ee)
            {
            	JOptionPane.showMessageDialog(null, ee.toString()) ;
            }
            
            
		}
		catch(SQLException ee)
		{
			JOptionPane.showMessageDialog(null, ee.toString()) ;
		}
		
	}

}