Tuesday, August 13, 2013

java and mysql database connection using commoncode for Project

package commoncode;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

/**
 *
 * @author User
 */
public class DB_Conn {

    /**
     * @param args the command line arguments
     */
    public static Connection con = null;  
    public static Statement st = null;
    public static Statement stmt = null;
    public static Statement stmt1 = null;
    public static Statement stmt2 = null;
    public static Statement stmt3 = null;
    public static Statement stmt4 = null;
    public static Statement stmt5 = null;
    public static Statement stmt6 = null;
    public static Statement stmt7 = null;
    public static Statement stmt8 = null;
    public static Statement stmt9 = null;
    public static Statement stmt10 = null;
   
    public static Statement stmt11 = null;
    public static Statement stmt12 = null;
    public static Statement stmt13 = null;
    public static Statement stmt14 = null;
    public static Statement stmt15 = null;
    public static Statement stmt16 = null;
    public static Statement stmt17 = null;
    public static Statement stmt18 = null;
    public static Statement stmt19 = null;
    public static Statement stmt20 = null;
    public static Statement stmt21 = null;
    public static Statement stmt22 = null;
    public static Statement stmt23 = null;
    public static Statement stmt24 = null;
    public static Statement stmt25 = null;
    public static Statement stmt26 = null;
    public static Statement stmt27 = null;
    public static Statement stmt28 = null;
    public static Statement stmt29 = null;
    public static Statement stmt30 = null;
    public static Statement stmt31 = null;
    public static Statement stmt32 = null;
    public static Statement stmt33 = null;
    public static Statement stmt34 = null;
    public static Statement stmt35 = null;
    public DB_Conn()
    {
        try
        {
           
        String conurl = "jdbc:mysql://localhost:3306/botnet";


        Class.forName("com.mysql.jdbc.Driver").newInstance();
        con = DriverManager.getConnection(conurl, "root", "admin");
        System.out.println("Database_Connected");
        st = con.createStatement();
        stmt = con.createStatement();
        stmt1 = con.createStatement();
        stmt2 = con.createStatement();
        stmt3 = con.createStatement();
        stmt4 = con.createStatement();
        stmt5 = con.createStatement();
        stmt6  =  con.createStatement();
            stmt7  =  con.createStatement();
            stmt8  =  con.createStatement();
            stmt9  =  con.createStatement();
            stmt10  =  con.createStatement();          
            stmt11  =  con.createStatement();
            stmt12  =  con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
            stmt13  =  con.createStatement();
            stmt14  =  con.createStatement();
            stmt15  =  con.createStatement();
            stmt16  =  con.createStatement();
            stmt17  =  con.createStatement();
            stmt18  =  con.createStatement();
            stmt19  =  con.createStatement();
            stmt20  =  con.createStatement();
            stmt21  =  con.createStatement();
            stmt22  =  con.createStatement();
            stmt23  =  con.createStatement();
            stmt24  =  con.createStatement();
            stmt25  =  con.createStatement();
            stmt26  =  con.createStatement();
            stmt27  =  con.createStatement();
            stmt28  =  con.createStatement();
            stmt29  =  con.createStatement();
            stmt30  =  con.createStatement();
            stmt31  =  con.createStatement();
            stmt32  =  con.createStatement();
            stmt33  =  con.createStatement();
            stmt34  =  con.createStatement();
            stmt35  =  con.createStatement();
            System.out.println("connected");
        }
        catch(Exception e)
        {
            System.out.println("Error in DB_Conn.java " + e.getMessage());
        }
    }
    public static void main(String[] args) {
        // TODO code application logic here
        new DB_Conn();
    }
}

Checking Resulset contain Null records in mysql Query using Java

 String FPS_Qry = "Select length from tbl_dataset ";

ResultSet rstt = db.stmt9.executeQuery(FPS_Qry);
                String FPS = "";
                if (!rstt.wasNull()) {

                    while (rstt.next()) {

                        if (rstt.getString(1) != null) {
                            FPS = rstt.getString(1);
                        }
                    }
                }