select.jsp

用JSP做的修改界面 用JSP做的修改界面

<!-- 功能：连接数据库，返回内容给页面。可以修改，并将改后的内容提交给c.jsp
设计者：金鑫
设计时间：2007\12\06 -->
<%@ page contentType="text/html;charset=GBK" import="java.sql.*" %>

<%
String no=request.getParameter("t");
try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection con=DriverManager.getConnection("jdbc:odbc:book");
			Statement st=con.createStatement();
			String sql="select * from tb_user where e_name='"+no+"'";
			ResultSet rs=st.executeQuery(sql);
			while(rs.next())
			{
			String name=rs.getString("e_name");
			String pass=rs.getString("e_pass");
			String xingbie=rs.getString("e_sex");
			String zhenming=rs.getString("e_rname");
			String dizhi=rs.getString("e_addr");
			String dianhua=rs.getString("e_phone");
			String youxiang=rs.getString("e_email");
			%>
			<form action="c.jsp" method="post">
            用&nbsp户&nbsp名:<input type="text" name="t1" value=<%=name%>><p>
            密&nbsp&nbsp&nbsp&nbsp码:<input type="text" name="t2" value=<%=pass%>><p>
            性&nbsp&nbsp&nbsp&nbsp别:<input type="text" name="t3" value=<%=xingbie%>><p>
            真实姓名:<input type="text" name="t4" value=<%=zhenming%>><p>
            地&nbsp&nbsp&nbsp&nbsp址:<input type="text" name="t5" value=<%=dizhi%>><p>
            联系电话:<input type="text" name="t6" value=<%=dianhua%>><p>
            保密邮箱:<input type="text" name="t7" value=<%=youxiang%>><p>
            &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
            <input type="submit" value="修改">
           
            </form>
			<%
			}
             
			con.close();
			st.close();

		}
		catch(Exception e)
		{
			
		}
		  
%>