Advertisement
Guest User

Untitled

a guest
May 8th, 2016
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.12 KB | None | 0 0
  1. ResultSet rs = null;
  2. PreparedStatement pst = null;
  3. Connection con = null;
  4. Statement st = null;
  5.  
  6. final String username = "root";
  7. final String password = "22535";
  8. final String url = "jdbc:mysql://localhost:3307/project";
  9.  
  10. String search = tf.getText();
  11.  
  12. String tot = "";
  13. int count = 0;
  14. String sql = "";
  15. String key="";
  16.  
  17.  
  18. for (int i = 0; i < search.length(); i++) {
  19. char c = search.charAt(i);
  20. if ((int) c >= 97 && (int) c <= 122) {
  21. count++;
  22. }
  23. }
  24. try {
  25.  
  26. con = DriverManager.getConnection(url, username, password);
  27. st = con.createStatement();
  28.  
  29.  
  30. if (count > 0) {
  31. sql = " sELECT * FROM project.quran where AyahTranslate like '%" + search + "%'";
  32.  
  33.  
  34.  
  35. } else {
  36.  
  37.  
  38. key+="+";
  39. for(int i=0; i<search.length(); i++){
  40. if(search.charAt(i)==' '){
  41. key+=" +";
  42. }else{
  43. key+=search.charAt(i);
  44. }
  45. }
  46.  
  47. sql = "sELECT * FROM project.quran WHERE MATCH (ayah) AGAINST ('" +key+"'IN BOOLEAN MODE);"; // search in Arabic
  48.  
  49.  
  50. }
  51.  
  52. ResultSet rset = st.executeQuery(sql);
  53.  
  54. Table1.setModel(DbUtils.resultSetToTableModel(rset));
  55.  
  56. } catch (Exception e) {
  57. System.out.println("Error");
  58. }
  59.  
  60. try {
  61.  
  62.  
  63. con = DriverManager.getConnection(url, username, password);
  64. System.out.println("Connected");
  65. st = con.createStatement();
  66.  
  67.  
  68. if (count > 0) {
  69.  
  70. sql = " SELECT count(*) AS TotalResult FROM project.quran where ayahtranslate like'%" + search + "%';";
  71.  
  72.  
  73. }else {
  74.  
  75.  
  76. sql = "SELECT COUNT(*) AS TotalResult FROM project.quran WHERE MATCH (ayah) against ('" +key + "' IN BOOLEAN MODE);";
  77. }
  78.  
  79. ResultSet rset = st.executeQuery(sql);
  80. while (rset.next()) {
  81. tot = rset.getString("TotalResult");
  82. }
  83.  
  84.  
  85.  
  86. tf1.setText("there are (" + tot + ") occurrences /t( " + search + ")in the Surah AL_Fatihah and Al_Baqarah.");
  87.  
  88. System.out.println(rset);
  89.  
  90. } catch (Exception e) {
  91. System.out.println("Error");
  92.  
  93. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement