data.java

来自「Java完全自学宝典配套源代码 全集 例子丰富」· Java 代码 · 共 50 行

package wyf;
import java.sql.*;

class Data 
{
	public Data()
	{
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		catch(ClassNotFoundException ex)
	    {
		    System.err.println();
	    }
	}

	
	public ResultSet executeQuery(String sql)
	{
		ResultSet rs=null;
		try
		{
			Connection con=DriverManager.getConnection("jdbc:odbc:student");
		    Statement st=con.createStatement();
		    rs=st.executeQuery(sql);
		}
    	catch(SQLException e)
	   {
		   System.err.println();
	   }
	   return rs;	
	}
	
	public ResultSet executeUpdate(String sql)
	{
		ResultSet rs=null;
		try
		{
			Connection con=DriverManager.getConnection("jdbc:odbc:student");
		    Statement st=con.createStatement();
		    rs=st.executeQuery(sql);
		}
		catch(SQLException e)
	   {
		   System.err.println();
	   }
	   return rs;	
	}
}