dbdo.java

来自「类似qq的以c/s结构和p2p结构结合的聊天软件。」· Java 代码 · 共 56 行

package mybean;
import java.sql.*;
public class dbdo 
{
	Connection conn=null;
	Statement stmt=null;
	ResultSet rs=null;
	String sqlStr;
	public dbdo()
	{
		try
	       {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		   }
		catch(ClassNotFoundException e)
		    {
             System.err.println(e.getMessage());
		    }
		try
		{
			String url="jdbc:odbc:usergrade";
			conn=DriverManager.getConnection(url);
			stmt=conn.createStatement();
		}
		catch(SQLException ce)
		{
			System.err.println(ce.getMessage());
		}
	}
	public void update(String str)
	{
		try
		{
			sqlStr=str;
		    stmt.executeUpdate(str);
		}
	    catch(SQLException ce)
		{
			System.err.println(ce.getMessage());
		}
	}
	
	public ResultSet query(String str)
	{
	    try
		{
			sqlStr=str;
		    rs=stmt.executeQuery(str);
		}
	    catch(SQLException ce)
		{
			System.err.println(ce.getMessage());
		}
		return rs;	
	}
}