ORMLite - 1.0

package com.spring.ormlite.entities;

import com.j256.ormlite.field.DatabaseField;
import com.j256.ormlite.table.DatabaseTable;

@DatabaseTable(tableName = "record")
public class GeneralRecord {
    
    @DatabaseField(id = true)
    int id;

    @DatabaseField
    String name;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public GeneralRecord(int id, String name) {
        super();
        this.id = id;
        this.name = name;
    }

    public GeneralRecord() {
        super();
        // TODO Auto-generated constructor stub
    }

    @Override
    public String toString() {
        return "GeneralRecord [id=" + id + ", name=" + name + "]";
    }
    
    
}

import com.j256.ormlite.dao.Dao;
import com.j256.ormlite.dao.DaoManager;
import com.j256.ormlite.jdbc.JdbcConnectionSource;
import com.j256.ormlite.jdbc.db.MysqlDatabaseType;
import com.j256.ormlite.stmt.*;
import com.j256.ormlite.support.ConnectionSource;

public class generateGeneralApp{

public static void generateGeneralRecord() throws Exception {
          String databaseUrl = "jdbc:mysql://localhost:3306/ormlite";
            //String databaseUrl = "jdbc:h2:~/test";
            ConnectionSource connectionSource =
                    new JdbcConnectionSource(databaseUrl,"root","root",new MysqlDatabaseType());

            System.out.println("Connection successfull");
            
            Dao<GeneralRecord,String> recordDao =
                    DaoManager.createDao(connectionSource, GeneralRecord.class);

            TableUtils.createTableIfNotExists(connectionSource, GeneralRecord.class);

           int name = 2;        
           GeneralRecord record = new GeneralRecord(name, "record "+name);


           recordDao.create(record);
           connectionSource.close();
    }
}

package com.example.helloandroid;

import java.util.List;
import java.util.Random;
import android.os.Bundle;
import android.text.method.ScrollingMovementMethod;
import android.util.Log;
import android.widget.TextView;
import com.j256.ormlite.android.apptools.OrmLiteBaseActivity;
import com.j256.ormlite.dao.RuntimeExceptionDao;

/**
 * Sample Android UI activity which displays a text window when it is run.
 */
public class HelloAndroid extends OrmLiteBaseActivity<DatabaseHelper> {

	private final String LOG_TAG = getClass().getSimpleName();
	private final static int MAX_NUM_TO_CREATE = 8;

	/**
	 * Called when the activity is first created.
	 */
	@Override
	public void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		Log.i(LOG_TAG, "creating " + getClass() + " at " + System.currentTimeMillis());
		TextView tv = new TextView(this);
		tv.setMovementMethod(new ScrollingMovementMethod());
		doSampleDatabaseStuff("onCreate", tv);
		setContentView(tv);
	}

	/**
	 * Do our sample database stuff.
	 */
	private void doSampleDatabaseStuff(String action, TextView tv) {
		// get our dao
		RuntimeExceptionDao<SimpleData, Integer> simpleDao = getHelper().getSimpleDataDao();
		// query for all of the data objects in the database
		List<SimpleData> list = simpleDao.queryForAll();
		// our string builder for building the content-view
		StringBuilder sb = new StringBuilder();
		sb.append("Found ").append(list.size()).append(" entries in DB in ").append(action).append("()\n");
		
		int createNum;
		do {
			createNum = new Random().nextInt(MAX_NUM_TO_CREATE) + 1;
		} while (createNum == list.size());
		sb.append("Creating ").append(createNum).append(" new entries:\n");
		for (int i = 0; i < createNum; i++) {

			long millis = System.currentTimeMillis();
			SimpleData simple = new SimpleData(millis);
			simpleDao.create(simple);
			Log.i(LOG_TAG, "created simple(" + millis + ")");
			
		}
	}
}

public static void updateSchoolData() throws SQLException {
        
        String databaseUrl = "jdbc:mysql://localhost:3306/ormlite";
        ConnectionSource connectionSource =
                new JdbcConnectionSource(databaseUrl,"root","root",new MysqlDatabaseType());
        
        Dao<School,String> schoolDao =
                DaoManager.createDao(connectionSource, School.class);

         School s = new School("5","sunbeam");  
            
           schoolDao.updateId(s,"8");
        
    }

public static void deleteSchoolData() throws SQLException {
           
        String databaseUrl = "jdbc:mysql://localhost:3306/ormlite";
        ConnectionSource connectionSource =
                new JdbcConnectionSource(databaseUrl,"root","root",new MysqlDatabaseType());
        
        Dao<School,String> schoolDao =
                DaoManager.createDao(connectionSource, School.class);
           schoolDao.deleteById("8");
           
        
    }

public class AccountApp {
     public static void main(String[] args) throws Exception {

            String databaseUrl = "jdbc:mysql://localhost:3306/ormlite";
            ConnectionSource connectionSource =
                    new JdbcConnectionSource(databaseUrl,"root","root",new MysqlDatabaseType());
            Dao<Account,String> accountDao =
                    DaoManager.createDao(connectionSource, Account.class);
            
            querywithWhereSchool(accountDao);
            connectionSource.close();
        }
      
     public static void querywithWhereSchool(Dao<Account,String> accountDao) throws SQLException {

                Account s=new Account("10","ava");
                String id = accountDao.extractId(s);
                        
                System.out.println("account id  "+id);
                
            }
}

public static void rawquery() throws SQLException {
        String query = "select * from libraries where libraryId = 1";
        rawSqlQuery(query);
    }
    
    public static void rawSqlQuery(String query) throws SQLException {
        
         String databaseUrl = "jdbc:mysql://localhost:3306/ormlite";
         ConnectionSource connectionSource =
                 new JdbcConnectionSource(databaseUrl,"root","root",new H2DatabaseType());
   
         Dao<Libraries,String> accountDao =
                 DaoManager.createDao(connectionSource, Libraries.class);
         
        GenericRawResults<String[]> rawResults =
               accountDao.queryRaw(query);
             // there should be 1 result
             List<String[]> results = rawResults.getResults();
             // the results array should have 1 value
             String[] resultArray = results.get(0);
             // this should print the number of orders that have this account-id
             System.out.println("id " + resultArray[0] + " value " + resultArray[1]);
             
    }

public class UserApp {

    public static void main(String[] args) throws Exception {
        String databaseUrl = "jdbc:mysql://localhost:3306/ormlite";
        ConnectionSource connectionSource =
                new JdbcConnectionSource(databaseUrl,"root","root",new MysqlDatabaseType());
        Dao<User,String> userDao =
                DaoManager.createDao(connectionSource, User.class);

        queryUser(userDao);
        
        connectionSource.close();
    }

    public static void queryUser(Dao<User, String> schoolDao) throws SQLException {

        QueryBuilder<User, String> queryBuilder =
                schoolDao.queryBuilder();
        queryBuilder.selectColumns(User.name_FIELD_NAME);
        queryBuilder.groupBy(User.name_FIELD_NAME);
        queryBuilder.orderBy(User.name_FIELD_NAME,false);
        queryBuilder.limit(1L);
        List<User> accountList = queryBuilder.query();
    }