JSP实验(4)

conn=DriverManager.getConnection(\,\,\123456\);

stmt=conn.createStatement();

rs=stmt.executeQuery(\); while(rs.next()){

if(rs.getString(1)==user&&rs.getString(2)==pwd) {

pass=true; %>

\/> <%

return; } }

conn.close();

}catch(Exception e){

out.print(\登录失败失败!\); e.printStackTrace(); } %>

Main.jsp

<%@ page language=\ contentType=\ pageEncoding=\%>

欢迎你:<%=request.getParameter(\) %>

16

2，注册功能

Input.jsp

<%@ page language=\ contentType=\ pageEncoding=\%>

<% %>

Sqllogin.jsp

<%@ page language=\ contentType=\ pageEncoding=\%>

<%@page import=\ %>

Hello ! <%

Connection conn=null; Statement stmt=null; ResultSet rs=null;

String user=request.getParameter(\); String pwd=request.getParameter(\); try{

Class.forName(\r\

17

conn=DriverManager.getConnection(\,\,\123456\);

stmt=conn.createStatement();

stmt.execute(\+user+\+pwd+\); out.print(\+user+\+pwd+\插入成功！\); }catch(Exception e){

out.print(\插入失败!\); e.printStackTrace(); } %>

18