sampledb.java

刚刚学习jdbc数据库

package myprojects.smalldatabase;
import java.sql.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
public class Sampledb
{
	java.sql.Connection con;
	java.sql.Statement sta;
	java.sql.ResultSet rs;
	private JTextField nametext,agetext,jobtext;
	private JComboBox sexcombox,levcombox;
	public Sampledb()
	{
		try 
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			con=DriverManager.getConnection("jdbc:odbc:oo");
	    }
	    catch (Exception ex) 
	    {
	    	System.out.println ("con"+ex);
	    }
	}
	public Sampledb(JTextField nametext,JTextField agetext,JTextField jobtext,JComboBox sexcombox,JComboBox levcombox)
	{
		
		this.nametext=nametext;
		this.agetext=agetext;
		this.jobtext=jobtext;
		this.sexcombox=sexcombox;
		this.levcombox=levcombox;
		try 
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			con=DriverManager.getConnection("jdbc:odbc:oo");
	    }
	    catch (Exception ex) 
	    {
	    	System.out.println ("con"+ex);
	    }
	}
	
	public boolean insertSql(String name,int age,String sex,String slevel,String job)
	{
		boolean f=false;
		int number=0;
		try 
		{
			sta=con.createStatement();
			String insert="insert into logintable values('"+name+"','"+age+"','"+sex+"','"+slevel+"','"+job+"')";
			number=sta.executeUpdate(insert);
		}
	    catch (Exception ex) 
	    {
	    	System.out.println ("insertsql"+ex);
	    }
	    if(number>0)
	    {
	    	f=true;
	    }
	    return f;		
	}
	public void findSql(String name,int age,String sex,String slevel,String job)
	{
		boolean f=false;
		int number=0;
		try 
		{
			sta=con.createStatement();
			rs=sta.executeQuery("select * from logintable where(name='"+name+"')");
			while(rs.next())
			{
				String name1=rs.getString("name");
				int age1=rs.getInt("age");
				String sex1=rs.getString("sex");
				String slevel1=rs.getString("slevel");
				String job1=rs.getString("job");			
				this.nametext.setText(name1);
				this.agetext.setText(""+age1);
				this.sexcombox.setSelectedItem(sex1);
				this.levcombox.setSelectedItem(slevel1);
				this.jobtext.setText(job1);	
				break;
				
			}
		}
	    catch (Exception ex) 
	    {
	    	System.out.println ("findSql"+ex);
	    }
	}
	public boolean deleteSql(String name)
	{
		boolean f=false;
		int number=0;
		try 
		{
			sta=con.createStatement();
			String delete="delete logintable where(name='"+name+"')";
			number=sta.executeUpdate(delete);
		}
	    catch (Exception ex) 
	    {
	    	System.out.println ("deletesql"+ex);
	    }
	    if(number>0)
	    {
	    	f=true;
	    }
	    return f;		
	}
	public boolean modifySql(String name,int age,String sex,String slevel,String job)
	{
		boolean f=false;
		int number=0;
		try 
		{
			sta=con.createStatement();
			
			String insert="update logintable set name='"+name+"',age='"+age+"',sex='"+sex+"',slevel='"+slevel+"',job='"+job+"' where(name='"+name+"')";
			number=sta.executeUpdate(insert);
			
		}
	    catch (Exception ex) 
	    {
	    	System.out.println ("modifysql"+ex);
	    }
	    if(number>0)
	    {
	    	f=true;
	    }
	    return f;		
	}
	public void initSql()
	{
		try 
		{
			sta=con.createStatement();
			rs=sta.executeQuery("select * from logintable");
			while(rs.next())
			{
				String name1=rs.getString("name");
				int age1=rs.getInt("age");
				String sex1=rs.getString("sex");
				String slevel1=rs.getString("slevel");
				String job1=rs.getString("job");			
				this.nametext.setText(name1);
				this.agetext.setText(""+age1);
				this.sexcombox.setSelectedItem(sex1);
				this.levcombox.setSelectedItem(slevel1);
				this.jobtext.setText(job1);
				
				break;
			}
		}
	    catch (Exception ex) 
	    {
	    	System.out.println ("initSql"+ex);
	    }		
	}
	public void nextSql(int j,JButton prior,JButton next)
	{
		int k=this.lengthSql();
		try 
		{
			sta=con.createStatement();
			rs=sta.executeQuery("select * from logintable");
			int q=0;
			if(j==2)
			{
				prior.setEnabled(true);
			}
			if(j==k)
			{
				next.setEnabled(false);
			}
			while(rs.next())
			{
				q++;
				
				if(q==j)
				{
					String name1=rs.getString("name");
					int age1=rs.getInt("age");
					String sex1=rs.getString("sex");
					String slevel1=rs.getString("slevel");
					String job1=rs.getString("job");			
					this.nametext.setText(name1);
					this.agetext.setText(""+age1);
					this.sexcombox.setSelectedItem(sex1);
					this.levcombox.setSelectedItem(slevel1);
					this.jobtext.setText(job1);
					break;
				}				
			}
		}
	    catch (Exception ex) 
	    {
	    	System.out.println ("nextSql"+ex);
	    }		
	}
	public void priorSql(int j,JButton prior,JButton next)
	{
		int k=this.lengthSql();
		try 
		{
			sta=con.createStatement();
			rs=sta.executeQuery("select * from logintable");
			
			int q=0;
			while(rs.next())
			{
				q++;
				if(j==1)
				{
					prior.setEnabled(false);
				}
				if(j==k-1)
				{
					next.setEnabled(true);
				}
				if(q==j)
				{
					String name1=rs.getString("name");
					int age1=rs.getInt("age");
					String sex1=rs.getString("sex");
					String slevel1=rs.getString("slevel");
					String job1=rs.getString("job");			
					this.nametext.setText(name1);
					this.agetext.setText(""+age1);
					this.sexcombox.setSelectedItem(sex1);
					this.levcombox.setSelectedItem(slevel1);
					this.jobtext.setText(job1);
					
					
					break;
				}
				
			}
		}
	    catch (Exception ex) 
	    {
	    	System.out.println ("priorSql"+ex);
	    }		
	}
	public int lengthSql()
	{
		int i=0;
		try 
		{
			
			sta=con.createStatement();
			rs=sta.executeQuery("select * from logintable");
			while(rs.next())
				i++;	
		}
	    catch (Exception ex) 
	    {
	    	System.out.println ("lengthSql"+ex);
	    }
	    return i;		
	}
}