chuti.java

来自「用java写的一个简单的在线考试系统」· Java 代码 · 共 87 行

/*
 * chuti.java
 *
 * Created on 2008年6月19日, 下午6:04
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package mypacke;

import java.awt.List;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

/**
 *
 * @author bzu
 */
public class chuti {
    private  Connection con;
    private  ResultSet set;
    private  Statement sta;
    private  java.util.List list=new ArrayList();
  
    public chuti() {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        }
    }
   public void con()
   {
        try {
            con=DriverManager.getConnection("Jdbc:Odbc:xing");
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
       
   }
   public void closeCon()
   {
     
           
            try { 
                if(con!=null)
                con.close();
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
   }
   public ResultSet result(String str)
   {
       con();
        try {
            sta=con.createStatement();
            set=sta.executeQuery(str);
            
            
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
       return set;
       
   }
    public int count()
    {
        String str="select * from chuti";
        set=result(str);
        try {
            while(set.next())
            {
                From form=new From(set.getString(1),set.getString(2),set.getString(3),set.getString(4),set.getString(5),set.getString(6),set.getString(7));
                list.add(form);
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
     return list.size();  
    }
}