dconnet.java

利用Struts的MVC写的WEB开发程序

/****************************
****************************/
package dlayer;

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

public class DConnet {
	
	private Connection con;
	
	private ResultSet rs;
	
	private Statement stmt;
	
	private int resultCount = 0;
	
	public DConnet(){

	}

	public  Connection Connect() throws SQLException{
		
		try {
			
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
			
			con = DriverManager.getConnection("jdbc:odbc:bookbase"); 
			
//			stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
//					ResultSet.CONCUR_READ_ONLY);
			
		} catch (ClassNotFoundException e) {
	
			// TODO 自?生成 catch ?
			e.printStackTrace();
			
		} catch (SQLException e) {
		
			// TODO 自?生成 catch ?
			e.printStackTrace();
		
		}
		
		return con;

	}

	
	public ResultSet Select(String sql) throws SQLException{
		
		try {
			
			stmt = con.createStatement();
			
			rs = stmt.executeQuery(sql);
					
			
		} catch (SQLException e) {
		
			// TODO 自?生成 catch ?
			e.printStackTrace();
		
		}
		
		return rs;

	}
	
	public int update(String sql) throws SQLException{
		
		try {
			
			stmt = con.createStatement();
			
			resultCount = stmt.executeUpdate(sql);
			
			con.commit();
			
		} catch (SQLException e) {
		
			// TODO 自?生成 catch ?
			e.printStackTrace();
	
		}
		
		return resultCount;

	}

	public Connection getCon() {

		return con;

	}

}