API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 19th, 2017
143
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 23.04 KB | None | 0 0
raw download clone embed print report
  1. package com.rs.database.mysql.impl;
  2.  
  3. import java.sql.Connection;
  4. import java.sql.DriverManager;
  5. import java.sql.ResultSet;
  6. import java.sql.SQLException;
  7. import java.sql.Statement;
  8.  
  9. import com.rs.Settings;
  10. import com.rs.game.World;
  11. import com.rs.game.player.Player;
  12.  
  13. /**
  14. * Using this class:
  15. * To call this class, it's best to make a new thread. You can do it below like so:
  16. * new Thread(new Donation(player)).start();
  17. */
  18. public class Donation implements Runnable {
  19.  
  20. public static final String HOST = "-"; // website ip address
  21. public static final String USER = "-";
  22. public static final String PASS = "-";
  23. public static final String DATABASE = "-";
  24.  
  25. private Player player;
  26. private Connection conn;
  27. private Statement stmt;
  28.  
  29. /**
  30. * The constructor
  31. * @param player
  32. */
  33. public Donation(Player player) {
  34. this.player = player;
  35. }
  36.  
  37. @Override
  38. public void run() {
  39. try {
  40. if (!connect(HOST, DATABASE, USER, PASS)) {
  41. return;
  42. }
  43.  
  44. String name = player.getUsername().replace("_", " ");
  45. ResultSet rs = executeQuery("SELECT * FROM payments WHERE player_name='"+name+"' AND status='Completed' AND claimed=0");
  46.  
  47. while (rs.next()) {
  48. int item_number = rs.getInt("item_number");
  49. double paid = rs.getDouble("amount");
  50. int quantity = rs.getInt("quantity");
  51.  
  52. switch (item_number) {// add products according to their ID in the ACP
  53.  
  54. case 19: // example
  55. World.sendWorldMessage(
  56. "" + player.getDisplayName() + "<col=00FF00> has donated for Donator status!", false);
  57. player.sendMessage("Thank you for your support!");
  58. player.donationvalue += 10;
  59. Settings.amountdonated += 10;
  60. player.donator = true;
  61. break;
  62. case 20:
  63. World.sendWorldMessage(
  64. "" + player.getDisplayName() + "<col=00FF00> has donated for the *Gambler Host* rank!",
  65. false);
  66. player.sendMessage("Thank you for your support!");
  67. player.gamblehost = true;
  68. player.donationvalue += 20;
  69. Settings.amountdonated += 20;
  70. break;
  71. case 21:
  72. World.sendWorldMessage(
  73. "" + player.getDisplayName() + "<col=00FF00> has donated for a Donator box!", false);
  74. player.sendMessage("Thank you for your support!");
  75. player.getBank().addItem(29870, 1, true);
  76. player.donationvalue += 9;
  77. Settings.amountdonated += 9;
  78. break;
  79. case 22:
  80. World.sendWorldMessage(
  81. "" + player.getDisplayName() + "<col=00FF00> has donated for a Christmas cracker!",
  82. false);
  83. player.sendMessage("Thank you for your support!");
  84. player.getBank().addItem(962, 1, true);
  85. player.donationvalue += 30;
  86. Settings.amountdonated += 30;
  87. break;
  88. case 23:
  89. World.sendWorldMessage(
  90. "" + player.getDisplayName() + "<col=00FF00> has donated for a Santa hat!", false);
  91. player.sendMessage("Thank you for your support!");
  92. player.getBank().addItem(1050, 1, true);
  93. player.donationvalue += 20;
  94. Settings.amountdonated += 20;
  95. break;
  96. case 24:
  97. World.sendWorldMessage(
  98. "" + player.getDisplayName() + "<col=00FF00> has donated for a set of Donator boots!",
  99. false);
  100. player.sendMessage("Thank you for your support!");
  101. player.getBank().addItem(29788, 1, true);
  102. player.donationvalue += 15;
  103. Settings.amountdonated += 15;
  104. break;
  105. case 25:
  106. World.sendWorldMessage(
  107. "" + player.getDisplayName() + "<col=00FF00> has donated for a Donators ring!", false);
  108. player.sendMessage("Thank you for your support!");
  109. player.getBank().addItem(20054, 1, true);
  110. player.donationvalue += 15;
  111. Settings.amountdonated += 15;
  112. break;
  113. case 27:
  114. World.sendWorldMessage(
  115. "" + player.getDisplayName() + "<col=00FF00> has donated for a pair of Donator gloves!",
  116. false);
  117. player.sendMessage("Thank you for your support!");
  118. player.getBank().addItem(29925, 1, true);
  119. player.donationvalue += 15;
  120. Settings.amountdonated += 15;
  121. break;
  122. case 28:
  123. World.sendWorldMessage(
  124. "" + player.getDisplayName() + "<col=00FF00> has donated for a Donator cape!", false);
  125. player.sendMessage("Thank you for your support!");
  126. player.getBank().addItem(29717, 1, true);
  127. player.donationvalue += 15;
  128. Settings.amountdonated += 15;
  129. break;
  130. case 29:
  131. World.sendWorldMessage(
  132. "" + player.getDisplayName()
  133. + "<col=00FF00> has donated for a set of Silverhawk boots and 150 Feathers!",
  134. false);
  135. player.sendMessage("Thank you for your support!");
  136. player.getBank().addItem(29922, 1, true);
  137. player.getBank().addItem(10176, 150, true);
  138. player.donationvalue += 15;
  139. Settings.amountdonated += 15;
  140. break;
  141. case 30:
  142. World.sendWorldMessage("" + player.getDisplayName()
  143. + "<col=00FF00> has donated for a Dwarf cannon and 1000 balls!", false);
  144. player.sendMessage("Thank you for your support!");
  145. player.getBank().addItem(2, 100, true);
  146. player.getBank().addItem(6, 1, true);
  147. player.getBank().addItem(8, 1, true);
  148. player.getBank().addItem(10, 1, true);
  149. player.getBank().addItem(12, 1, true);
  150. player.donationvalue += 25;
  151. Settings.amountdonated += 25;
  152. break;
  153. case 31:
  154. World.sendWorldMessage(
  155. "" + player.getDisplayName() + "<col=00FF00> has donated for a Deathtouch dart!",
  156. false);
  157. player.sendMessage("Thank you for your support!");
  158. player.getBank().addItem(25202, 1, true);
  159. player.donationvalue += 2;
  160. Settings.amountdonated += 2;
  161. break;
  162. case 32:
  163. World.sendWorldMessage(
  164. "" + player.getDisplayName() + "<col=00FF00> has donated for 10 Deathtouch darts!",
  165. false);
  166. player.sendMessage("Thank you for your support!");
  167. player.getBank().addItem(25202, 10, true);
  168. player.donationvalue += 18;
  169. Settings.amountdonated += 18;
  170. break;
  171. case 33:
  172. World.sendWorldMessage(
  173. "" + player.getDisplayName() + "<col=00FF00> has donated for a Super Donator Box!",
  174. false);
  175. player.sendMessage("Thank you for your support!");
  176. player.getBank().addItem(29580, 1, true);
  177. player.donationvalue += 13;
  178. Settings.amountdonated += 13;
  179. break;
  180. case 34:
  181. World.sendWorldMessage(
  182. "" + player.getDisplayName() + "<col=00FF00> has donated for a Third-age melee set!",
  183. false);
  184. player.sendMessage("Thank you for your support!");
  185. player.getBank().addItem(10346, 1, true);
  186. player.getBank().addItem(10348, 1, true);
  187. player.getBank().addItem(10350, 1, true);
  188. player.getBank().addItem(10352, 1, true);
  189. player.donationvalue += 25;
  190. Settings.amountdonated += 25;
  191. break;
  192. case 35:
  193. World.sendWorldMessage(
  194. "" + player.getDisplayName() + "<col=00FF00> has donated for a Third-age magic set!",
  195. false);
  196. player.sendMessage("Thank you for your support!");
  197. player.getBank().addItem(10338, 1, true);
  198. player.getBank().addItem(10340, 1, true);
  199. player.getBank().addItem(10342, 1, true);
  200. player.getBank().addItem(10344, 1, true);
  201. player.donationvalue += 25;
  202. Settings.amountdonated += 25;
  203. break;
  204. case 36:
  205. World.sendWorldMessage(
  206. "" + player.getDisplayName() + "<col=00FF00> has donated for a Third-age range set!",
  207. false);
  208. player.sendMessage("Thank you for your support!");
  209. player.getBank().addItem(10330, 1, true);
  210. player.getBank().addItem(10332, 1, true);
  211. player.getBank().addItem(10334, 1, true);
  212. player.getBank().addItem(10336, 1, true);
  213. player.donationvalue += 25;
  214. Settings.amountdonated += 25;
  215. break;
  216. case 37:
  217. World.sendWorldMessage(
  218. "" + player.getDisplayName() + "<col=00FF00> has donated for an Amulet of Perfection!",
  219. false);
  220. player.sendMessage("Thank you for your support!");
  221. player.getBank().addItem(29732, 1, true);
  222. player.donationvalue += 25;
  223. Settings.amountdonated += 25;
  224. break;
  225. case 38:
  226. World.sendWorldMessage(
  227. "" + player.getDisplayName() + "<col=00FF00> has donated for a Keepsake Key!", false);
  228. player.sendMessage("Thank you for your support!");
  229. player.getBank().addItem(29544, 1, true);
  230. player.donationvalue += 2;
  231. Settings.amountdonated += 2;
  232. break;
  233. case 39:
  234. World.sendWorldMessage("" + player.getDisplayName() + "<col=00FF00> has donated for 100 Spins!",
  235. false);
  236. player.sendMessage("Thank you for your support!");
  237. player.spins += 100;
  238. player.donationvalue += 18;
  239. Settings.amountdonated += 18;
  240. break;
  241. case 40:
  242. World.sendWorldMessage("" + player.getDisplayName() + "<col=00FF00> has donated for 25 Spins!",
  243. false);
  244. player.sendMessage("Thank you for your support!");
  245. player.spins += 25;
  246. player.donationvalue += 6;
  247. Settings.amountdonated += 6;
  248. break;
  249. case 41:
  250. World.sendWorldMessage("" + player.getDisplayName()
  251. + "<col=00FF00> has donated for a Display name change ticket!", false);
  252. player.sendMessage("Thank you for your support!");
  253. player.getBank().addItem(29552, 1, true);
  254. player.donationvalue += 5;
  255. Settings.amountdonated += 5;
  256. break;
  257. case 42:
  258. World.sendWorldMessage(
  259. "" + player.getDisplayName() + "<col=00FF00> has donated for a Cow pet!",
  260. false);
  261. player.sendMessage("Thank you for your support!");
  262. player.getBank().addItem(29851, 1, true);
  263. player.donationvalue += 2;
  264. Settings.amountdonated += 2;
  265. break;
  266. case 43:
  267. World.sendWorldMessage(
  268. "" + player.getDisplayName() + "<col=00FF00> has donated for a WeeWyrm!",
  269. false);
  270. player.sendMessage("Thank you for your support!");
  271. player.getBank().addItem(29863, 1, true);
  272. player.donationvalue += 4;
  273. Settings.amountdonated += 3;
  274. break;
  275. case 44:
  276. World.sendWorldMessage(
  277. "" + player.getDisplayName() + "<col=00FF00> has donated for Jadex!",
  278. false);
  279. player.sendMessage("Thank you for your support!");
  280. player.getBank().addItem(29861, 1, true);
  281. player.donationvalue += 4;
  282. Settings.amountdonated += 4;
  283. break;
  284. case 45:
  285. World.sendWorldMessage(
  286. "" + player.getDisplayName() + "<col=00FF00> has donated for the Colosseum override!",
  287. false);
  288. player.sendMessage("Thank you for your support!");
  289. player.colosseumc = true;
  290. player.donationvalue += 4;
  291. Settings.amountdonated += 4;
  292. break;
  293. case 46:
  294. World.sendWorldMessage(
  295. "" + player.getDisplayName() + "<col=00FF00> has donated for the Caberet override!",
  296. false);
  297. player.sendMessage("Thank you for your support!");
  298. player.cabaretc = true;
  299. player.donationvalue += 6;
  300. Settings.amountdonated += 6;
  301. break;
  302. case 47:
  303. World.sendWorldMessage(
  304. "" + player.getDisplayName() + "<col=00FF00> has donated for the Monarch override!",
  305. false);
  306. player.sendMessage("Thank you for your support!");
  307. player.monarchc = true;
  308. player.donationvalue += 5;
  309. Settings.amountdonated += 5;
  310. break;
  311. case 48:
  312. World.sendWorldMessage(
  313. "" + player.getDisplayName() + "<col=00FF00> has donated for the Feline override!",
  314. false);
  315. player.sendMessage("Thank you for your support!");
  316. player.felinec = true;
  317. player.donationvalue += 3;
  318. Settings.amountdonated += 3;
  319. break;
  320. case 49:
  321. World.sendWorldMessage("" + player.getDisplayName()
  322. + "<col=00FF00> has donated for the Swashbuckler override!", false);
  323. player.sendMessage("Thank you for your support!");
  324. player.swashbucklerc = true;
  325. player.donationvalue += 4;
  326. Settings.amountdonated += 4;
  327. break;
  328. case 50:
  329. World.sendWorldMessage(
  330. "" + player.getDisplayName() + "<col=00FF00> has donated for the Assassin override!",
  331. false);
  332. player.sendMessage("Thank you for your support!");
  333. player.assassinc = true;
  334. player.donationvalue += 8;
  335. Settings.amountdonated += 8;
  336. break;
  337. case 51:
  338. World.sendWorldMessage(
  339. "" + player.getDisplayName() + "<col=00FF00> has donated for the Beachwear override!",
  340. false);
  341. player.sendMessage("Thank you for your support!");
  342. player.beachwearc = true;
  343. player.donationvalue += 6;
  344. Settings.amountdonated += 6;
  345. break;
  346. case 52:
  347. World.sendWorldMessage(
  348. "" + player.getDisplayName() + "<col=00FF00> has donated for the Noble override!",
  349. false);
  350. player.sendMessage("Thank you for your support!");
  351. player.noblec = true;
  352. player.donationvalue += 4;
  353. Settings.amountdonated += 4;
  354. break;
  355. case 53:
  356. World.sendWorldMessage(
  357. "" + player.getDisplayName() + "<col=00FF00> has donated for the Fox override!", false);
  358. player.sendMessage("Thank you for your support!");
  359. player.foxc = true;
  360. player.donationvalue += 3;
  361. Settings.amountdonated += 3;
  362. break;
  363. case 54:
  364. World.sendWorldMessage(
  365. "" + player.getDisplayName() + "<col=00FF00> has donated for the Wolf override!",
  366. false);
  367. player.sendMessage("Thank you for your support!");
  368. player.wolfc = true;
  369. player.donationvalue += 3;
  370. Settings.amountdonated += 3;
  371. break;
  372. case 55:
  373. World.sendWorldMessage("" + player.getDisplayName()
  374. + "<col=00FF00> has donated for the Dwarven warsuit override!", false);
  375. player.sendMessage("Thank you for your support!");
  376. player.dwarvenwarsuitc = true;
  377. player.donationvalue += 10;
  378. Settings.amountdonated += 10;
  379. break;
  380. case 56:
  381. World.sendWorldMessage("" + player.getDisplayName()
  382. + "<col=00FF00> has donated for the Tropical islander override!", false);
  383. player.sendMessage("Thank you for your support!");
  384. player.tropicalislanderc = true;
  385. player.donationvalue += 5;
  386. Settings.amountdonated += 5;
  387. break;
  388. case 57:
  389. World.sendWorldMessage(
  390. "" + player.getDisplayName() + "<col=00FF00> has donated for the Gothic override!",
  391. false);
  392. player.sendMessage("Thank you for your support!");
  393. player.gothicc = true;
  394. player.donationvalue += 4;
  395. Settings.amountdonated += 4;
  396. break;
  397. case 58:
  398. World.sendWorldMessage("" + player.getDisplayName()
  399. + "<col=00FF00> has donated for the Royal court set override!", false);
  400. player.sendMessage("Thank you for your support!");
  401. player.royalcourtc = true;
  402. player.donationvalue += 6;
  403. Settings.amountdonated += 6;
  404. break;
  405. case 59:
  406. World.sendWorldMessage("" + player.getDisplayName()
  407. + "<col=00FF00> has donated for the Scorching axe override!", false);
  408. player.sendMessage("Thank you for your support!");
  409. player.scorchingpackc = true;
  410. player.donationvalue += 2;
  411. Settings.amountdonated += 2;
  412. break;
  413. case 60:
  414. World.sendWorldMessage(
  415. "" + player.getDisplayName() + "<col=00FF00> has donated for the Whip pack override!",
  416. false);
  417. player.sendMessage("Thank you for your support!");
  418. player.whippackc = true;
  419. player.donationvalue += 5;
  420. Settings.amountdonated += 5;
  421. break;
  422. case 61:
  423. World.sendWorldMessage("" + player.getDisplayName()
  424. + "<col=00FF00> has donated for the Solarius shield override!", false);
  425. player.sendMessage("Thank you for your support!");
  426. player.solariusc = true;
  427. player.donationvalue += 2;
  428. Settings.amountdonated += 2;
  429. break;
  430. case 62:
  431. World.sendWorldMessage(
  432. "" + player.getDisplayName() + "<col=00FF00> has donated for the Bunny mask override!",
  433. false);
  434. player.sendMessage("Thank you for your support!");
  435. player.bunnymaskc = true;
  436. player.donationvalue += 7;
  437. Settings.amountdonated +=7;
  438. break;
  439. case 63:
  440. World.sendWorldMessage("" + player.getDisplayName() + "<col=00FF00> has donated for Double xp!",
  441. false);
  442. player.sendMessage("Thank you for your support!");
  443. player.ddxp = true;
  444. player.donationvalue += 25;
  445. Settings.amountdonated += 25;
  446. break;
  447. case 64:
  448. World.sendWorldMessage(
  449. "" + player.getDisplayName() + "<col=00FF00> has donated for the Hidden Ava perk!",
  450. false);
  451. player.sendMessage("Thank you for your support!");
  452. player.avaperk = true;
  453. player.donationvalue += 4;
  454. Settings.amountdonated += 4;
  455. break;
  456. case 65:
  457. World.sendWorldMessage(
  458. "" + player.getDisplayName() + "<col=00FF00> has donated for the Crystal luck perk!",
  459. false);
  460. player.sendMessage("Thank you for your support!");
  461. player.ckeyperk = true;
  462. player.donationvalue += 4;
  463. Settings.amountdonated += 4;
  464. break;
  465. case 66:
  466. World.sendWorldMessage(
  467. "" + player.getDisplayName() + "<col=00FF00> has donated for the Free entry perk!",
  468. false);
  469. player.sendMessage("Thank you for your support!");
  470. player.gwdperk = true;
  471. player.donationvalue += 5;
  472. Settings.amountdonated += 5;
  473. break;
  474. case 67:
  475. World.sendWorldMessage("" + player.getDisplayName()
  476. + "<col=00FF00> has donated for the Master of Dungeons perk!", false);
  477. player.sendMessage("Thank you for your support!");
  478. player.dungperk = true;
  479. player.donationvalue += 3;
  480. Settings.amountdonated += 3;
  481. break;
  482. case 69:
  483. World.sendWorldMessage(
  484. "" + player.getDisplayName() + "<col=00FF00> has donated for the Pet hunter perk!",
  485. false);
  486. player.sendMessage("Thank you for your support!");
  487. player.petperk = true;
  488. player.donationvalue += 5;
  489. Settings.amountdonated += 5;
  490. break;
  491. case 70:
  492. World.sendWorldMessage(
  493. "" + player.getDisplayName() + "<col=00FF00> has donated for the Green fingers perk!",
  494. false);
  495. player.sendMessage("Thank you for your support!");
  496. player.farmingperk = true;
  497. player.donationvalue += 3;
  498. Settings.amountdonated += 3;
  499. break;
  500. case 71:
  501. World.sendWorldMessage(
  502. "" + player.getDisplayName() + "<col=00FF00> has donated for the Sneaky one perk!",
  503. false);
  504. player.sendMessage("Thank you for your support!");
  505. player.thievperk = true;
  506. player.donationvalue += 3;
  507. Settings.amountdonated += 3;
  508. break;
  509. case 72:
  510. World.sendWorldMessage(
  511. "" + player.getDisplayName() + "<col=00FF00> has donated for the One true potion!",
  512. false);
  513. player.sendMessage("Thank you for your support!");
  514. player.potionperk = true;
  515. player.donationvalue += 8;
  516. Settings.amountdonated += 8;
  517. break;
  518. case 73:
  519. World.sendWorldMessage(
  520. "" + player.getDisplayName() + "<col=00FF00> has donated for the Smelly fish perk!",
  521. false);
  522. player.sendMessage("Thank you for your support!");
  523. player.fishingperk = true;
  524. player.donationvalue += 6;
  525. Settings.amountdonated += 6;
  526. break;
  527. case 74:
  528. World.sendWorldMessage(
  529. "" + player.getDisplayName() + "<col=00FF00> has donated for the Quarrymaster perk!",
  530. false);
  531. player.sendMessage("Thank you for your support!");
  532. player.miningperk = true;
  533. player.donationvalue += 4;
  534. Settings.amountdonated += 4;
  535. break;
  536. case 75:
  537. World.sendWorldMessage(
  538. "" + player.getDisplayName() + "<col=00FF00> has donated for the Axe master perk!",
  539. false);
  540. player.sendMessage("Thank you for your support!");
  541. player.axeperk = true;
  542. player.donationvalue += 4;
  543. Settings.amountdonated += 4;
  544. break;
  545. case 76:
  546. World.sendWorldMessage(
  547. "" + player.getDisplayName() + "<col=00FF00> has donated for the No degrading perk!",
  548. false);
  549. player.sendMessage("Thank you for your support!");
  550. player.nodegradeperk = true;
  551. player.donationvalue += 10;
  552. Settings.amountdonated += 10;
  553. break;
  554. case 77:
  555. World.sendWorldMessage(
  556. "" + player.getDisplayName() + "<col=00FF00> has donated for the ::tonpc command!",
  557. false);
  558. player.sendMessage("Thank you for your support!");
  559. player.cantonpc = true;
  560. player.donationvalue += 10;
  561. Settings.amountdonated += 10;
  562. break;
  563. case 78:
  564. World.sendWorldMessage(
  565. "" + player.getDisplayName() + "<col=00FF00> has donated for a Community key!",
  566. false);
  567. player.sendMessage("Thank you for your support!");
  568. player.getBank().addItem(29654, 1, true);
  569. player.donationvalue += 4;
  570. Settings.amountdonated += 4;
  571. break;
  572. case 79:
  573. World.sendWorldMessage(
  574. "" + player.getDisplayName() + "<col=00FF00> has donated for the Zamorak wings override!",
  575. false);
  576. player.sendMessage("Thank you for your support!");
  577. player.zamorakwingssc = true;
  578. player.donationvalue += 3;
  579. Settings.amountdonated += 3;
  580. break;
  581. case 80:
  582. World.sendWorldMessage(
  583. "" + player.getDisplayName() + "<col=00FF00> has donated for the Crystalline wings override!",
  584. false);
  585. player.sendMessage("Thank you for your support!");
  586. player.crystalwingsc = true;
  587. player.donationvalue += 3;
  588. Settings.amountdonated += 3;
  589. break;
  590. }
  591.  
  592. rs.updateInt("claimed", 1); // do not delete otherwise they can reclaim!
  593. rs.updateRow();
  594. }
  595.  
  596. destroy();
  597. } catch (Exception e) {
  598. e.printStackTrace();
  599. }
  600. }
  601.  
  602. /**
  603. *
  604. * @param host the host ip address or url
  605. * @param database the name of the database
  606. * @param user the user attached to the database
  607. * @param pass the users password
  608. * @return true if connected
  609. */
  610. public boolean connect(String host, String database, String user, String pass) {
  611. try {
  612. this.conn = DriverManager.getConnection("jdbc:mysql://"+host+":3306/"+database, user, pass);
  613. return true;
  614. } catch (SQLException e) {
  615. System.out.println("Failing connecting to database!");
  616. return false;
  617. }
  618. }
  619.  
  620. /**
  621. * Disconnects from the MySQL server and destroy the connection
  622. * and statement instances
  623. */
  624. public void destroy() {
  625. try {
  626. conn.close();
  627. conn = null;
  628. if (stmt != null) {
  629. stmt.close();
  630. stmt = null;
  631. }
  632. } catch(Exception e) {
  633. e.printStackTrace();
  634. }
  635. }
  636.  
  637. /**
  638. * Executes an update query on the database
  639. * @param query
  640. * @see {@link Statement#executeUpdate}
  641. */
  642. public int executeUpdate(String query) {
  643. try {
  644. this.stmt = this.conn.createStatement(1005, 1008);
  645. int results = stmt.executeUpdate(query);
  646. return results;
  647. } catch (SQLException ex) {
  648. ex.printStackTrace();
  649. }
  650. return -1;
  651. }
  652.  
  653. /**
  654. * Executres a query on the database
  655. * @param query
  656. * @see {@link Statement#executeQuery(String)}
  657. * @return the results, never null
  658. */
  659. public ResultSet executeQuery(String query) {
  660. try {
  661. this.stmt = this.conn.createStatement(1005, 1008);
  662. ResultSet results = stmt.executeQuery(query);
  663. return results;
  664. } catch (SQLException ex) {
  665. ex.printStackTrace();
  666. }
  667. return null;
  668. }
  669. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!