关于在同一页面中怎么取参数,谢谢,

麻烦帮我看一下怎么把from表中的用户名uname的值取到sql语句中进行对比,我要查的是有没有重复的名字.
主要是这句怎么写:String sql="select name from user where name='"+uname()+"'";
好像有问题,谢谢,全部代码如下:<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<style type="text/css">
<!--
body,td,th {
color: #333333;
}
body {
background-color: #FFFF99;
}
-->
</style>
<%request.setCharacterEncoding("gb2312");
String name=request.getParameter("name") ;
String userpassword=request.getParameter("userpassword");
String partment=request.getParameter("partment");
String funtion=request.getParameter("funtion");String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\Tomcat4\\webapps\\ROOT\\web1\\web\\db1.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection(url);
Statement st=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String uname=request.getParameter("name");
String sql="select name from user where name='"+uname()+"'";
ResultSet rs=st.executeQuery(sql);
//if(rs.next())
//out.print("<center>用户名重名");
//else
%>
<script language="javascript">
function on_submit()
{ 
if (form1.name.value=="")
{
alert("用户名不能为空,请输入用户名!")
form1.name.focus();
return false; 
}<script language="javascript">
function on_submit()
{ 
if (form1.name.value=="")
{
alert("用户名不能为空,请输入用户名!")
form1.name.focus();
return false; 
}
if (form1.userpassword.value=="")
{
alert("密码不能为空,请输入密码!")
form1.userpassword.focus();
return false;
}
if (form1.reuserpassword.value=="")
{
alert("确认密码不能为空,请输入密码!")
form1.reuserpassword.focus();
return false;
}
if (form1.userpassword.value!=form1.reuserpassword.value)
{
alert("密码与确认密码不相同")
form1.reuserpassword.focus();
return false;
}
if (form1.name.value!=rs.getstring(1))
{
alert("用户名重复")
form1.reuserpassword.focus();
return false;
}}
</script>
</head>
<body>
  <form name="form1" method="post" action="userregist.jsp" onsubmit="return on_submit()">
<table width="734" height="247" border="0">
  <tr>
    <td width="127" height="243">&nbsp;</td>
    <td width="472" valign="top"><table width="472" border="0">
      <tr>
  
        <td height="69" colspan="2">&nbsp;</td>
        </tr>
      <tr>

        <td width="75" height="21" align="center" nowrap="nowrap">用&nbsp;户&nbsp;名</td>
        <td width="383" height="20" align="left"><input type="text" name="uname" /></td>
      </tr>
      <tr>
        <td width="75" height="25" align="center">密&nbsp;&nbsp; 码</td>
        <td height="20" align="left">
          <input type="password" name="userpassword" ></td>
      </tr>
   <tr>
        <td width="75" height="25" align="center" nowrap="nowrap">密码确认</td>
        <td height="20" align="left">
          <input type="password" name="reuserpassword" ></td>
      </tr>
      <tr>
        <td width="75" height="22" align="center" valign="middle">部&nbsp;&nbsp; 门</td>
        <td height="20" align="left"><select name="partment">
          <option>办公室</option>
          <option>人教育科</option>
          <option>征收管理科</option>
          <option>税政科</option>
          <option>计征科</option>
          <option>信息中心</option>
          <option>稽查局</option>
          <option>双江分局</option>
        </select></td>
      </tr>
      <tr>
        <td width="75" height="20" align="center">职 &nbsp;&nbsp;务</td>
        <td align="left"><select name="funtion">
          <option>局长 </option>
          <option>副局长</option>
          <option>科长</option>
          <option>副科长</option>
          <option>主任</option>
          <option>副主任</option>
          <option>国税干部&nbsp;&nbsp;</option>
        </select></td>
      </tr>
      <tr>
        <td height="29" align="center">&nbsp;</td>
        <td align="left" valign="top"><table width="80" border="0">
          <tr>
            <td width="90" height="23" align="center"><input type="submit" name="Submit" value="提交" /></td>
            <td width="315"><input type="reset" name="Submit2" value="重置" /></td>
          </tr>
        </table></td>
      </tr>
    </table></td>
    <td width="121">&nbsp;</td>
  </tr>
</table>
</form>
<% st.close();
con.close();
%>
</body>
</html>

解决方案 »

  1.   

    <input type="text" name="uname" />String name=request.getParameter("uname") ;String sql="select name from user where name='"+name+"'";大概是这么个意思，但楼主的代码差得太远了，问题千出百出。
      

  2.   

    <%
    request.setCharacterEncoding("gb2312");
    String username=request.getParameter("uname") ;String sql="select name from user where name='"+username+"'";%><td width="383" height="20" align="left"><input type="text" name="uname"></td>
      

  3.   

    现在改成这样了,可是重复用户为什么不能判断,帮我看一下这一句在代码中有没有问题.表里用户名为name.if (form1.name.value!=rs.getstring(name))
    {
    alert("用户名重复")
    form1.name.focus();
    return false;
    }<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
    <title>无标题文档</title>
    <style type="text/css">
    <!--
    body,td,th {
    color: #333333;
    }
    body {
    background-color: #FFFF99;
    }
    -->
    </style>
    <%request.setCharacterEncoding("gb2312");
    String username=request.getParameter("name") ;
    String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\Tomcat4\\webapps\\ROOT\\web1\\web\\db1.mdb";
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    Connection con=DriverManager.getConnection(url);
    Statement st=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);String sql="select name from user where name='"+username+"'";
    ResultSet rs=st.executeQuery(sql);
    //if(rs.next())
    //out.print("<center>用户名重名");
    //else
    %>
    <script language="javascript">
    function on_submit()
    { 
    if (form1.name.value=="")
    {
    alert("用户名不能为空,请输入用户名!")
    form1.name.focus();
    return false; 
    }<script language="javascript">
    function on_submit()
    { 
    if (form1.name.value=="")
    {
    alert("用户名不能为空,请输入用户名!")
    form1.name.focus();
    return false; 
    }
    if (form1.userpassword.value=="")
    {
    alert("密码不能为空,请输入密码!")
    form1.userpassword.focus();
    return false;
    }
    if (form1.reuserpassword.value=="")
    {
    alert("确认密码不能为空,请输入密码!")
    form1.reuserpassword.focus();
    return false;
    }
    if (form1.userpassword.value!=form1.reuserpassword.value)
    {
    alert("密码与确认密码不相同")
    form1.reuserpassword.focus();
    return false;
    }
    if (form1.name.value!=rs.getstring(name))
    {
    alert("用户名重复")
    form1.name.focus();
    return false;
    }}
    </script>
    </head>
    <body>
      <form name="form1" method="post" action="userregist.jsp" onsubmit="return on_submit()">
    <table width="734" height="247" border="0">
      <tr>
        <td width="127" height="243">&nbsp;</td>
        <td width="472" valign="top"><table width="472" border="0">
          <tr>
      
            <td height="69" colspan="2">&nbsp;</td>
            </tr>
          <tr>

            <td width="75" height="21" align="center" nowrap="nowrap">用&nbsp;户&nbsp;名</td>
            <td width="383" height="20" align="left"><input type="text" name="name" /></td>
          </tr>
          <tr>
            <td width="75" height="25" align="center">密&nbsp;&nbsp; 码</td>
            <td height="20" align="left">
              <input type="password" name="userpassword" ></td>
          </tr>
       <tr>
            <td width="75" height="25" align="center" nowrap="nowrap">密码确认</td>
            <td height="20" align="left">
              <input type="password" name="reuserpassword" ></td>
          </tr>
          <tr>
            <td width="75" height="22" align="center" valign="middle">部&nbsp;&nbsp; 门</td>
            <td height="20" align="left"><select name="partment">
              <option>办公室</option>
              <option>人教育科</option>
              <option>征收管理科</option>
              <option>税政科</option>
              <option>计征科</option>
              <option>信息中心</option>
              <option>稽查局</option>
              <option>双江分局</option>
            </select></td>
          </tr>
          <tr>
            <td width="75" height="20" align="center">职 &nbsp;&nbsp;务</td>
            <td align="left"><select name="funtion">
              <option>局长 </option>
              <option>副局长</option>
              <option>科长</option>
              <option>副科长</option>
              <option>主任</option>
              <option>副主任</option>
              <option>国税干部&nbsp;&nbsp;</option>
            </select></td>
          </tr>
          <tr>
            <td height="29" align="center">&nbsp;</td>
            <td align="left" valign="top"><table width="80" border="0">
              <tr>
                <td width="90" height="23" align="center"><input type="submit" name="Submit" value="提交" /></td>
                <td width="315"><input type="reset" name="Submit2" value="重置" /></td>
              </tr>
            </table></td>
          </tr>
        </table></td>
        <td width="121">&nbsp;</td>
      </tr>
    </table>
    </form>
    <% st.close();
    con.close();
    %>
    </body>
    </html>