test.java

简单的操作ldap的管理系统

/*
 * 创建日期 2007-4-13
 *
 * 更改所生成文件模板为
 * 窗口 > 首选项 > Java > 代码生成 > 代码和注释
 */
package mypack;
import mypack.*;
import java.sql.*;
import java.lang.System;
import java.io.*;

/**
 * @author qzj
 *
 * 更改所生成类型注释的模板为
 * 窗口 > 首选项 > Java > 代码生成 > 代码和注释
 */
public class test {
	
	      public void tt(){
		try{	                    Statement stmt;
		
								Connection conn;
								DatabaseConnection db=new DatabaseConnection();
								conn = db.getCon();
   	            
								// 创建Statement对象
							   stmt = conn.createStatement();
   	
								// 执行SQL语句
								ResultSet rs=stmt.executeQuery("select * from USERS");
			while(rs.next())
								{System.out.println(rs.getString(1));} 
								int n =1;
								boolean flag=true;
								//while(rs.next())
							//	{
								// if(rs.getString(n)==user.getUsername())
								//	{
								//	 flag=false;
								//	} 
								//	n++; 			
								//}
					
								stmt.close();
								conn.close();}
	      
			
			catch (SQLException e) {
	// TODO Auto-generated catch block
	e.printStackTrace();}
	catch (InstantiationException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (IllegalAccessException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (ClassNotFoundException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
	      }
	      
	      
	public static void  main(String[]args)
	  {
   
	  //test t=new test();
	 // t.tt();
	 UserMgr mgr=new UserMgr();
	 user us=new user();
				  us.setUsername("周星驰");
				  us.setPassword("111");
				  us.setMail("香港");
	// if(mgr.check(us))
			//	   {System.out.println("correct!");
			//		System.out.println();} 
				//   else
			//	   System.out.println("chongfuzhuce!");
				   
		try {
							// 获取数据库连接
							Statement stmt;
							Connection conn;
							DatabaseConnection db=new DatabaseConnection();
							conn = db.getCon();
   	            
							// 创建Statement对象
						   stmt = conn.createStatement();
   	
							// 执行SQL语句
							ResultSet rs=stmt.executeQuery("select * from USERS");
				
							boolean flag=true;
							while(rs.next())
							{
							 if(rs.getString(1).equalsIgnoreCase(us.getUsername()))
								{
								 System.out.println("rs.getString(1)");
								} 
								//System.out.println(rs.getString(1));
								//System.out.println("@@@ "+us.getUsername());
                        		
							}
					
							stmt.close();
							conn.close();
					
					
   	
							
						} 
						catch (Exception e){
							System.err.println(e);
						}
				
   	
						
	 
	 
	  }


}