Struts2+JDBC 连接MySql验证登陆用户

来源：互联网发布：百视通下载软件编辑：程序博客网时间：2024/05/17 13:42

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));}

当时我在执行类里测试成功，但是run as on server一直失败，才发现jar包导错地方，应该拷到WEB-INF的lib中

0 0