⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 mysql

📁 有关mysql文章教程,本人收集的一些有关mysql文章教程
💻
字号:
🔍 
<HTML><HEAD><TITLE>锋网ijsp.net-Mysql字段长度</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<LINK href="../../../inc/book.css" type=text/css rel=stylesheet>
<META content="MSHTML 5.50.4134.600" name=GENERATOR></HEAD>
<BODY text=#000000 bgColor=#ffffff leftMargin=0 topMargin=0 MARGINHEIGHT="0" 
MARGINWIDTH="0">
<style type="text/css">
.f14 {font-size:14px}
</style>
<script language="JavaScript">
function doZoom(size){
	document.getElementById('zoom').style.fontSize=size+'px'
	setTailPosition()
}

function doPrint(){
var str="<html>\n<meta http-equiv='content-type' content='text/html; charset=gb2312'>";
var article;
var css;
var strAdBegin="<!--SPORTSZW_HZH_BEGIN-->";
var strAdEnd="<!--SPORTSZW_HZH_END-->";
var strFontSize='【<A href="javascript:doZoom(16)">大</A> <A href="javascript:doZoom(14)">中</A> <A href="javascript:doZoom(12)">小</A>】'
var strdoPrint="doPrint()";
var strTmp;

	css="<style>"
	+"body{font-family:宋体}"
	+"td,.f12{font-size:12px}"+".f24 {font-size:24px;}"
	+".f14 {font-size:14px;}"
	+".title14 {font-size:14px;line-height:130%}"
	+".l17 {line-height:170%;}"
	+".x14 {font-size:14px;line-height:130%}"
	+".font14b {font-family: '宋体';	font-size: 14px; color: #000000;}"
	+"</style>";

	str +=	css;
	str +=	'<meta http-equiv="content-type" content="text/html; charset=gb2312">';
	str +=	'<title>'+document.title+'</title>';
	str +=	"<body bgcolor=#ffffff topmargin=5 leftmargin=5 marginheight=5 marginwidth=5 onLoad='window.print()'>";
	str +=	"<center><table width=600 border=0 cellspacing=0 cellpadding=0><tr><td valign=bottom><font color=#0000ff><a href=\"../../../index.htm\">首页</A> &gt; <a href=\"../../../list?id=2\">教程</a> &gt; <a href=\"../../../slist?id=6\">数据库</a> &gt; &nbsp;正文</font></td><td align=right valign=bottom><a href='javascript:history.back()'>返回</a>　<a href='javascript:window.print()'>打印</a></td></tr></table>"
	str +=	"<table width=600 border=0 cellpadding=0 cellspacing=20 bgcolor=#ffffff><tr><td>";
	
	article=document.getElementById('article').innerHTML;
	if(article.indexOf(strAdBegin)!=-1){
		str +=article.substr(0,article.indexOf(strAdBegin));
		strTmp=article.substr(article.indexOf(strAdEnd)+strAdEnd.length, article.length);
	}else{
		strTmp=article
	}
	str +=strTmp
	str += window.location.href
	str +=	"</td></tr></table></center>";
	str +=	"</body></html>";
	document.write(str);
	document.close();
}
</script>
<script src="../../../inc/header1.js"></script>
<TABLE cellSpacing=0 cellPadding=0 width="100%" align=center border=0>
  <TBODY>
  <TR>
    <TD vAlign=top width=170 bgColor=#a6c0f5>
      <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
        <TBODY>
        <TR>
          <TD><IMG height=5 
            src="../../../images/s.gif" 
            width=170></TD></TR></TBODY></TABLE>
