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

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中