java连接mysql类_java连接mysql类

package com.zyw.dao;

import java.io.PrintStream;

import java.sql.Connection;

import java.sql.DriverManager;

public class DBConnectionMysql

{

private String mySqlDriver;

private String mySqlUrl;

private String mdbDrStr;

private String mdbUrl;

long time;

private String SQLDRIVER;

private String SQLURL;

public Connection conn;

boolean Conectde;

public DBConnection()

{

mySqlDriver = "org.gjt.mm.mysql.Driver";

mySqlUrl = "jdbc:mysql://localhost/test?user=root&password=1&useUnicode=true&characterEncoding=8859_1";

conn = null;

Conectde = false;

time = System.currentTimeMillis();

try

{

Class.forName(SQLDRIVER).newInstance();

if (conn == null)

{

conn = DriverManager.getConnection(SQLURL,"sa","1");

Conectde = true;

System.out.print("

}

}

catch (Exception e)

{

e.printStackTrace();

}

}

public Connection getCon()

{

return conn;

}

public void dbClose()

{

try

{

if (Conectde)

{

conn.close();

Conectde = false;

System.out.print(System.currentTimeMillis() - time);

System.out.print(">  ");

}

}

catch (Exception e)

{

e.printStackTrace();

}

}

}

提醒:要下载mysql驱动,具体地址:http://download.csdn.net/detail/softmen6688/4839716