登录时连接了数据库,输入相应的用户名和密码就可以进入,我要怎么在个人信息页面显示该账号的相关资料呢?(数据库内有id、mima、dz、sc等其他字段,我想要都显示)
数据库代码
use dsj;
create table T_by(
id varchar(50) not null primary key,
mima varchar(50) not null
dz varchar(200),
sc varchar(200)
)default charset=utf8;
登录界面的
<form action="yhdl.jsp" method="post">
<form name="form1" onSubmit="return check()">
用户名:<input type="text" name="id" id="id"><br/><br/>
密码:<input name="mima" type="password" /><br/>
</div>
用户名:<input type="text" />
密码:<input type="password" name="mima" />
验证是否登录成功的
<%
request.setCharacterEncoding("UTF-8");
String userName=request.getParameter("id");
String password=request.getParameter("mima");
String pid=request.getParameter("id");
String pmima=request.getParameter("mima");
try{
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/sjk", "root", "433124");
String Sql="select * from T_by where id=?";
PreparedStatement ps=conn.prepareStatement(Sql);
ps.setString(1,userName);
ResultSet rs=ps.executeQuery();
rs.next();
String str=rs.getString("mima");
System.out.print(str);
if((rs.getString("mima")).equals(password)){
request.getRequestDispatcher("sy.jsp").forward(request, response);
}
ps.close();
conn.close();
}catch(Exception e) {
out.print("");
e.printStackTrace();
}
%>
<div class="g">
用户名或密码错误,<a href="index.jsp">请重新登录</a>
</div>
我想在主页面个人信息那里点击后就出现该账号相关的数据库资料,麻烦各位帮帮忙