Java Code Examples for java.sql.SQLException#printStackTrace()

The following examples show how to use java.sql.SQLException#printStackTrace() . You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
Source File: MatchesAccess.java    From Math-Game with Apache License 2.0 6 votes vote down vote up
/**
 * @param matchID - The matchID of the requested game
 * @return The Game with the given matchID
 */
public Game getGame(int matchID) {
	try {
		ResultSet resultSet = statement.executeQuery("select * from sofiav_mathgame.matches where ID=" + matchID);
		
		resultSet.next();
		System.out.println("SCORING from db: " + resultSet.getString("Scoring"));
		ArrayList<String> playerNames = new ArrayList<String>();
		int numPlayers = resultSet.getInt("NumPlayers");
		for(int i=1; i<=numPlayers; i++)
			playerNames.add(resultSet.getString("Player"+i));
		
		return new Game(matchID, numPlayers, playerNames,
				resultSet.getString("Type"), resultSet.getString("Scoring"),
				resultSet.getString("Difficulty"), resultSet.getInt("Rounds"));
	} catch(SQLException e) {
		e.printStackTrace();
	}

	return new Game(); // Return a blank Game if none could be found
}
 
Example 2
Source File: BusyLegs.java    From gemfirexd-oss with Apache License 2.0 6 votes vote down vote up
@Override
public void map(Object key, ResultSet rs, Context context)
    throws IOException, InterruptedException {

  String origAirport;
  String destAirport;
  String combo;

  try {
      origAirport = rs.getString("ORIG_AIRPORT");
      destAirport = rs.getString("DEST_AIRPORT");
      combo = origAirport.compareTo(
          destAirport) < 0 ? origAirport + destAirport : destAirport + origAirport;
      reusableText.set(combo);
      context.write(reusableText, countOne);
  } catch (SQLException e) {
    e.printStackTrace();
  }
}
 
Example 3
Source File: DruidDataSourceConfig.java    From easyweb with Apache License 2.0 6 votes vote down vote up
@Bean(name = "mysqlDataSource")
@Primary
public DataSource dataSource() {
    DruidDataSource datasource = new DruidDataSource();
    datasource.setUrl(databaseConfig.getUrl());
    datasource.setDriverClassName(databaseConfig.getDriverClassName());
    datasource.setUsername(databaseConfig.getUsername());
    datasource.setPassword(databaseConfig.getPassword());
    datasource.setInitialSize(databaseConfig.getInitialSize());
    datasource.setMinIdle(databaseConfig.getMinIdle());
    datasource.setMaxWait(databaseConfig.getMaxWait());
    datasource.setMaxActive(databaseConfig.getMaxActive());
    datasource.setMinEvictableIdleTimeMillis(databaseConfig.getMinEvictableIdleTimeMillis());
    try {
        datasource.setFilters("stat,wall,log4j2");
    } catch (SQLException e) {
        e.printStackTrace();
    }
    return datasource;
}
 
Example 4
Source File: Offset.java    From SightRemote with GNU General Public License v3.0 6 votes vote down vote up
public static void setOffset(DatabaseHelper helper, String pump, HistoryType historyType, long offset) {
    try {
        List<Offset> result = helper.getOffsetDao().queryBuilder()
                .where().eq("historyType", historyType)
                .and().eq("pump", pump).query();
        if (result.size() > 0) {
            Offset updateOffset = result.get(0);
            updateOffset.setOffset(offset);
            helper.getOffsetDao().update(updateOffset);
        } else {
            Offset createOffset = new Offset();
            createOffset.setOffset(offset);
            createOffset.setPump(pump);
            createOffset.setHistoryType(historyType);
            helper.getOffsetDao().create(createOffset);
        }
    } catch (SQLException e) {
        e.printStackTrace();
    }
}
 
Example 5
Source File: StudentDao.java    From sms with MIT License 6 votes vote down vote up
/**
 * @Title: setStudentPhoto
 * @Description: �����û�ͷ��
 * @param: studentInfo
 * @return: boolean
 */
