datatools.java

来自「使用短信猫发送短信的程序源代码」· Java 代码 · 共 71 行

// Decompiled by DJ v3.9.9.91 Copyright 2005 Atanas Neshkov  Date: 2007-12-13 22:52:10
// Home Page : http://members.fortunecity.com/neshkov/dj.html  - Check often for new version!
// Decompiler options: packimports(3) 
// Source File Name:   DataTools.java

import java.sql.*;

public class DataTools
{

    public DataTools(String driver,String s, String s1, String s2)
    {
    	strDriver = driver;
        strURL = s;
        strUsername = s1;
        strPassword = s2;
    }

    public boolean DataConnect()
    {
        try
        {
            Class.forName(strDriver).newInstance();
            conn = DriverManager.getConnection(strURL, strUsername, strPassword);
        }
        catch(Exception exception)
        {
            return false;
        }
        return true;
    }

    public boolean DataDisconnect()
    {
        try
        {
            conn.close();
        }
        catch(Exception exception)
        {
            return false;
        }
        return true;
    }

    public int CheckExisted(String s)
    {
        int i = -1;
        try
        {
            Statement statement = conn.createStatement();
            ResultSet resultset = statement.executeQuery(s);
            if(resultset.next())
                i = resultset.getInt(1);
            resultset.close();
            statement.close();
        }
        catch(SQLException sqlexception)
        {
            System.out.println("Database Error.");
        }
        return i;
    }


    public Connection conn;
    private String strURL;
    private String strUsername;
    private String strPassword;
    private String strDriver;
}