db.java

来自「是一个利用AJAX Mysql Java 编写的聊天室系统 主要功能都实现了聊天」· Java 代码 · 共 48 行

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;
	}

}