10.19

String sql="select username,password from users"

RrsultSet rs=stmt.executeQuery(sql);

 

request.setCharacterEncoding("UTF-8");

String s1=request.getParameter("");

String s2=request.getParameter("");

String sql="select * from users where username=? and password=?";

PreparedStatement pstmt=conn.prepareStatement(sql);

pstmt.setString(1,s1);

pstmt.setString(2,s2);

ResultSet rs=pstmt.executeQuery();

 

if (rs.next()) { }

   else { }

                   

 

String user_name=rs.getString("username");

String user_password=rs.getString("password");

 

 

 

rs.close();

stmt.close();

con.close();