package org.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

 

public class BaseDao {
	public static final String DRIVER="com.mysql.jdbc.Driver";
	public static final String URLSTR="jdbc:mysql://localhost/exam";
	public static final String UID="root";
	public static final String PWD="sa";
	
	public static final String TABLE_USER=" tenyears_users ";
	public static final String TABLE_TITLE=" tenyears_newstitle ";
	public static final String TABLE_CONTENT=" tenyears_newscontent ";
	public static final String TABLE_TYPE=" tenyears_newstype ";
	public static final Integer ROWS=10;
	
	protected  Connection con;
	protected PreparedStatement pst;
	protected ResultSet res;
	protected Integer pageCount;
	
	protected void open(){
		try {
			Class.forName(DRIVER);
			con=DriverManager.getConnection(URLSTR,UID,PWD);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	protected void close(){
		try {
			 if(res != null) res.close();
			 if(pst !=null) pst.close();
			 if(con !=null) con.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	public Integer getPageCount() {
		return pageCount;
	}

	
	
}