conndb.java

利用poi插件和Java语言在web中实现excel的合并功能

package com.dao.conn;

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

public class ConnDB {
	public ConnDB() {
	}

	// 如何从配置文件里读出来的信息
	private static Connection conn = null;

	private static String driverName = "com.mysql.jdbc.Driver"; // JDBC驱动
	
	// -----------the net database property
//	private static String userName = "dlqihua"; // 数据库登录用户名
//	private static String password = "wan523065115mm"; // 数据库登录密码(如果没有设置，可以为空)
//	private static String dbName = "dlqihua"; // 数据库名称

	private static String userName="root";
	private static String password="lxj504241";
	private static String dbName="test1";

	private Statement stmt; // 数据库管理员

	private ResultSet res; // 返回结果集

	private int num_per = 0;// 每页显示的记录数

	private int num_rs = 0;// 总计录数

	private int num_currentpage = 1;// 当前页数

	private int num_pages = 1;// 总页数

//	private static String url = "jdbc:mysql://221.231.140.155:3306/" + dbName
//			+ "?user=" + userName + "&password=" + password;
	private static String url = "jdbc:mysql://localhost:3306/" + dbName
	+ "?user=" + userName + "&password=" + password;

	public static Connection getConnection() {
		try {
			Class.forName(driverName);
			conn = DriverManager.getConnection(url);
		} catch (ClassNotFoundException ex) {
			ex.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return conn;
	}

	public ResultSet executeQuery(String sql) {
		// 对数据库进行查询操作

		try {
			conn = this.getConnection();
			stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
					ResultSet.CONCUR_READ_ONLY);
			try {
				res = stmt.executeQuery(sql);
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
				return null;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}
		return res;
	}

	public boolean execute(String sql) {
		try {
			if (conn == null) {
				getConnection();
			}
			stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
					ResultSet.CONCUR_READ_ONLY);
			stmt.execute(sql);
			return true;
		} catch (Exception e) {
			e.printStackTrace();
			return false;
		}
	}

	public int update(String sql) {
		// 对数据库信息进行更新操作
		int count = 0;
		try {
			if (conn == null) {
				getConnection();
			}
			stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
					ResultSet.CONCUR_READ_ONLY);
			count = stmt.executeUpdate(sql);
			return count;
		} catch (SQLException e) {
			e.printStackTrace();
			return 0;
		} finally {
			this.close();
		}
	}

	public void close() {
		// 关闭数据库连接

		if (res != null) {
			try {
				res.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} finally {
				res = null;
			}
		}
		if (stmt != null) {
			try {
				stmt.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} finally {
				stmt = null;
			}
		}
		if (conn != null) {
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} finally {
				conn = null;
			}
		}
	}

//	public void setPage(Page page) {
//		this.num_per = page.getNumper();
//		this.num_rs = page.getNumrs();
//		this.num_pages = page.getNumPages();
//		this.num_currentpage = page.getCurrentPage();
//	}
//
//	public int getNumper() {
//		return this.num_per;
//	}
//
//	public int getNumrs() {
//		return this.num_rs;
//	}
//
//	public int getCurrentPage() {
//		return this.num_currentpage;
//	}
//
//	public int getNumPages() {
//		return this.num_pages;
//	}
}