用户注册时,往数据库插入数据,怎么用preparedstatement查询我刚插入的数据并显示出来?
<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.Date" %>
<html>
<head><title>用户注册成功</title></head>
<body>
<%@ include file="convert.jsp" %>
<%
Connection conn=null;
try
{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String strConn="jdbc:sqlserver://localhost:1433;DatabaseName=ShopSystem";
String strUser="sa";
String strPassword="123456";
conn=DriverManager.getConnection(strConn,strUser,strPassword);
String a_name=Bytes(request.getParameter("a_name"));
String a_pass=Bytes(request.getParameter("a_pass"));
String a_header=Bytes(request.getParameter("a_header"));
String a_phone=Bytes(request.getParameter("a_phone"));
String a_email=Bytes(request.getParameter("a_email"));
String strSql="insert into admin values(?,?,?,?,?)";
PreparedStatement pstmt=conn.prepareStatement(strSql);
pstmt.setString(1,a_name);
pstmt.setString(2,a_pass);
pstmt.setString(3,a_header);
pstmt.setString(4,a_phone);
pstmt.setString(5,a_email);
int intTemp=pstmt.executeUpdate();
if(intTemp!=0)
{
out.println( "<center><h3>" + "用户注册成功" + "</h3></center>");
}
else
{
out.println( "<center><h3>" + "用户注册失败" + "</h3></center>");
}
String strSql2="SELECT TOP 1 a_name,a_pass,a_header,a_phone,a_email FROM admin WHERE a_name=? order by a_email desc";
PreparedStatement pstmt2=conn.prepareStatement(strSql2);
pstmt2.setString(1,"red");
ResultSet rs=pstmt2.executeQuery();
%>
<table border="1" align="center">
<tr>
<th>用户名称</th>
<th>用户密码</th>
<th>用户头像</th>
<th>联系电话</th>
<th>用户邮箱</th>
</tr>
<%while(rs.next()){%>
<tr bgcolor="lightblue">
<td><%=rs.getString("a_name") %></td>
<td><%=rs.getString("a_pass") %></td>
<td><%=rs.getString("a_header") %></td>
<td><%=rs.getString("a_phone") %></td>
<td><%=rs.getString("a_email") %></td>
</tr>
<% }%>
</table>
<%
pstmt.close();
pstmt2.close();
conn.close();
}
catch(Exception e)
{
out.println(e.toString());
}
%>
</body>
</html>
用户注册时,往数据库插入数据,怎么用preparedstatement查询我刚插入的数据并显示出来?
求大神!!!!!
<%@ page import="java.sql.*" %>
<%@ page import="java.util.Date" %>
<html>
<head><title>用户注册成功</title></head>
<body>
<%@ include file="convert.jsp" %>
<%
Connection conn=null;
try
{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String strConn="jdbc:sqlserver://localhost:1433;DatabaseName=ShopSystem";
String strUser="sa";
String strPassword="123456";
conn=DriverManager.getConnection(strConn,strUser,strPassword);
String a_name=Bytes(request.getParameter("a_name"));
String a_pass=Bytes(request.getParameter("a_pass"));
String a_header=Bytes(request.getParameter("a_header"));
String a_phone=Bytes(request.getParameter("a_phone"));
String a_email=Bytes(request.getParameter("a_email"));
String strSql="insert into admin values(?,?,?,?,?)";
PreparedStatement pstmt=conn.prepareStatement(strSql);
pstmt.setString(1,a_name);
pstmt.setString(2,a_pass);
pstmt.setString(3,a_header);
pstmt.setString(4,a_phone);
pstmt.setString(5,a_email);
int intTemp=pstmt.executeUpdate();
if(intTemp!=0)
{
out.println( "<center><h3>" + "用户注册成功" + "</h3></center>");
}
else
{
out.println( "<center><h3>" + "用户注册失败" + "</h3></center>");
}
String strSql2="SELECT TOP 1 a_name,a_pass,a_header,a_phone,a_email FROM admin WHERE a_name=? order by a_email desc";
PreparedStatement pstmt2=conn.prepareStatement(strSql2);
pstmt2.setString(1,"red");
ResultSet rs=pstmt2.executeQuery();
%>
<table border="1" align="center">
<tr>
<th>用户名称</th>
<th>用户密码</th>
<th>用户头像</th>
<th>联系电话</th>
<th>用户邮箱</th>
</tr>
<%while(rs.next()){%>
<tr bgcolor="lightblue">
<td><%=rs.getString("a_name") %></td>
<td><%=rs.getString("a_pass") %></td>
<td><%=rs.getString("a_header") %></td>
<td><%=rs.getString("a_phone") %></td>
<td><%=rs.getString("a_email") %></td>
</tr>
<% }%>
</table>
<%
pstmt.close();
pstmt2.close();
conn.close();
}
catch(Exception e)
{
out.println(e.toString());
}
%>
</body>
</html>
用户注册时,往数据库插入数据,怎么用preparedstatement查询我刚插入的数据并显示出来?
求大神!!!!!
...全文
相关推荐
jsp实现用户的注册并连接数据库将注册信息显示出来
用myeclipse实现一个注册界面,并连接数据库将注册的信息显示出来
java 连接sqlserver数据库查询,并分页显示
java 连接sqlserver数据库查询,并分页显示
Android实现查询数据库,把数据库内容显示到屏幕
Android实现查询数据库,把数据库内容显示到屏幕
linux下c语言sqlite3数据库用户注册登录并查询字典
本例是在linux下,利用c语言操作sqlite3数据库,将文本字典插入数据库。用户需要注册登录再查询字典。
PreparedStatement 向数据库插入时间方法
在java中向访问数据库的sql语句一般放到类PreparedStatement类构造函数中,这里遇到的问题就是向sql语句中用setDate()插入时间时不能用java.util.date,而应用java.sql.date,这里就讲述了解决方法,一种是插入日期,一种是插入时期时间。


