<%@ page contentType="text/html;charest=GB2312"%>
<html>
<body>
<form action="list.jsp"method=post name=from>
<INPUT type="text" name="s1">
<INPUT type="text" name="s2">
<INPUT type="submit" value="确定"name="submit">
</form>
<%
Connection con;
Sratement sql;
ResultSet rs;
try{
Class.forName("com.myqsl.jdbc.Driver");
}
catch(ClassNotFoundException e){}
try{
String url="jdbc;mysql;//localhost_3306/sjy?user=root&password=sjyy&useUnicode=ture&charactEnconding=gb2312";
con=DriverManager.getConnection(url);
sql=con.createStatement();
rs=sql.executeQuery("SELECT*FROM t_user");
string name=request.getparameter("s1");
string psw=request.getparameter("s2");
out.print("<TABLE Border>");
out.print("<TR>");
out.print("<TH width=100>"+"id");
out.print("<TH width=100>"+"name");
out.print("<TH width=100>"+"password");
while(rs.next())
{
if(name==rs.getSring(name)&&psw==rs.getString(psw))
{
while(rs.next())
{
out.print("<TR>");
out.print("<TD>"+rs.getInt(id)+"<TD>");
out.print("<TD>"+rs.getString(name)+"<TD>");
out.print("<TD>"+rs.getString(psw)+"<TD>");
out.print("<TR>");
}
out.print("</TABLE>");
con.close();
}
break;
}
catch(SQLException e1){}
%>
从数据库中提取用户名和密码
然后显示数据库中全部显示
数据库用的mysql
调了半天也不行，求指导呀
楼主纯小白- -希望给个提示
<html>
<body>
<form action="list.jsp"method=post name=from>
<INPUT type="text" name="s1">
<INPUT type="text" name="s2">
<INPUT type="submit" value="确定"name="submit">
</form>
<%
Connection con;
Sratement sql;
ResultSet rs;
try{
Class.forName("com.myqsl.jdbc.Driver");
}
catch(ClassNotFoundException e){}
try{
String url="jdbc;mysql;//localhost_3306/sjy?user=root&password=sjyy&useUnicode=ture&charactEnconding=gb2312";
con=DriverManager.getConnection(url);
sql=con.createStatement();
rs=sql.executeQuery("SELECT*FROM t_user");
string name=request.getparameter("s1");
string psw=request.getparameter("s2");
out.print("<TABLE Border>");
out.print("<TR>");
out.print("<TH width=100>"+"id");
out.print("<TH width=100>"+"name");
out.print("<TH width=100>"+"password");
while(rs.next())
{
if(name==rs.getSring(name)&&psw==rs.getString(psw))
{
while(rs.next())
{
out.print("<TR>");
out.print("<TD>"+rs.getInt(id)+"<TD>");
out.print("<TD>"+rs.getString(name)+"<TD>");
out.print("<TD>"+rs.getString(psw)+"<TD>");
out.print("<TR>");
}
out.print("</TABLE>");
con.close();
}
break;
}
catch(SQLException e1){}
%>
从数据库中提取用户名和密码
然后显示数据库中全部显示
数据库用的mysql
调了半天也不行，求指导呀
楼主纯小白- -希望给个提示
