insertordelete.java

来自「野生动物系统的JAVA源码, 野生动物系统的JAVA源码」· Java 代码 · 共 52 行

package scout.database.util;

/**
 * <p>Title: </p>
 *
 * <p>Description:this class connect database of my sql,and return the object of connection </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: Chongqing Kemeida corporation</p>
 *
 * @author Bozeng
 * @version 1.0
 */
import java.sql.*;
import java.util.*;


public class InsertOrDelete {
    Connection conn = null;
    /**
     * init parameter
     * @param conn Connection
     */
    public InsertOrDelete(Connection conn) {
        this.conn = conn;
    }

    /**
     * this method is for insert or delete data from database
     * @param sqlStr String
     * @return int
     */
    public int inOrDel(String sqlStr) {
        int flag = 0;
        try {
            Statement stmt = conn.createStatement();
            stmt.executeUpdate(sqlStr);
            flag = 1;
            stmt.close();
        } catch (java.sql.SQLException e) {
            System.out.println(
                    "insert or delete data from dabase have occured exception!");
        }
        return flag;
    }

    public static void main(String[] args) {
        //InsertOrDelete insertordelete = new InsertOrDelete();
    }
}