java联接mysql

2012-07-15

java连接mysql?public class UserDAO {private final static String dataBaseName user//数据库名称p

java连接mysql

public class UserDAO {private final static String dataBaseName = "user";  //数据库名称private final static String tableName = "user";private Connection connection = null;private String userName = "root";   //用户名private String password = "";   //密码UserDAO(){getConnect(); }public void  getConnect(){if(connection != null) return; String driverName = "com.mysql.jdbc.Driver"; String url = "jdbc:mysql://127.0.0.1:3306/" + dataBaseName;try {Class.forName(driverName); connection = DriverManager.getConnection(url, userName, password); String sql = "create table if not exists " + tableName + " (uid varchar(64), platformAddress varchar(64), primary key (uid)) ";PreparedStatement ps;ps = connection.prepareStatement(sql); ps.executeUpdate();  } catch (Exception e) {}}}

?需要注意的问题：

1、(win 7 系统)在开始-->搜索，然后输入“服务”，打开服务列表，检查一下mysql是否为开启状态。

2、jdbc的驱动包要加到“Referenced Libraries”里，下载地址是“http://www.mysql.com/downloads/” 里面的Connector/J。

热点排行

Mysql

java联接mysql