datamanager.java

来自「是一个简单的客户端,服务器的聊天程序,可实现客户端和服务器的连接,并实现多方聊天」· Java 代码 · 共 77 行

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

public class DataManager
{
	Connection m_dbConn;
	Statement m_dbStatement;
	
	DataManager()
	{
		String strDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
		String strConnURL = "jdbc:odbc:ChatClient";
		
		try
		{
			Class.forName(strDriver);
		}
		catch(Exception exp)
		{

			System.out.println("Client: Database Error");
			System.out.println(exp.getMessage());
		}
		
		try
		{
			m_dbConn = DriverManager.getConnection(strConnURL);
			m_dbStatement = m_dbConn.createStatement();
		}
		catch(Exception exp)
		{
			System.out.println("Client: Database Error");
			System.out.println(exp.getMessage());
		}
	}
	
	boolean saveContext(String strName, String strContext)
	{
		String strCmd;
		
		strCmd = "INSERT INTO ChatContext(Name, Context) VALUES (" +
				"'" + strName + "'" + "," +
				"'" + strContext + "');";
		try
		{
			m_dbStatement.executeUpdate(strCmd);
		}
		catch(Exception exp)
		{

			System.out.println("Client: Database Error");
			System.out.println(exp.getMessage());
		}
		
		return true;
	}
	
	boolean shutdownDataBase()
	{
		try
		{
			m_dbStatement.close();
			m_dbConn.close();
		}
		catch(Exception exp)
		{
			System.out.println("Client: Database Error");
			System.out.println(exp.getMessage());
		}
		
		return true;
	}
}