public boolean setStudentPhoto(StudentInfo studentInfo) {

	Connection connection = DbUtil.getConnection();
	String sql = "update user_student set photo = ? where id = ?";

	try (PreparedStatement prepareStatement = connection.prepareStatement(sql)) {
		prepareStatement.setBinaryStream(1, studentInfo.getPhoto());
		prepareStatement.setInt(2, studentInfo.getId());
		return prepareStatement.executeUpdate() > 0;
	} catch (SQLException e) {
		e.printStackTrace();
	}

	return update(sql);
}
 
Example 6
Source File: SqlMap.java    From jelectrum with MIT License 6 votes vote down vote up
public boolean containsKey(Object key)
{
  while(true)
  {
    try
    {
      return tryContainsKey(key);
    }
    catch(SQLException e)
    {
      e.printStackTrace();
      try{Thread.sleep(1000);}catch(Exception e2){}
    }

  }

}
 
Example 7
Source File: PropertyImport.java    From development with Apache License 2.0 6 votes vote down vote up
protected void createEntries(Connection conn,
        Map<String, String> toCreate) {

    try {
        String query = "INSERT INTO " + TABLE_NAME + "(" + FIELD_VALUE
                + ", " + FIELD_KEY + ", " + FIELD_CONTROLLER
                + ") VALUES(?, ?, ?)";
        PreparedStatement stmt = conn.prepareStatement(query);

        for (String key : toCreate.keySet()) {

            String value = toCreate.get(key);
            stmt.setString(1, value);
            stmt.setString(2, key);
            stmt.setString(3, controllerId);

            stmt.executeUpdate();
            System.out.println("Create Configuration " + key
                    + " with value '" + value + "'");
        }
    } catch (SQLException e) {
        e.printStackTrace();
        throw new RuntimeException(ERR_DB_CREATE_SETTINGS);
    }
}
 
Example 8
Source File: DatabaseHelper.java    From SightRemote with GNU General Public License v3.0 6 votes vote down vote up
public Dao<CannulaFilled, Integer> getCannulaFilledDao() {
    try {
        if (cannulaFilledDao == null) cannulaFilledDao = getDao(CannulaFilled.class);
    } catch (SQLException e) {
        e.printStackTrace();
    }
    return cannulaFilledDao;
}
 
Example 9
Source File: News_contentDaoImpl.java    From xmpp with Apache License 2.0 6 votes vote down vote up
public String getcontent(String cid) {
	conn = this.getConnection();
	String content = "";
	try {

		pstmt = conn
				.prepareStatement("select * from news_content where cid='"
						+ cid + "'");
		rs = pstmt.executeQuery();
		while (rs.next()) {

			content = rs.getString("ccontent");

		}

	} catch (SQLException e) {

		e.printStackTrace();
	} finally {
		this.closeAll(rs, pstmt, conn);

	}
	return content;

}
 
Example 10
Source File: DbStoreCopyPast.java    From code_quality_principles with Apache License 2.0 6 votes vote down vote up
@Override
public User add(User user) {
    try (Connection connection = this.source.getConnection();
         final PreparedStatement statement = connection
                 .prepareStatement("insert into users (login) values (?)",
                         Statement.RETURN_GENERATED_KEYS)) {
        statement.setString(1, user.getLogin());
        statement.executeUpdate();
        try (ResultSet generatedKeys = statement.getGeneratedKeys()) {
            if (generatedKeys.next()) {
                user.setId(generatedKeys.getInt(1));
                return user;
            }
        }
    } catch (SQLException e) {
        e.printStackTrace();
    }
    throw new IllegalStateException("Could not create new user");
}
 
Example 11
Source File: SimpleExample.java    From tp_java_2015_02 with MIT License 5 votes vote down vote up
public static void connect(){
	Connection connection = getConnection();
	System.out.append("Connected!\n");
	try {
		System.out.append("Autocommit: " + connection.getAutoCommit() + '\n');
		System.out.append("DB name: " + connection.getMetaData().getDatabaseProductName() + '\n');
		System.out.append("DB version: " + connection.getMetaData().getDatabaseProductVersion() + '\n');
		System.out.append("Driver: " + connection.getMetaData().getDriverName() + '\n');
		connection.close();
	} catch (SQLException e) {
		e.printStackTrace();
	}	
	 
}
 
