dbconnection.java

来自「A brew application taking backup of the 」· Java 代码 · 共 67 行

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package IPhone;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;

public class DBConnection {
    Connection conn = null;
    Statement stmt = null;
    ResultSet rs;    
    public Connection Mobile_Master() {
            try {
                if(conn==null){
                    System.out.println("Loading Driver..");
                    Class.forName("com.mysql.jdbc.Driver");
                    conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/iphone","vikas","vikas");
                }
            } catch (Exception e) {
                e.printStackTrace();
            }
        return conn;
    }

    public void insert(String Query) {
        if(conn==null)
        conn= Mobile_Master();
        try {
            stmt = conn.createStatement();
            stmt.execute(Query);
        } catch (SQLException ex) {
            Logger.getLogger(DBConnection.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

    public void delete(String Query) {
        if(conn==null)
        conn=Mobile_Master();
        insert(Query);
    }

    public ResultSet select(String Query) {
        if(conn==null)
        conn=Mobile_Master();
        try {
            stmt = conn.createStatement();
            stmt.execute(Query);
            rs = stmt.getResultSet();
        } catch (SQLException ex) {
            Logger.getLogger(DBConnection.class.getName()).log(Level.SEVERE, null, ex);
        }
        return rs;
    }

    public void Create(String Query) {
        insert(Query);
    }
}