<script src="../../../inc/search1.js"></script>      <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
        <TBODY>
        <TR>
          <TD><IMG height=5 
            src="../../../images/s.gif" 
            width=1></TD></TR></TBODY></TABLE></TD>
    <TD width=1 bgColor=#6386de><IMG height=1 
      src="../../../images/s.gif" 
      width=1></TD>
    <TD vAlign=top>
      <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
        <TBODY>
        <TR>
          <TD><IMG height=1 
            src="../../../images/s.gif" 
            width=549></TD></TR></TBODY></TABLE>
      <TABLE cellSpacing=5 cellPadding=0 width="100%" border=0>
        <TBODY>
        <TR>
          <TD>当前位置：&gt; <a href="../../../index.htm">首页</A> &gt; <a href="../../../list?id=2">教程</a> &gt; <a href="../../../slist?id=6">数据库</a>  &gt; 正文
          </TD></TR></TBODY></TABLE>
      <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
        <TBODY>
        <TR>
          <TD background="../../../images/wlinebg.gif" 
            bgColor=#808080><IMG height=1 
            src="../../../images/s.gif" 
            width=1></TD></TR></TBODY></TABLE>
      <TABLE cellSpacing=0 cellPadding=0 width="100%" align=center border=0>
        <TBODY>
        <TR>
          <TD><IMG height=5 
            src="../../../images/s.gif" 
            width=1></TD></TR></TBODY></TABLE>
	<div id=article>
      <TABLE cellSpacing=0 cellPadding=5 width="100%" bgColor=#eeeeee 
        border=0><TBODY>
        <TR>
          <TD align=middle><font class=font14b>Mysql字段长度</a></TD></TR></TBODY></TABLE>
      <TABLE cellSpacing=5 cellPadding=0 width="100%" border=0>
        <TBODY>
        <TR>
          <TD vAlign=top width=100%><font id="zoom" class=f14>如何混合使用Jsp和SSI #include? <br>在JSP中可以使用如下方式包含纯HTML： <br>&lt;!--#include file="data.inc"--&gt; <br>但是如果data.inc中包含JSP CODE ，我们可以使用： <br>&lt;%@include file="data.inc"%&gt; <br><br><br>如何执行一个线程安全的JSP? <br>只需增加如下指令 <br>&lt;%@ page isThreadSafe="false" %&gt; <br><br><br>JSP如何处理HTML FORM中的数据? <br>通过内置的request对象即可，如下： <br>&lt;% <br>String item = request.getParameter("item"); <br>int howMany = new Integer(request.getParameter("units")).intValue(); <br>%&gt; <br><br><br>在JSP如何包含一个静态文件? <br>静态包含如下：&lt;%@ include file="copyright.html" %&gt; <br>动态包含如下：&lt;jsp:include page="copyright.html" flush="true"/&gt; <br><br><br>在JSP中如何使用注释? <br>主要有四中方法： <br>1。&lt;%-- 与 --%&gt; <br>2。// <br>3。/**与**/ <br>4。&lt;!--与--&gt; <br><br><br>在JSP中如何执行浏览重定向? <br>使用如下方式即可：response.sendRedirect("http://ybwen.home.chinaren.com/index.html"); <br>也能物理地改变HTTP HEADER属性，如下： <br>&lt;% <br>response.setStatus(HttpServletResponse.SC_MOVED_PERMANENTLY); <br>String newLocn="/newpath/index.html"; <br>response.setHeader("Location",newLocn); <br>%&gt; <br><br><br>如何防止在JSP或SERVLET中的输出不被BROWSER保存在CACHE中? <br>把如下脚本加入到JSP文件的开始即可： <br>&lt;% <br>response.setHeader("Cache-Control","no-store"); //HTTP 1.1 <br>response.setHeader("Pragma","no-cache"); //HTTP 1.0 <br>response.setDateHeader ("Expires", 0); //prevents caching at the proxy server <br>%&gt; <br><br><br>在JSP中如何设置COOKIE? <br>COOKIE是作为HTTP HEADER的一部分被发送的，如下方法即可设置： <br>&lt;% <br>Cookie mycookie = new Cookie("aName","aValue"); <br>response.addCookie(mycookie); <br>%&gt; <br><br><br>在JSP中如何删除一个COOKIE? <br>&lt;% <br>Cookie killMyCookie = new Cookie("mycookie", null); <br>killMyCookie.setMaxAge(0); <br>killMyCookie.setPath("/"); <br>response.addCookie(killMyCookie); <br>%&gt; <br><br><br>在一个JSP的请求处理中如何停止JSP的执行 <br>如下例： <br>&lt;% <br>if (request.getParameter("wen") != null) { <br>// do something <br>} else { <br>return; <br>} <br>%&gt; <br><br><br>在JSP中如何定义方法 <br>你可以定义方法，但是你不能直接访问JSP的内置对象，而是通过参数的方法传递。如下： <br>&lt;%! <br>public String howBadFrom(HttpServletRequest req) { <br>HttpSession ses = req.getSession(); <br>... <br>return req.getRemoteHost(); <br>} <br>%&gt; <br>&lt;% <br>out.print("in general,lao lee is not baddie "); <br>%&gt; <br>&lt;%= howBadFrom(request) %&gt; <br><br><br>如果BROWSER已关闭了COOKIES，在JSP中我如何打开SESSION来跟踪 <br>使用URL重写即可，如下： <br>hello1.jsp <br>&lt;%@ page session="true" %&gt; <br>&lt;% <br>Integer num = new Integer(100); <br>session.putValue("num",num); <br>String url =response.encodeURL("hello2.jsp"); <br>%&gt; <br>&lt;a href='&lt;%=url%&gt;'&gt;hello2.jsp&lt;/a&gt; <br><br>hello2.jsp <br>&lt;%@ page session="true" %&gt; <br>&lt;% <br>Integer i= (Integer )session.getValue("num"); <br>out.println("Num value in session is "+i.intValue()); <br>%&gt; <br><br><br>在JSP中能发送EMAIL吗 <br>可以使用SUN的专用包：sun.net.smtp包。如下脚本使用SmtpClient类发送EMAIL。 <br>&lt;%@ page import="sun.net.smtp.SmtpClient, java.io.*" %&gt; <br>&lt;% <br>String from="ybwen@sina.com"; <br>String to="hewenjun@yeah.net, lei@who.com.cn"; <br>try{ <br>SmtpClient client = new SmtpClient("mail.xxxxx.xxx"); <br>client.from(from); <br>client.to(to); <br>PrintStream message = client.startMessage(); <br>message.println("To: " + to); <br>message.println("Subject: Sending email from JSP!"); <br>message.println("This was sent from a JSP page!"); <br>message.println(); <br>message.println("Cool! :-)"); <br>message.println(); <br>message.println("Good Boy"); <br>message.println("I'm in genius.com"); <br>message.println(); <br>client.closeServer(); <br>} <br>catch (IOException e){ <br>System.out.println("ERROR SENDING EMAIL:"+e); <br>} <br>%&gt; <br><br><br>在SERVLET中我能调用一个JSP错误页吗 <br>当然没问题，如下展示了如何在一个SERVLET控制逻辑单元内调用一个JSP错误页面。 <br>protected void sendErrorRedirect(HttpServletRequest request, <br>HttpServletResponse response, String errorPageURL, <br>Throwable e) <br>throws ServletException, IOException { <br>request.setAttribute ("javax.servlet.jsp.jspException", e); <br>getServletConfig().getServletContext(). <br>getRequestDispatcher(errorPageURL).forward(request, <br>response); <br>} <br><br>public void doPost(HttpServletRequest request,HttpServletResponse response) { <br>try { <br>// do something <br>} catch (Exception ex) { <br>try { <br>sendErrorRedirect(request,response,"/jsp/MyErrorPage.jsp",ex); <br>} catch (Exception e) { <br>e.printStackTrace(); <br>} <br>} <br>} <br><br><br>JSP和APPLET如何通讯 <br>JSP如何与EJB SessionBean通讯 <br>下面的代码段作了很好的示范 <br>&lt;%@ page import="javax.naming.*, javax.rmi.PortableRemoteObject, <br>foo.AccountHome, foo.Account" %&gt; <br>&lt;%! <br>//定义一个对SessionBeanHome接口实例的全局引用 <br>AccountHome accHome=null; <br><br>public void jspInit() { <br>//获得Home接口实例 <br>InitialContext cntxt = new InitialContext( ); <br>Object ref= cntxt.lookup("java:comp/env/ejb/AccountEJB"); <br>accHome = (AccountHome)PortableRemoteObject.narrow(ref,AccountHome.class); <br>} <br>%&gt; <br>&lt;% <br>//实例化SessionBean <br>Account acct = accHome.create(); <br>//调用远程方法 <br>acct.doWhatever(...); <br>// 如此等等 <br>%&gt; <br><br><br>当我使用一个结果集时，如何防止字段为"null"的字域显示在我的HTML输入文本域中? <br>可以定义一个简单的函数来达到目的，如下： <br>&lt;%! <br>String blanknull(String s) { <br>return (s == null) ? "" : s; <br>} <br>%&gt; <br><br>然后在JSP的FORM中，可以这样使用 <br>&lt;input type="text" name="shoesize" value="&lt;%=blanknull(shoesize)%&gt;"&gt; <br><br><br>如何中SERVLET或JSP下载一个文件（如：binary,text,executable)？ <br>现提供两个解决方案： <br>A：使用HTTP，如 <br>点击下载网络恐龙图片(这个地址是假的） <br><br>B：在Servlet中，通过设置ContentType和使用java.io包的Stream等类可作到.例如： <br>response.setContentType("application/x-msword"); <br>然后想输出缓冲中写一些东东即可。 <br><br>使用useBean标志初始化BEAN时如何接受初始化参数 <br>使用如下两标签即可： <br>&lt;jsp:getProperty name="wenBean" property="someProperty"/&gt; <br>&lt;jsp:setProperty name="wenBean" property="someProperty" value="someValue"/&gt; <br> <br><br><br><br>摘自：www.netsword.net<!--##Original##--></font></TD></TR></TBODY></TABLE>
		 </div>
	  <table cellSpacing=5 cellPadding=0 width="100%" border=0>
		  <tr><td align="right">[<a href="javascript:doPrint()">打印</a>]
