点击注册按钮后数据怎样才能写入数据库 写好一个注册的jsp后(用户名,密码,Email等),填写完表单之后,表单的数据怎样才能插入已经存在的user表中?我的数据库的链接是没有问题的。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 insert into [user] select 用户名,密码,Email from ..... INSERT INTO [USER](USERNAME,PASSWORD,EMAIL)SELECT 'USER1','123','[email protected]'? insert into [user](用户名,密码,Email) select 用户名,密码,Email from ..... 在C#用INSERT INTO 语句进行插入数据即可!! 插入后页面中转就行了。插入就是insert语句吗。执行完直接跳转不就行了吗? <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <%String path = request.getContextPath(); String basePath = request.getScheme() + "://"+ request.getServerName() + ":" + request.getServerPort()+ path + "/"; %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <base href=" <%=basePath%>"> <title>My JSP 'login.jsp' starting page </title> </head> <body> <form name="form1" action="login_action.jsp" method="post"> <table width="200" border="1"> <tr> <td colspan="2">登录窗口 </td> </tr> <tr> <td>用户名 </td> <td> <input type="text" name="username" size="10"> </td> </tr> <tr> <td>密码 </td> <td> <input type="password" name="password" size="10"> </td> </tr> <tr> <td colspan="2"> <input type="submit" name="submit" value="登录"> <a href="register.jsp">注册新用户 </a> </td> </tr> </table> </form> </body> </html> 上面是我写的登录表单页面,我在注册页面填写完注册信息之后,用刚注册的信息登录,不能跳转到已经写好的欢迎页面,我使用数据库中已经存在的username:admin,password:admin登录也不行。为什么? ado.net技术 sqlconnection con= new sqlconnection("Server=(local);Integrated Security=SSPI;database=Pubs");sqlcommed cmd=new sqlcommend("insert into [user](用户名,密码,Email) select 用户名,密码,Email from .....",con); <%@ include file="inc.jsp"%><%//get parametersString username = request.getParameter("username");String password = request.getParameter("password");//check nullif (username == null || password == null) { response.sendRedirect("login.jsp");}//validateboolean isValid = false;String sql = "select * from user where username='"+username+"' and password='"+password+"'";try { Class.forName(drv).newInstance(); Connection conn = DriverManager.getConnection(url, usr, pwd); Statement stm = conn.createStatement(); ResultSet rs = stm.executeQuery(sql); if(rs.next())isValid = true; rs.close(); stm.close(); conn.close();} catch (Exception e) { e.printStackTrace(); out.println(e);} finally {}if (isValid) { session.setAttribute("username", username); response.sendRedirect("welcome.jsp");} else { response.sendRedirect("login.jsp");}%>这就是我的登录跳转的jsp,有问题么? 这是SQLSERVER板块,不是JSP板块 这个sql怎么写??/急 SQL多表关联更新 根据数据判断,然后更新 关于exists谓词的问题 什么函数可以计算两个日期之间天数?? 多表查询的问题 触发器中无法操作远程服务器 表连接问题 字符串问题,在线等 大力又要麻烦你了!我是beyondyw在来帮你加分 如何用sql server management studio导出EXCEL(十万火急) 关于数节点查询
SELECT 'USER1','123','[email protected]'
?
插入就是insert语句吗。
执行完直接跳转不就行了吗?
<%String path = request.getContextPath();
String basePath = request.getScheme() + "://"+ request.getServerName() + ":" + request.getServerPort()+ path + "/";
%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href=" <%=basePath%>"> <title>My JSP 'login.jsp' starting page </title> </head> <body>
<form name="form1" action="login_action.jsp" method="post">
<table width="200" border="1">
<tr>
<td colspan="2">登录窗口 </td>
</tr>
<tr>
<td>用户名 </td>
<td> <input type="text" name="username" size="10"> </td>
</tr>
<tr>
<td>密码 </td>
<td> <input type="password" name="password" size="10"> </td>
</tr>
<tr>
<td colspan="2"> <input type="submit" name="submit" value="登录"> <a
href="register.jsp">注册新用户 </a> </td>
</tr>
</table>
</form> </body>
</html>
上面是我写的登录表单页面,我在注册页面填写完注册信息之后,用刚注册的信息登录,不能跳转到已经写好的欢迎页面,我使用数据库中已经存在的username:admin,password:admin登录也不行。为什么?
PI;database=Pubs");
sqlcommed cmd=new sqlcommend("insert into [user](用户名,密码,Email) select 用户名,密码,Email from .....",con);
<%
//get parameters
String username = request.getParameter("username");
String password = request.getParameter("password");//check null
if (username == null || password == null) {
response.sendRedirect("login.jsp");
}//validate
boolean isValid = false;
String sql = "select * from user where username='"+username+"' and password='"+password+"'";
try {
Class.forName(drv).newInstance();
Connection conn = DriverManager.getConnection(url, usr, pwd);
Statement stm = conn.createStatement();
ResultSet rs = stm.executeQuery(sql);
if(rs.next())isValid = true;
rs.close();
stm.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
out.println(e);
} finally {
}if (isValid) {
session.setAttribute("username", username);
response.sendRedirect("welcome.jsp");
} else {
response.sendRedirect("login.jsp");
}
%>
这就是我的登录跳转的jsp,有问题么?