condb.java

自己刚刚学习MVC时编写的

package com.Bean;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * @author lynn
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */

public class ConDB {
	String Driver = "sun.jdbc.odbc.JdbcOdbcDriver";
	String ConnStr = "jdbc:odbc:MVCDB";
	Connection conn = null;
	ResultSet rs = null;
	
	public void Connect () throws ClassNotFoundException, SQLException
	{
		Class.forName(Driver);
		conn = java.sql.DriverManager.getConnection(ConnStr,"","");
	}
	public void close ()
	{
		try
		{
			rs.close();
			conn.close();
		}
		catch (SQLException e){}
	}
	public ResultSet executeQuery(String sql)
	{
		try
		{
			Statement st = conn.createStatement();
			rs = st.executeQuery(sql);
		}
		catch(SQLException e){}
		return rs;
	}
	public int executeUpdate(String sql) 
	{
		int result = 0;
		try { 
			Statement stmt = conn.createStatement();
			result = stmt.executeUpdate(sql);
		} 
		catch(SQLException ex) { 
			System.err.println(ex.getMessage());
		}
		return result;
	}
}