Question

求jsp网页代码@@用户登录--注册--(要连接数据库的哦)

有解释最好 () // <!-- --> : ; , " " ''

可以发我信箱515670002@qq.com

有留言板 代码 也要个

Answer 1

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<title>登录</title>
<%
String user=request.getParameter("user");
String pwd=request.getParameter("pwd");
if(user!=null)
{
String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=data/data.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:/myweb/data/data.mdb");
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql="select * from users where user='"+user+"' and pwd='"+pwd+"'";
if(stmt.executeQuery(sql))
response.sendRedirect("index.jsp");
rs.close();
con.close();
}
%>

<table width=100% height=100% border=0>
<tr>
<td align=middle >
<table border=1 style="border-color:black"><tr><td align=middle>
<div style="width:400;height:200;background:skyblue;">
<div style="margin-top:50px">
<form method="post" action="">
<b>用户名</b>：<input type="text" name="user" id="user" size=19 value="">
<br><br>
<b>密  码</b>：<input type="password" name="pwd" id="pwd" size=20 value="">
<br><br>
<input type=submit value="提交" style="width:50px">
   
<input type=reset value="重设" style="width:50px">
</form>
</div>
</div>
</td></tr></table>
</td>
</tr>
</table>