阅读背景:

网页登陆注册界面

来源:互联网 

结构:


UserDAO.java:

package com.demo.dao;  
import java.sql.DriverManager;
import java.sql.ResultSet;  
import java.sql.SQLException;  
import com.example.ConnectDB;  
import com.example.Reader;
import com.mysql.jdbc.Connection;  
import com.mysql.jdbc.PreparedStatement;  
public class UserDAO {   
    //数据库连接对象  
    public static  Reader  login(String name,String password) throws SQLException {  
       Reader u=null;  
       java.sql.Connection connection =null;  
       PreparedStatement pstmt=null;  
       ResultSet resultSet=null;    
      //赋值  
      try {  
        connection= DriverManager.getConnection(  
                "jdbc:MySQL://127.0.0.1:3306/test", "root", "123");   
          //静态sql语句  
        String sql = "select * from user where name=? and password=?";   
        pstmt = (PreparedStatement) connection.prepareStatement(sql);  
        pstmt.setString(1, name);  
        pstmt.setString(2, password);    
        resultSet = pstmt.executeQuery();  
        if(resultSet.next()){  
            u=new Reader();  
            u.setName(resultSet.getString("name"));  
            u.setPassword(resultSet.getString("password"));  
            System.out.println("登录成功!");  
        }else{  
            System.out.println("用户名或者密码错误!");  
        }    
    } catch (SQLException e) {  
        e.printStackTrace();  
    }finally {    
       ConnectDB.endConnect();    
    }  
     return u;    
}   }  package com.d



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: