mydmo.java

模仿qq的聊天系统,java做的,能基本实现聊天同信功能

/*
 *该类提供对数据库访问的支持
 *
 */
package com.hs ;

import java.sql.* ;

public class MyDMO {
	//查询数据库用户中是否存在U和P
	public boolean validateUandP(String u , String p) {
		boolean b = false ;
		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver") ;
			Connection cn = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=QQ" , "sa" , "1234") ;
			
			Statement st = cn.createStatement() ;
			
			String sqlstring = "select * from Users where username = '"+ u +"' and password = '"+ p +"'" ;
			System.out.println ("aaaaa") ;
			ResultSet rs = st.executeQuery(sqlstring) ;
			
			b = rs.next() ;
	    }
	    catch (Exception ex) {
	    	ex.printStackTrace() ;
	    }
	    
	    return(b) ;
	}  
}