1.
首先要下载Connector/J地址:
http://www.mysql.com/downloads/connector/j/
这是MySQL官方提供的连接方式:
解压后得到jar库文件,需要在工程中导入该库文件
2. 先写一个class来连接数据库
- public class dbconnector {
- public static final String url = "jdbc:mysql://127.0.0.1/test";
- public static final String name = "com.mysql.jdbc.Driver";
- public static final String user = "root";
- public static final String password = "";
- public Connection conn = null;
- public PreparedStatement pst = null;
- public dbconnector(String sql) {
- try {
- Class.forName(name);// 指定连接类型
- conn = DriverManager.getConnection(url, user, password);// 获取连接
- pst = conn.prepareStatement(sql);// 准备执行语句
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
- public void close() {
- try {
- this.conn.close();
- this.pst.close();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- }
3. 在Dao类中执行
- public String select(User user) {
- Map<String, String> usersMap = new HashMap<String, String>();
- String sql = null;
- dbconnector db1 = null;
- ResultSet ret = null;
- try {
- sql = "select * from user";//SQL语句
- db1 = new dbconnector(sql);
- ret = db1.pst.executeQuery();//执行语句,得到结果集
- while (ret.next()) {
- String uid = ret.getString(1);
- String uname = ret.getString(2);
- String upassword = ret.getString(3);
- usersMap.put(uname,upassword);
- }//显示数据
- ret.close();
- db1.close();//关闭连接
- // 传入的用户的用户名与密码
- String userName = user.getUsername();
- String password = user.getPassword();
- if (usersMap.containsKey(userName)
- && usersMap.get(userName).equals(password)) {
- return "1";
- } else {
- return "0";
- }
- } catch (Exception e) {
- e.printStackTrace();
- }
- return null;
- }
4. 可以在执行类里写一个main函数来测试
- public static void main(String[] args) {
- UserDaoJDBC udj = new UserDaoJDBC();
- User u = new User();
- u.setUsername("tester01");
- u.setPassword("tester");
- System.out.println(udj.select(u));
- }