db.java

背单词的软件

// Decompiled by Jad v1.5.7g. Copyright 2000 Pavel Kouznetsov.
// Jad home page: http://www.geocities.com/SiliconValley/Bridge/8617/jad.html
// Decompiler options: packimports(3) fieldsfirst ansi 
// Source File Name:   Db.java
//coded by lengping
//all right reserved

import java.io.PrintStream;
import java.sql.*;
import java.util.List;
import java.util.Calendar;
import java.util.LinkedList;
import java.util.ArrayList;

public class Db
{

    ResultSet rs1;
    Connection cn1;
    PreparedStatement stmt1;
    int groups;

    public Db()
    {
    }

    public void setwordspg(int i)	//abondaned
    {
    }

    void connect()
    {
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            cn1 = DriverManager.getConnection("jdbc:odbc:word");
        }
        catch(ClassNotFoundException classnotfoundexception)
        {
            System.out.println("driver not found");
        }
        catch(SQLException sqlexception)
        {
            sqlexception.printStackTrace(System.err);
        }
    }

    void close()
    {
        try
        {
            cn1.close();
        }
        catch(SQLException sqlexception) { }
    }

    void getGroup(List list, int i)
    {
        try
        {
            list.clear();
            connect();
            String s = "select * from " + Person.book + " where id  between ? and ?";
            stmt1 = cn1.prepareStatement(s);
            stmt1.setInt(1, (i - 1) * Person.wordspg + 1);
            stmt1.setInt(2, i * Person.wordspg);
            System.out.println(i);
            Word word;
            for(rs1 = stmt1.executeQuery(); rs1.next(); list.add(word))
            {
                word = new Word();
                word.dc = rs1.getString("a");
                word.yb = rs1.getString("b");
                word.zs = rs1.getString("c");
            }

            if(list.size() < Person.wordspg)
            {
                String s1 = "select * from " + Person.book + " where id  between ? and ?";
                stmt1 = cn1.prepareStatement(s1);
                stmt1.setInt(1, 1);
                stmt1.setInt(2, Person.wordspg - list.size());
                Word word1;
                for(rs1 = stmt1.executeQuery(); rs1.next(); list.add(word1))
                {
                    word1 = new Word();
                    word1.dc = rs1.getString("a");
                    word1.yb = rs1.getString("b");
                    word1.zs = rs1.getString("c");
                }

            }
            close();
            System.out.println("get ok");
        }
        catch(SQLException sqlexception)
        {
            sqlexception.printStackTrace(System.err);
        }
    }

    void updatePerson()
    {
        try
        {
            connect();
            String s = "update person set maxgroup=?,book=?,wordgroup=?,dcdbgroup=?,wordspg=? where personid=?";
            stmt1 = cn1.prepareStatement(s);
            stmt1.setInt(1, Person.maxgroup);
            stmt1.setString(2, Person.book);
            stmt1.setInt(3, Person.group);
            stmt1.setInt(4, Person.dcdbgroup);
            stmt1.setInt(5, Person.wordspg);
            stmt1.setInt(6, Person.personid);
            int i = stmt1.executeUpdate();
            close();
        }
        catch(SQLException sqlexception)
        {
            sqlexception.printStackTrace(System.err);
        }
    }

    void getPerson()
    {
        try
        {
            connect();
            String s = "select personid,book,wordgroup,dcdbgroup,wordspg,maxgroup from person where name=? order by personid ";
            stmt1 = cn1.prepareStatement(s);
            stmt1.setString(1, Person.name);
            rs1 = stmt1.executeQuery();
            if(rs1.next())
            {	
                Person.personid = rs1.getInt(1);
                Person.book = rs1.getString(2);
                Person.group = rs1.getInt(3);
                Person.dcdbgroup=rs1.getInt(4);
                Person.wordspg = rs1.getInt(5);
                Person.maxgroup = rs1.getInt(6);
            }
            close();
        }
        catch(SQLException sqlexception)
        {
            sqlexception.printStackTrace(System.err);
        }
    }
    
    void getBookList(LinkedList ll)
    {
        try
        {
            connect();
            String s = "select bookname,book,words from booklist  order by bookid ";
            stmt1 = cn1.prepareStatement(s);
            rs1 = stmt1.executeQuery();
            Book b1;
            while(rs1.next())
            {
            	b1=new Book();
            	b1.bookname=rs1.getString(1);
            	b1.book=rs1.getString(2);
            	b1.words=rs1.getInt(3);
            	ll.add(b1);
            }
            close();
        }
        catch(SQLException sqlexception)
        {
            sqlexception.printStackTrace(System.err);
        }
    }
    
    void addStudylog(Studylog sl)
    {
        try
        {
        	
            connect();
            String cmd="insert into studylog (personid,function,grade,day,book,wordgroup) values(?,?,?,?,?,?)";
            stmt1 = cn1.prepareStatement(cmd);
            stmt1.setInt(1,sl.personid);
            stmt1.setInt(2,sl.function);
            stmt1.setInt(3,sl.grade);
            stmt1.setDate(4,new Date(sl.day.getTimeInMillis()));
            stmt1.setString(5,sl.book);
            stmt1.setInt(6,sl.wordgroup);
            stmt1.executeUpdate();
            close();
            
            
        }
        catch(SQLException sqlexception) { }
    }


    void getStudylog(ArrayList al)
    {
        try
        {
            connect();
            String cmd="select function,grade,day,book,wordgroup from studylog where personid=?";
            stmt1 = cn1.prepareStatement(cmd);
            stmt1.setInt(1,Person.personid);
            rs1 = stmt1.executeQuery();
            Studylog sl;
            
            while(rs1.next()){
            	sl=new Studylog();
            	sl.function=rs1.getInt(1);
            	sl.grade=rs1.getInt(2);
            	sl.day=Calendar.getInstance();
            	sl.day.setTimeInMillis(rs1.getDate(3).getTime() );
            	sl.book=rs1.getString(4);
            	sl.wordgroup=rs1.getInt(5);
            	
            	al.add(sl);
            	
            }
            close();
            
            
        }
        catch(SQLException sqlexception) { }
    }

}