📄 saysucc.jsp

📁 一个小程序
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.util.*" %>
<%@page import="java.sql.*"%>

<body background="images/bg1.gif" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<TABLE cellSpacing=1 cellPadding=3 width=75% align=center border=0>
  <TR align=middle background="images/bg_menu.gif"> 
    <TD width="20%" align="left" nowrap> &nbsp;&nbsp; </TD>
    <TD width="20%" nowrap>&nbsp;</TD>
    <TD width="20%" nowrap>&nbsp;</TD>
    <TD width="20%" nowrap>&nbsp; </TD>
    <TD width="20%" nowrap>&nbsp;</TD>
  </TR>
</TABLE>
<TABLE height=76 cellSpacing=0 cellPadding=0 width=75% align=center 
  border=0>
  <TR> 
    <TD><TABLE height=72 cellSpacing=0 cellPadding=0 width="100%" align=center 
      bgColor=#ffffff border=0>
        <TR> 
          <TD width="200" align="center"><img src="images/logo.gif" width="200" height="80"></TD>
          <TD align=right><img 
            src="images/login.gif" width="154" height="60" 
            border=0> </TD>
        </TR>
      </TABLE></TD>
  </TR>
</TABLE>
<table width="75%" align="center" cellpadding="0" cellspacing="0" background="images/index-t.gif">
  <tr> 
    <td width="5%" align="left"> 
   
    </td>
    <td height="22" align="left">&nbsp;</td>
  </tr>
</table>
<table width="75%" border="0" align="center" cellpadding="2" cellspacing="2">
  <tr bgcolor="#FFFFFF"> 
    <td width="27%"> 
      <%
	  
String name=request.getParameter("name");
String sex=request.getParameter("sex");
String www=request.getParameter("www");
String oicq=request.getParameter("oicq");
String email=request.getParameter("email");
String memo=request.getParameter("memo");
String face=request.getParameter("face");

		String DBDriver="Sun.jdbc.odbc.JdbcOdbcDriver";
		String ConnStr="jdbc:odbc:index";

String sql="insert into liuyan(name,sex,www,email,oicq,memo,face) values ('"+name+"','"+sex+"','"+www+"','"+email+"','"+oicq+"','"+memo+"','"+face+"')"; 
try	
		{
			Class.forName(DBDriver);//加载JDBC驱动程序
		}
	catch(java.lang.ClassNotFoundException e)
		{
			System.err.println("database:"+e.getMessage());
			//out.println("驱动没有加载");
		}

	try
		{
			Connection conn=DriverManager.getConnection(ConnStr," "," ");
			
			Statement stmt=conn.createStatement();
	
			stmt.executeUpdate(sql);
			
			//out.println("您已经注册成功! "+"<br>");
			stmt.close();
			conn.close();
		}
	catch(SQLException e)
		{
			System.err.println("executeUpdate:"+e.getMessage());
			out.println("数据没有写入");
		}

%> </td>
    <td width="44%">&nbsp;</td>
    <td width="29%"> </td>
  </tr>
  <tr bgcolor="#FFFFFF"> 
    <td width="27%">&nbsp;</td>
    <td width="44%"> 
      <div align="center">感谢您对本网站的支持！&nbsp;</div></td>
    <td width="29%">&nbsp;</td>
  </tr>
  <tr bgcolor="#FFFFFF"> 
    <td>&nbsp;</td>
    <td>&nbsp; </td>
    <td>&nbsp;</td>
  </tr>
  <tr bgcolor="#FFFFFF"> 
    <td>&nbsp;</td>
    <td> 
      <div align="center">&nbsp;<a href="liuyanindex.jsp"><img src="images/read.jpg" width="50" height="49" border="0"></a></div></td>
    <td>&nbsp;</td>
  </tr>
</table>
<table width="75%" border="0" align="center" cellpadding="2" cellspacing="2" background="images/bg_menu.gif">
  <tr> 
    <td width="27%">&nbsp;</td>
    <td width="73%">&nbsp;</td>
  </tr>
</table>
</body>
</html>
⌨️ 快捷键说明

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