Examples of JdbcConnectionSource

com.j256.ormlite.jdbc.JdbcConnectionSource
Implementation of the ConnectionSource interface that supports what is needed by ORMLite. This is not thread-safe nor synchronized. For other dataSources, see the {@link DataSourceConnectionSource} class.
NOTE: If you are using the Spring type wiring in Java, {@link #initialize} should be called after all of theset methods. In Spring XML, init-method="initialize" should be used.
@author graywatson

Examples of com.j256.ormlite.jdbc.JdbcConnectionSource


  public boolean updateNote(Note note) {
    Dao<Note, Integer> notesDao;
    ConnectionSource connectionSource = null;
    try {
      connectionSource = new JdbcConnectionSource(connectionString, userName, userPass);
      notesDao = DaoManager.createDao(connectionSource, Note.class);
      notesDao.update(note);
      connectionSource.close();
    } catch (SQLException ex) {
      System.err.println("Exception: " + ex.getMessage());

View Full Code Here

Examples of com.j256.ormlite.jdbc.JdbcConnectionSource

  private User getUserByToken(String token) {
    Dao<User, Integer> usersDao;
    ConnectionSource connectionSource;
    User user = null;
    try {
      connectionSource = new JdbcConnectionSource(connectionString, userName, userPass);
      usersDao = DaoManager.createDao(connectionSource, User.class);
      QueryBuilder<User, Integer> queryBuilder = usersDao.queryBuilder();
      queryBuilder.where().like(User.TOKEN_FIELD_NAME, token);
      user = usersDao.queryForFirst(queryBuilder.prepare());
      connectionSource.close();

View Full Code Here

Examples of com.j256.ormlite.jdbc.JdbcConnectionSource

  private void generateAndSaveUserToken(User user) {
    if (user != null) {
      Dao<User, Integer> usersDao;
      ConnectionSource connectionSource;
      try {
        connectionSource = new JdbcConnectionSource(connectionString, userName, userPass);
        usersDao = DaoManager.createDao(connectionSource, User.class);
        String token = generateUserAuthToken();
        user.setToken(token);
        usersDao.update(user);
        saveUserAuthFile(token);

View Full Code Here

Examples of com.j256.ormlite.jdbc.JdbcConnectionSource

  User loginUser(String login, String password, boolean rememberUser) {
    Dao<User, Integer> usersDao;
    ConnectionSource connectionSource;
    User user = null;
    try {
      connectionSource = new JdbcConnectionSource(connectionString, userName, userPass);
      usersDao = DaoManager.createDao(connectionSource, User.class);
      QueryBuilder<User, Integer> queryBuilder = usersDao.queryBuilder();
      queryBuilder.where().like(User.LOGIN_FIELD_NAME, login).and().like(User.PASSWORD_FIELD_NAME, password);
      user = usersDao.queryForFirst(queryBuilder.prepare());
      connectionSource.close();

View Full Code Here

Examples of com.j256.ormlite.jdbc.JdbcConnectionSource

    User newUser = new User(login, fullName, password);
    Dao<User, Integer> usersDao;
    ConnectionSource connectionSource = null;
    User user = null;
    try {
      connectionSource = new JdbcConnectionSource(connectionString, userName, userPass);
      usersDao = DaoManager.createDao(connectionSource, User.class);
      QueryBuilder<User, Integer> queryBuilder = usersDao.queryBuilder();
      queryBuilder.where().like(User.LOGIN_FIELD_NAME, login).countOf();
      if (usersDao.countOf(queryBuilder.prepare()) > 0) {
        connectionSource.close();

View Full Code Here

Examples of com.j256.ormlite.jdbc.JdbcConnectionSource

  public void setIsbnkey(String isbnkey) {
    this.isbnkey = isbnkey;
  }


  public ConnectionSource GetConnection() throws SQLException {
    JdbcConnectionSource connectionSource = 
      new JdbcConnectionSource(DATABASE_URL);
    try {
      this.setupDatabase(connectionSource);
    } catch (Exception e) {
      // TODO Auto-generated catch block
      e.printStackTrace();

View Full Code Here

Examples of com.j256.ormlite.jdbc.JdbcConnectionSource

    createSchema.setActionListener(new ActionListener() {


      @Override
      public boolean onAction(Control source) {
        try {
          JdbcConnectionSource connectionSource = 
            (JdbcConnectionSource) GetConnection();
          CreateSchema(connectionSource);
          connectionSource.close();
          String msg = "ControlListenerPage#" + hashCode()
                   + " Base de Datos Creada.";
                   addModel("msg", msg);
          return true;
        } catch (SQLException e) {

View Full Code Here

Examples of com.j256.ormlite.jdbc.JdbcConnectionSource


  private void doMain(String[] args) throws Exception {
    ConnectionSource connectionSource = null;
    try {
      // create our data-source for the database
      connectionSource = new JdbcConnectionSource(DATABASE_URL);
      // setup our database and DAOs
      setupDatabase(connectionSource);
      // read and write some data
      readWriteData();
      // do a bunch of bulk operations

View Full Code Here

Examples of com.j256.ormlite.jdbc.JdbcConnectionSource

        File databaseFile = ChestShop.loadFile("users.db");
        String uri = ConnectionManager.getURI(databaseFile);
        ConnectionSource connection;


        try {
            connection = new JdbcConnectionSource(uri);
            accounts = DaoManager.createDao(connection, Account.class);


            TableUtils.createTableIfNotExists(connection, Account.class);


            Account adminAccount = new Account(Properties.ADMIN_SHOP_NAME, Bukkit.getOfflinePlayer(Properties.ADMIN_SHOP_NAME).getUniqueId());

View Full Code Here

Examples of com.j256.ormlite.jdbc.JdbcConnectionSource

public class MariaDbDatabaseTypeTest extends BaseJdbcDatabaseTypeTest {


  @Override
  protected void setDatabaseParams() throws SQLException {
    databaseUrl = "jdbc:mariadb:ormlite";
    connectionSource = new JdbcConnectionSource(DEFAULT_DATABASE_URL);
    databaseType = new MariaDbDatabaseType();
  }

View Full Code Here

0 1 2 3

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.