Monday, 5 November 2012

Simple connection string


try
        {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        Connection con = DriverManager.getConnection("jdbc:odbc:Test");
        String sql = "Select * from login";
        java.sql.Statement stmt =  con.createStatement();
        ResultSet rs = stmt.executeQuery( sql );
        while(rs.next())
        {
            String username=rs.getString("uname");
            String pasword=rs.getString("pword");
            System.out.println(username);
            System.out.println(pasword);
        }
        }
        catch(Exception e)
        {
           
        }

DBT - Models

Models are where your developers spend most of their time within a dbt environment. Models are primarily written as a select statement and ...