byname.jsp.bak

来自「可以让初学者有一个感性的认识」· BAK 代码 · 共 52 行

BAK
52
字号

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

<BODY bgcolor=cyan><Font size=3>
<%		
	String name=request.getParameter("name");;
	if(name==null)name="";
	byte b[]=name.getBytes("ISO-8859-1");
	name=new String(b);

	Connection con=null;
	Statement sql=null;
	ResultSet rs=null;

	try
	{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	}catch(ClassNotFoundException e){}

	try
	{
		con=DriverManager.getConnection("jdbc:odbc:shop","","");
		sql=con.createStatement();
		String condition="SELECT * FROM user WHERE logname="+"'"+name+"'";
		rs=sql.executeQuery(condition);
		out.print("<Table Border>");
			out.print("<TR>");
				out.print("<TH width=100>"+"logname");
				out.print("<TH width=100>"+"realname");
				out.print("<TH width=50>" +"email");
				out.print("<TH width=50>" +"phone");
				out.print("<TH width=50>" +"address");
			out.print("</TR>");
			while(rs.next())
			{
				out.print("<TR>");
					out.print("<TD>"+ rs.getString(1)+"</TD>");
					out.print("<TD>"+ rs.getString(2)+"</TD>");
					out.print("<TD>"+ rs.getString(4)+"</TD>");
					out.print("<TD>"+ rs.getString(5)+"</TD>");
					out.print("<TD>"+ rs.getString(6)+"</TD>");
				out.print("</TR>");
			}
		out.print("</Table>");
		con.close();
	}catch(SQLException e1){out.print(e1);}
%>

</FONT>
</BODY>
</HTML>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?