userdao.java

java编写聊天室

/**
 * 
 */
package user.DAO;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import user.entity.*;

/**
 *
 *
 */
public class UserDAO {
	public static boolean getUserNameandPassword(User user)
	{
		
		 try{      
			    String RL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test";
		        String name ="sa";
		        String password = "sa";
		        String sqlStr2="select * from yonghu where u_name='"+user.getUserName()+"' and u_password='"+user.getUserPassword()+"'";
	            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
	           
	            Connection con = DriverManager.getConnection(RL,name,password);
	            
	           // System.out.println( "创建连接对像成功!" );
	            Statement st = con.createStatement();          
	            System.out.println( "创建Statement成功!" );
	            //st.execute(sqlStr2);
	            ResultSet rs = st.executeQuery( sqlStr2 );           
	            System.out.println( "操作数据表成功!" );
	            System.out.println( "----------------!" );
	            
	            while(rs.next())
	            {
	            	return true;
	            }
	            
	          
	        
	         
 
	           
	            
	        }
	        catch(Exception err){
	            
	            return false;
	        }
	         
	       return false;
	}

}