e.jsp

这个是一个用JSP编写的JSP修改页 这个是一个用JSP编写的JSP修改页

<%@ page contentType="text/html;charset=GBK" import="java.sql.*" %>

<%
String no1=request.getParameter("t");
try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection con=DriverManager.getConnection("jdbc:odbc:zhao");
			Statement st=con.createStatement();
			String sql="select * from tb_user where e_name='"+no1+"'";
			ResultSet rs=st.executeQuery(sql);
			while(rs.next())
			{
			String name=rs.getString("e_name");
			String rname=rs.getString("e_rname");
			String pass=rs.getString("e_pass");
			String phone=rs.getString("e_phone");
			String sex=rs.getString("e_sex");
			String mail=rs.getString("e_mail");
			%>
			<form action="f.jsp" method="post">
            姓&nbsp;&nbsp;&nbsp;&nbsp;名:<input type="text" name="t1" value=<%=name%>>
            <p>
            真实姓名:<input type="text" name="t2" value=<%=rname%>>
             <p>
            密&nbsp;&nbsp;&nbsp;&nbsp;码:<input type="password" name="t3" value=<%=pass%>>
             <p>
            电&nbsp;&nbsp;&nbsp;&nbsp;话:<input type="text" name="t4" value=<%=phone%>>
             <p>
            性&nbsp;&nbsp;&nbsp;&nbsp;别:<input type="text" name="t5" value=<%=sex%>>
             <p>
            电子邮件:<input type="text" name="t6" value=<%=mail%>>
             <p>
            <input type="submit" value="修改">
           
            </form>
			<%
			}
             
			con.close();
			st.close();

		}
		catch(Exception e)
		{
			
		}
		  
%>