db.java

是一个利用AJAX Mysql Java 编写的聊天室系统 主要功能都实现了聊天室的 但是私聊的时候我还是具体不知道怎么做 希望大家看了之后 和我联系QQ383090450 大家一起交流

package Service;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class DB {
	 String     driver = "org.gjt.mm.mysql.Driver";
	 String     url    = "jdbc:mysql://localhost:3306/chat?useUnicode=true&characterEncoding=gb2312"; 
	 String     user   = "root";
	 String     pwd    = "123456";
	 Connection con;
	 Statement  sta;
	 ResultSet  rs;	
	public void Update(String sqlStr){
	try{		     
		 Class.forName(driver);         
		 con = DriverManager.getConnection(url,user,pwd); 
		 sta =con.createStatement();
		 sta.executeUpdate(sqlStr);

		}catch(Exception e){e.printStackTrace();}
		}
	public ResultSet SelectMessage(String sqlStr){
		try{     
			 Class.forName(driver);         
			 con = DriverManager.getConnection(url,user,pwd); 
			 sta =con.createStatement();
			 rs=sta.executeQuery(sqlStr);
	         
			}catch(Exception e){e.printStackTrace();}
		      return rs;
	}
	public ResultSet SelectInfo(String sqlStr){
		try{     
			 Class.forName(driver);         
			 con = DriverManager.getConnection(url,user,pwd); 
			 sta =con.createStatement();
			 rs=sta.executeQuery(sqlStr);
	     
			}catch(Exception e){e.printStackTrace();}
		     return rs;
	}

}