dbutil.java

来自「JAVA注册表 详细列表 系统设计 源码」· Java 代码 · 共 92 行

/*
 * 连接MySQL数据库的Bean
 * 
 */
package db;

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

public class DbUtil {
	

	private static Connection conn = null;
	
	String driverName = "com.mysql.jdbc.Driver";
	String comPath = "jdbc:mysql://localhost:3306/tab";
	String id = "root";
	String pwd = "root";
	
	public static Connection getConn(){
		new DbUtil();
		return conn;
	}
	/**
	 * 构造方法加载驱动
	 */
	public DbUtil() {
		try {
			
			Class.forName(driverName);
			try {
                conn = DriverManager.getConnection(comPath, id, pwd);
            } catch (SQLException e) {
                // TODO 自动生成 catch 块
                e.printStackTrace();
            }
		} catch (java.lang.ClassNotFoundException e) {
			System.err.println(e.getMessage());
		}
	}
	
	/**
	 * 获取Statement
	 * @return
	 */
	public Statement getST(){
		Statement stmt = null;
		try {
			conn = DriverManager.getConnection(comPath, id, pwd);
			stmt = conn.createStatement(
					ResultSet.TYPE_SCROLL_INSENSITIVE,
					ResultSet.CONCUR_READ_ONLY);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return stmt;
	}

	/**
	 * 获取PreparedStatement
	 * @param strSQL
	 * @return
	 */
	public PreparedStatement getPS(String strSQL) {
		PreparedStatement ps = null;
		try {
			conn = DriverManager.getConnection(comPath, id, pwd);
			ps = conn.prepareStatement(strSQL);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return ps;
	}
	
	/*
	 * strArg是要转换的字符串
	 */
	public String getLM(String strArg) {
		try {
			strArg = new String(strArg.getBytes("ISO-8859-1"));
		} catch (Exception e) {
			System.out.println("Error:乱码转换出现异常");
			strArg = "";
		}
		return strArg;
	}
}