a0ce398224b9001c101ccc1c55193efc

基于Java实现的聊天室功能

package Date;
import java.sql.*;
public class Conn {
	private static Connection conn;
	private Statement  stmt;
	private ResultSet rs;
	private static final String drivername ="com.microsoft.jdbc.sqlserver.SQLServerDriver";
	private static final String url = "jdbc:microsoft:sqlserver://192.168.1.103:1433;DatabaseName=students";

        public Conn(){
           
        }
        
        public static synchronized Connection getCon(){
        	try{
        		Class.forName(drivername).newInstance();
        		conn = DriverManager.getConnection(url,"sa","123456789");
        		conn.setAutoCommit(false);
        	return conn;
        	}catch(Exception e){
        		System.out.println("连接失败");
        		e.printStackTrace();
        		return null;
        	}
        }
        
        public boolean commit(){
        	try {
				conn.commit();
			} catch (SQLException e){
				e.printStackTrace();
				return false;
			}
			return true;
        }
        
        public Statement getStmtread(){
        	try{
        		conn = getCon();
        		stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
        				                              ResultSet.TYPE_FORWARD_ONLY);
        		return stmt;
        	}catch(Exception e){
        		return null;
        	}
        }
        
        public ResultSet getRs(String sql){
        	try{
        		stmt = getStmtread();
        		rs = stmt.executeQuery(sql);
        		return rs;
        	}catch(Exception e){
        		return null;
        	}
        }
        
/*        public Statement getStmt(){
        	try{
        		conn = getCon();
        		stmt = conn.createStatement();
        		return stmt;
        	}catch(Exception e){
        		return null;
        	}
        }
        
        public synchronized void close(){
        	try{
        		if(rs!=null){
        			rs.close();
        			rs = null;
        		}
        	}catch(Exception e){
        		
        	}
        	try{
        		if(stmt!=null){
        			stmt.close();
        			stmt = null;
        		}
        	}catch(Exception e){
        		
        	}
        	try{
        		if(conn!=null){
        			conn.close();
        			conn = null;
        		}
        	}catch(Exception e){
        		
        	}
        }*/
        
        public static void main(String[] args){
        	
        }
}