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。