[<a href="javascript:doZoom(16)">大</a> <a href="javascript:doZoom(14)">中</a> <a href="javascript:doZoom(12)">小</a>]</td>
		  </TR>
		  </table>
<br>


<center>
<!-- 相关链接 begin -->
<table width=89% border=0 cellspacing=0 cellpadding=1 >
 <tr><td>
 <table width=100% border=0 cellspacing=0 cellpadding=0><tr><td bgcolor=#dedede><table width=100% border=0 cellspacing=1 cellpadding=3>
<tr><td bgcolor=#EDF0F5>　相关链接</td></tr>
<tr><td bgcolor=#EDF0F5>
没有相关内容。
</td></tr>
</table></td></tr></table>
</td></tr>
</table>
<!-- 相关链接 end -->
<br>
</center>
</td></tr></table>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
  <TBODY>
  <TR>
    <TD bgColor=#6386de><IMG height=3 src="../../../images/s.gif" 
      width=770></TD></TR>
  <TR>
    <TD bgColor=#bdd3f7><IMG height=3 src="../../../images/s.gif" 
      width=1></TD></TR>
  <TR>
    <TD>
      <TABLE cellSpacing=10 cellPadding=0 width="100%" border=0>
        <TBODY>
        <TR>
          <TD align="center"><script src="../../../inc/copyright.js"></script><script src="../../../counter/newscounter.jsp?id=93"></script></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
</BODY></HTML>

⌨️ 快捷键说明

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