dataTable erstellen

Diese Seite verwendet Cookies. Durch die Nutzung unserer Seite erklären Sie sich damit einverstanden, dass wir Cookies setzen. Weitere Informationen

  • dataTable erstellen

    Hallo!

    Ich habe ein Frage zur Erstellung einer dataTable mit ajax4jsf oder RichFaces. Kennt sich da jemand mit aus?
    Hier ist mein Code:

    Quellcode

    1. import java.io.File;
    2. import java.io.Serializable;
    3. import java.util.ArrayList;
    4. import java.util.Iterator;
    5. import java.util.List;
    6. import java.sql.*;
    7. import java.util.Vector;
    9. import org.apache.lucene.analysis.Analyzer;
    10. import org.apache.lucene.analysis.standard.StandardAnalyzer;
    11. import org.apache.lucene.document.Document;
    12. import org.apache.lucene.queryParser.MultiFieldQueryParser;
    13. import org.apache.lucene.queryParser.QueryParser;
    14. import org.apache.lucene.search.Hits;
    15. import org.apache.lucene.search.IndexSearcher;
    16. import org.apache.lucene.search.Query;
    17. import org.apache.lucene.store.Directory;
    18. import org.apache.lucene.store.FSDirectory;
    21. public class SG implements Serializable
    22. {
    23. /**
    24. *
    25. */
    27. private static final long serialVersionUID = 1L;
    29. private String property;
    33. private List data;
    34. private List tokens;
    36. private String rows;
    37. private String first;
    38. private String cellspacing;
    39. private String cellpadding;
    40. private String minchars;
    41. private String frequency;
    42. private String rules;
    43. private boolean check;
    44. private String shadowDepth;
    45. private String border = "1";
    46. private String width = "200";
    47. private String height = "150";
    48. private String shadowOpacity = "4";
    49. private String result;
    54. public List autocomplete(Object event) {
    55. List v = new Vector();
    56. String prefix = event.toString();
    57. if(event.toString().length()>0){
    58. v = executeSuggestQuery("select * from diseaseresult where title like '"+prefix+"%' limit 0,50");
    59. }
    60. return v;
    61. }
    65. private List executeSuggestQuery(String query) {
    66. String dbName = "datenmodell";
    67. String host = "localhost:3309";
    68. String user = "root";
    69. String pw = "280280";
    70. Vector v = null;
    71. Connection conn;
    72. Statement stmt;
    73. ResultSet rs;
    74. try {
    75. Class.forName("com.mysql.jdbc.Driver");
    76. conn = DriverManager.getConnection("jdbc:mysql://"+host+"/"+dbName,user,pw);
    79. stmt = conn.createStatement();
    80. rs = stmt.executeQuery(query);
    81. ResultSetMetaData rsmd = rs.getMetaData();
    82. v = new Vector(rs.getFetchSize());
    83. while(rs.next()){
    84. Data d = new Data(rs.getString(1));
    85. v.add(d);
    86. }
    88. }catch (SQLException e) {
    89. e.printStackTrace();
    90. v = new Vector();
    91. v.add(e.getMessage());
    92. return v;
    93. }catch (ClassNotFoundException e) {
    94. e.printStackTrace();
    95. v = new Vector();
    96. v.add(e.getMessage());
    97. return v;
    98. }
    99. return v;
    102. }
    103. public String Testausgabe(){
    105. ArrayList list;
    106. try {
    107. list = search("\""+property+"\"", medline_index, medline_fields);
    108. result = "";
    109. for(int i = 1; i < list.size(); i++)
    110. {
    112. result += list.get(i).toString()+"\n";
    113. }
    114. } catch (Exception e) {
    115. // TODO Auto-generated catch block
    116. e.printStackTrace();
    117. }
    121. return "success";
    122. }
    125. double schwelli=0.0;
    126. public static String entry_medline = "PMID";//Gibt Entry ID an...
    127. public static String[] medline_fields ={"ABSTRACTS", "TITLE"};// Felder, die durchsucht werden sollen
    128. public static File medline_index = new File("C:/Dokumente und Einstellungen/blabla/Desktop/Medline_Index_Standard");//Angabe, wo der Index ist... z.B. C:\\Index_Medline
    131. public ArrayList search(String q, File index, String [] fields) throws Exception {
    134. Directory fsDir = FSDirectory.getDirectory(index, false);
    135. IndexSearcher is = new IndexSearcher(fsDir);
    136. Analyzer analyzer = new StandardAnalyzer();
    137. QueryParser queryparser = new MultiFieldQueryParser (fields, analyzer);
    138. Query query = queryparser.parse(q);
    139. Hits hits = is.search(query);
    140. ArrayList list = new ArrayList();
    141. System.out.println(hits.length() + " Treffer insgesamt ohne Schwellwert-Filterung gefunden!");
    142. for (int i = 0; i < hits.length(); i++) {
    143. if (hits.score(i)>schwelli){
    145. Document doc = hits.doc(i);
    146. list.add(doc);
    147. //System.out.println(i+" "+list.get(i));
    148. }
    149. }
    151. return list;
    152. }
    157. /** Diese Methode setzt den Score-Schwellwert schwelli*/
    158. void setSchwelli (double zahl){
    159. schwelli = zahl;
    160. }
    165. public String getResult()
    166. {
    168. return result;
    169. }
    172. public List getData() {
    173. return data;
    174. }
    176. public void setData(List data) {
    177. this.data = data;
    178. }
    180. public String getProperty() {
    181. return property;
    182. }
    184. public void setProperty(String property) {
    185. this.property = property;
    186. }
    188. public String getCellpadding() {
    189. return cellpadding;
    190. }
    192. public void setCellpadding(String cellpadding) {
    193. this.cellpadding = cellpadding;
    194. }
    196. public String getCellspacing() {
    197. return cellspacing;
    198. }
    200. public void setCellspacing(String cellspacing) {
    201. this.cellspacing = cellspacing;
    202. }
    204. public boolean isCheck() {
    205. return check;
    206. }
    208. public void setCheck(boolean check) {
    209. this.check = check;
    210. }
    212. public String getFirst() {
    213. return first;
    214. }
    216. public int getIntFirst() {
    217. return Integer.parseInt(getFirst());
    218. }
    220. public void setFirst(String first) {
    221. this.first = first;
    222. }
    224. public String getFrequency() {
    225. return frequency;
    226. }
    228. public double getDoubleFrequency() {
    229. return Double.parseDouble(getFrequency());
    230. }
    232. public void setFrequency(String frequency) {
    233. this.frequency = frequency;
    234. }
    236. public String getMinchars() {
    237. return minchars;
    238. }
    240. public void setMinchars(String minchars) {
    241. this.minchars = minchars;
    242. }
    244. public String getRows() {
    245. return rows;
    246. }
    248. public int getIntRows() {
    249. return Integer.parseInt(getRows());
    250. }
    252. public void setRows(String rows) {
    253. this.rows = rows;
    254. }
    256. public String getRules() {
    257. return rules;
    258. }
    260. public void setRules(String rules) {
    261. this.rules = rules;
    262. }
    264. public List getTokens() {
    265. return tokens;
    266. }
    268. public void setTokens(List tokens) {
    269. this.tokens = tokens;
    270. }
    272. public void OnSelect() {
    273. System.out.print("Onselect works!!!");
    275. }
    277. public String getShadowDepth() {
    278. return shadowDepth;
    279. }
    281. public void setShadowDepth(String shadowDepth) {
    282. this.shadowDepth = shadowDepth;
    283. }
    285. public String getBorder() {
    286. return border;
    287. }
    289. public void setBorder(String border) {
    290. this.border = border;
    291. }
    293. public String getWidth() {
    294. return width;
    295. }
    297. public void setWidth(String width) {
    298. this.width = width;
    299. }
    301. public String getHeight() {
    302. return height;
    303. }
    305. public void setHeight(String height) {
    306. this.height = height;
    307. }
    310. }
    Alles anzeigen


    Weiß jemand, was ich ändern muss, wenn ich daraus eine dataTable machen will?

    Liebe Grüße!