Example 12
Source File: ClientDatabase.java    From supbot with MIT License 5 votes vote down vote up
public static void updateRole(Client client){

        try(Connection conn = connect();
            PreparedStatement pstm = conn.prepareStatement(clientRoleUpdate)){

            pstm.setInt(1, client.getRole().getPrestige());
            pstm.setString(2, client.getName());
            pstm.setString(3, client.getGroupId());
            pstm.executeUpdate();

        } catch (SQLException e) {
            e.printStackTrace();
        }

    }
 
Example 13
Source File: AddressProvider.java    From bither-desktop-java with Apache License 2.0 5 votes vote down vote up
@Override
public Map<String, String> getAliases() {
    Map<String, String> stringMap = new HashMap<String, String>();
    try {
        PreparedStatement statement = this.mDb.getPreparedStatement("select * from aliases", null);
        ResultSet c = statement.executeQuery();
        while (c.next()) {
            int idColumn = c.findColumn(AbstractDb.AliasColumns.ADDRESS);
            String address = null;
            String alias = null;
            if (idColumn > -1) {
                address = c.getString(idColumn);
            }
            idColumn = c.findColumn(AbstractDb.AliasColumns.ALIAS);
            if (idColumn > -1) {
                alias = c.getString(idColumn);
            }
            stringMap.put(address, alias);

        }
        c.close();
        statement.close();
    } catch (SQLException e) {
        e.printStackTrace();
    }
    return stringMap;
}
 
Example 14
Source File: RDB.java    From tuffylite with Apache License 2.0 5 votes vote down vote up
public boolean schemaExists(String name){

		ResultSet rs = this.query("SELECT * FROM information_schema.schemata WHERE schema_name = '" + name.toLowerCase() + "'");
		try {
			if(rs.next()){
				return true;
			}else{
				return false;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return false;
	}
 
Example 15
Source File: HelperProfileRepository.java    From helper with MIT License 5 votes vote down vote up
private void saveProfile(ImmutableProfile profile) {
    try (Connection c = this.sql.getConnection()) {
        try (PreparedStatement ps = c.prepareStatement(replaceTableName(INSERT))) {
            ps.setString(1, UndashedUuids.toString(profile.getUniqueId()));
            ps.setString(2, profile.getName().get());
            ps.setTimestamp(3, new Timestamp(profile.getTimestamp()));
            ps.setString(4, profile.getName().get());
            ps.setTimestamp(5, new Timestamp(profile.getTimestamp()));
            ps.execute();
        }
    } catch (SQLException e) {
        e.printStackTrace();
    }
}
 
Example 16
Source File: DbUtil.java    From Java-11-Cookbook-Second-Edition with MIT License 5 votes vote down vote up
public static void recordData(Connection conn, TrafficUnit tu, double speed) {
        String sql = "insert into data(vehicle_type, horse_power, weight_pounds, passengers_count, payload_pounds, speed_limit_mph, " +
                "temperature, road_condition, tire_condition, traction, speed) values(?,?,?,?,?,?,?,?,?,?,?)";
/*
        System.out.println("  " + sql + ", params=" + tu.getVehicleType() + ", " + tu.getHorsePower() + ", " + tu.getWeightPounds()
                + ", " + tu.getPassengersCount() + ", " + tu.getPayloadPounds() + ", " + tu.getSpeedLimitMph() + ", " + tu.getTemperature()
                + ", " + tu.getRoadCondition() + ", " + tu.getTireCondition()+ ", " + tu.getTraction() + ", " + speed);
*/
        try {
            int i = 1;
            PreparedStatement st = conn.prepareStatement(sql);
            st.setString(i++, tu.getVehicleType().name());
            st.setInt(i++, tu.getHorsePower());
            st.setInt(i++, tu.getWeightPounds());
            st.setInt(i++, tu.getPassengersCount());
            st.setInt(i++, tu.getPayloadPounds());
            st.setDouble(i++, tu.getSpeedLimitMph());
            st.setInt(i++, tu.getTemperature());
            st.setString(i++, tu.getRoadCondition().name());
            st.setString(i++, tu.getTireCondition().name());
            st.setDouble(i++, tu.getTraction());
            st.setDouble(i++, speed);
            int count = st.executeUpdate();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }
 
Example 17
Source File: NoteManager.java    From ETSMobile-Android2 with Apache License 2.0 5 votes vote down vote up
/**
 * Deletes courses in DB that doesn't exist on API
 *
 * @param
 */
public void deleteExpiredCours(ListeDeCours listeDeCours) {
    DatabaseHelper dbHelper = new DatabaseHelper(context);

    HashMap<String, Cours> coursHashMap = new HashMap<String, Cours>();
    for (Cours cours : listeDeCours.liste) {
        cours.id = cours.sigle + cours.session;
        coursHashMap.put(cours.id, cours);
    }

    ArrayList<Cours> dbCours = new ArrayList<Cours>();
    try {
        dbCours = (ArrayList<Cours>) dbHelper.getDao(Cours.class).queryForAll();
        ArrayList<ListeDesElementsEvaluation> dbliste = (ArrayList<ListeDesElementsEvaluation>) dbHelper.getDao(ListeDesElementsEvaluation.class).queryForAll();
        for (Cours coursNew : dbCours) {

            if (!coursHashMap.containsKey(coursNew.id)) {
                Dao<Cours, String> coursDao = dbHelper.getDao(Cours.class);
                coursDao.deleteById(coursNew.id);

                deleteExpiredListeDesElementsEvaluation(coursNew.id);
            }
        }

    } catch (SQLException e) {
        e.printStackTrace();
    }
}
 
Example 18
Source File: AlbumBiz.java    From android-project-wo2b with Apache License 2.0 5 votes vote down vote up
/**
 * 根据模块返回搜索结果, 具有分组性质.
 * 
 * @param module
 * @return
 */
public List<AlbumInfo> queryAllCategory(Module module)
{
	List<AlbumInfo> albumInfoList = null;
	try
	{
		QueryBuilder<AlbumInfo, Long> queryBuilder = mAlbumDao.queryBuilder();
		queryBuilder.groupBy("category");
		queryBuilder.orderBy("orderby", true);
		albumInfoList = queryBuilder.where().eq("module", module.value).query();
	}
	catch (SQLException e)
	{
		e.printStackTrace();
	}
	
	if (encrypt_mode)
	{
		if (albumInfoList == null || albumInfoList.isEmpty())
		{
			return null;
		}

		int size = albumInfoList.size();
		for (int i = 0; i < size; i++)
		{
			albumInfoList.get(i).setCoverurl(SecurityTu123.decodeImageUrl(albumInfoList.get(i).getCoverurl()));
		}
	}
	
	return albumInfoList;
}
 
Example 19
Source File: SellerDaoImpl.java    From OnlineShoppingSystem with MIT License 4 votes vote down vote up
public ArrayList<Order> getUnfinishedOrder(int shopId, int page) {
    ArrayList<Order> orders = new ArrayList<Order>();

    try {
        String sql = "select * from goods_order where shop_id = ? "
                + "and order_status='待发货' "
                + "group by order_time DESC "
                + "limit ?,10;";

        connection = DBUtil.getConnection();
        preparedStatement = connection.prepareStatement(sql);

        preparedStatement.setInt(1, shopId);
        preparedStatement.setInt(2, (page - 1) * 10);
        resultSet = preparedStatement.executeQuery();

        while (resultSet.next()) {
            Order od = new Order();

            od.setOrderId(resultSet.getLong("order_id"));
            od.setShopId(resultSet.getInt("shop_id"));
            od.setUserId(resultSet.getInt("user_id"));
            od.setOrderTime(resultSet.getTimestamp("order_time"));
            od.setAnnotation(resultSet.getString("annotation"));
            od.setTotal(resultSet.getInt("total"));

            // int receiverId = resultSet.getInt("receiver_id");
            // Receiver receiver = new Receiver();
            // String sql1 = "select * from receiver where receiver_id =
            // ?;";
            // PreparedStatement ps = connection.prepareStatement(sql1);
            // ps.setInt(1, receiverId);
            // ResultSet rs = ps.executeQuery();
            // if (rs.next()) {
            // receiver.setUserId(rs.getInt("user_id"));
            // receiver.setReceiverId(rs.getInt("receiver_id"));
            // receiver.setAddress(rs.getString("address"));
            // receiver.setName(rs.getString("name"));
            // receiver.setPhone(rs.getString("phone"));
            // }
            // od.setReceiver(receiver);// 获得收货人

            // od.setGoodsInOrder(getGoodsInOrder(resultSet.getLong("order_id")));

            orders.add(od);
        }
    } catch (SQLException e) {
        e.printStackTrace();
    } finally {
        closeAll();
    }
    return orders;
}
 
Example 20
Source File: DataStorage.java    From SkyWarsReloaded with GNU General Public License v3.0 4 votes vote down vote up
public void saveStats(final PlayerStat pData) {
boolean sqlEnabled = SkyWarsReloaded.get().getConfig().getBoolean("sqldatabase.enabled");
if (!sqlEnabled) {
	try {
           File dataDirectory = SkyWarsReloaded.get().getDataFolder();
           File playerDataDirectory = new File(dataDirectory, "player_data");

           if (!playerDataDirectory.exists() && !playerDataDirectory.mkdirs()) {
           	return;
           }

           File playerFile = new File(playerDataDirectory, pData.getId() + ".yml");
           if (!playerFile.exists()) {
           	SkyWarsReloaded.get().getLogger().info("File doesn't exist!");
           	return;
           }

           copyDefaults(playerFile);
           FileConfiguration fc = YamlConfiguration.loadConfiguration(playerFile);
           fc.set("uuid", pData.getId());
           fc.set("wins", pData.getWins());
           fc.set("losses", pData.getLosses());
           fc.set("kills", pData.getKills());
           fc.set("deaths", pData.getDeaths());
           fc.set("elo", pData.getElo());
           fc.set("xp", pData.getXp());
           fc.set("pareffect", pData.getParticleEffect());
           fc.set("proeffect", pData.getProjectileEffect());
           fc.set("glasscolor", pData.getGlassColor());
           fc.set("killsound", pData.getKillSound());
           fc.set("winsound", pData.getWinSound());
           fc.set("taunt", pData.getTaunt());
           fc.save(playerFile);
           
       } catch (IOException ioException) {
           System.out.println("Failed to load faction " + pData.getId() + ": " + ioException.getMessage());
       }
} else {
          Database database = SkyWarsReloaded.getDb();

          if (database.checkConnection()) {
              return;
          }

          Connection connection = database.getConnection();
          PreparedStatement preparedStatement = null;

          try {
          	 String query = "UPDATE `sw_player` SET `player_name` = ?, `wins` = ?, `losses` = ?, `kills` = ?, `deaths` = ?, `elo` = ?, `xp` = ?, `pareffect` = ?, " +
				 "`proeffect` = ?, `glasscolor` = ?,`killsound` = ?, `winsound` = ?, `taunt` = ? WHERE `uuid` = ?;";
               
               preparedStatement = connection.prepareStatement(query);
               preparedStatement.setString(1, pData.getPlayerName());
               preparedStatement.setInt(2, pData.getWins());
               preparedStatement.setInt(3, pData.getLosses());
               preparedStatement.setInt(4, pData.getKills());
               preparedStatement.setInt(5, pData.getDeaths());
               preparedStatement.setInt(6, pData.getElo());
               preparedStatement.setInt(7, pData.getXp());
               preparedStatement.setString(8, pData.getParticleEffect());
               preparedStatement.setString(9, pData.getProjectileEffect());
               preparedStatement.setString(10, pData.getGlassColor());
               preparedStatement.setString(11, pData.getKillSound());
               preparedStatement.setString(12, pData.getWinSound());
               preparedStatement.setString(13, pData.getTaunt());
               preparedStatement.setString(14, pData.getId());
               preparedStatement.executeUpdate();

          } catch (final SQLException sqlException) {
              sqlException.printStackTrace();

          } finally {
              if (preparedStatement != null) {
                  try {
                      preparedStatement.close();
                  } catch (final SQLException ignored) {
                  }
              }
          }
}
  }