dbaccess.java

银行开发系统需要的TestJdbc,辅助帮助作用

package org.xjtu.testjdbc.dbaccess;

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

public class DBaccess {
	
	// 数据库的定位
	private String url = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8";

	private Connection conn = null;

	private String username = "root";

	private String pwd = "yujia";
	
	
	/**
	 * 连接数据库的方法
	 * 
	 */
     public void connDB()
     {
 	
 			try {
				DriverManager.registerDriver(new com.mysql.jdbc.Driver());
	 			conn = DriverManager.getConnection(url, username, pwd);
		        System.out.print("数据库连接成功");
 			} catch (SQLException e) {
 				System.out.print("数据库连接失败");
				e.printStackTrace();
			}    	 
     }
	
     /**
      * 返回数据库连接对象
      * @return
      */
	public Connection getConn()
	{
		
		if (this.conn != null)
		{
			return conn;			
		}
		else
		{
			return null;			
		}
		}
	
	
	/**
	 * 关闭数据库连接对象
	 */
	
	public void closeConn (Connection conn)
	
	{
		if (conn != null)
		{
			try {
				conn.close();
			} catch (SQLException e) {
				
				e.printStackTrace();
			}
		}
	
	}
	
	
	public static void main(String args[])
	{
		DBaccess dbaccess = new DBaccess();
		dbaccess.connDB();
	}
	
	

}