[Nmrshiftdb-devel] CVS: nmrshiftdb/src/java/org/openscience/nmrshiftdb AdminPanel.java, 1.232, 1.233

[Stefan K. <sh...@us...>]

Update of /cvsroot/nmrshiftdb/nmrshiftdb/src/java/org/openscience/nmrshiftdb
In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv13604/src/java/org/openscience/nmrshiftdb

Modified Files:
	AdminPanel.java 
Log Message:
the time for the done orders can be set


Index: AdminPanel.java
===================================================================
RCS file: /cvsroot/nmrshiftdb/nmrshiftdb/src/java/org/openscience/nmrshiftdb/AdminPanel.java,v
retrieving revision 1.232
retrieving revision 1.233
diff -C2 -r1.232 -r1.233
*** AdminPanel.java	29 Aug 2006 16:10:04 -0000	1.232
--- AdminPanel.java	6 Oct 2006 13:00:04 -0000	1.233
***************
*** 35,42 ****
--- 35,45 ----
  import libsvm.svm_train;
  
+ import org.apache.jetspeed.services.JetspeedSecurity;
+ import org.apache.jetspeed.services.rundata.DefaultJetspeedRunData;
  import org.apache.log4j.Category;
  import org.apache.log4j.FileAppender;
  import org.apache.log4j.SimpleLayout;
  import org.apache.turbine.om.NumberKey;
+ import org.apache.turbine.om.security.User;
  import org.apache.turbine.services.db.TurbineDB;
  import org.apache.turbine.util.Log;
***************
*** 994,1003 ****
  	  DBConnection dbconn = TurbineDB.getConnection();
  	  Statement stmt = dbconn.createStatement();
! 	  ResultSet rs = stmt.executeQuery("select SPECTRUM_ID, COMMENT from SPECTRUM;");
  	  FileOutputStream fos=new FileOutputStream("/tmp/gr.sql");
  	  while (rs.next()) {
  		  fos.write(new String("update SPECTRUM set COMMENT='"+GeneralUtils.escape(rs.getString(2))+"' where SPECTRUM_ID="+rs.getInt(1)+";\r\n").getBytes());
  	  }
! 	  fos.close();
  	  /*ResultSet rs = stmt.executeQuery("select MOLECULE_ID from MOLECULE;");
  	  int errors=0;
--- 997,1013 ----
  	  DBConnection dbconn = TurbineDB.getConnection();
  	  Statement stmt = dbconn.createStatement();
! 	  ResultSet rs = stmt.executeQuery("select LOGIN_NAME,FIRST_NAME,LAST_NAME,ADDRESS,CITY from TURBINE_USER where FIRST_NAME=LAST_NAME;");
! 	  while (rs.next()){
! 		  if (warn(rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4)+" "+rs.getString(5)+" delete?", new BufferedReader(new InputStreamReader(System.in)))) {
!           	User user = JetspeedSecurity.getUser(rs.getString(1));
!         	JetspeedSecurity.removeUser(user, new DefaultJetspeedRunData());
! 		  }
! 	  }
! 	  /*ResultSet rs = stmt.executeQuery("select SPECTRUM_ID, COMMENT from SPECTRUM;");
  	  FileOutputStream fos=new FileOutputStream("/tmp/gr.sql");
  	  while (rs.next()) {
  		  fos.write(new String("update SPECTRUM set COMMENT='"+GeneralUtils.escape(rs.getString(2))+"' where SPECTRUM_ID="+rs.getInt(1)+";\r\n").getBytes());
  	  }
! 	  fos.close();*/
  	  /*ResultSet rs = stmt.executeQuery("select MOLECULE_ID from MOLECULE;");
  	  int errors=0;