Ressource insérées dans l'infospace
Outil provisoire.
Notez qu'il s'agit d'un GET url qui demande un uid (user name). Vous pouvez copier/bookmarker cet URL.
Exemple: http://tecfa.unige.ch/tecfa/teaching/staf18/files-f/ress-list.sxml?uid=boualem
Vivian, please integrate this into your servlet (just the generation of a link)
String uid;
if ( (uid = request.getParameter("uid")) == null) uid = "schneide";
String userId;
String url = "jdbc:mysql://tecfa.unige.ch:3306/infospace";
String queryString = "SELECT userId, username, nom FROM users WHERE username=\'" + uid + "\'";
Class.forName("org.gjt.mm.mysql.Driver");
Connection con = DriverManager.getConnection(url, "campus", "snowwhite");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(queryString);
rs.next();
userId = rs.getString(1);
org.gjt.mm.mysql.Driver
jdbc:mysql://tecfasun5.unige.ch/campus
nobody
0
50
y
yes
ROWSET
ROW
omit
ID
select Id, Title, Description, Location, Abstract, FullReference, Language, Contributors, Coverage, Presentation, PriceCode, Publisher, MetadocumentAuthorId, MetadocumentDate, MetadocumentEditDate, MetadocumentEditAuthorId from Objects where MetadocumentAuthorId=userId