zhuce.jsp

来自「asp做的的一个网站登录 连接数据库就可以直接使用了」· JSP 代码 · 共 30 行

JSP
30
字号
<%@ page language="java" import="java.sql.*" pageEncoding="gbk"%>
<html>
  <head>  
    <title></title>
  </head>
  <body>
    <%
    Connection conn=null;
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    String strconn="jdbc:odbc:sun";
    conn=DriverManager.getConnection(strconn,"","");
    String name=request.getParameter("name");
    String pass=request.getParameter("pass");
    Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
    ResultSet rs=stmt.executeQuery("select loginname from login where loginname= '"+name+"'");
    if(rs.next())
	{
	out.println("<center><font color=red size=5>该用户名已经被占用!请重新输入新的用户名!</font></center>");
	response.setHeader("Refresh","3;URL=zhuce.html");
	}
   else
	{
	stmt.executeUpdate("insert into login values ('"+name+"','"+pass+"')" );
	out.println("<center>恭喜您!已经成功注册!您的用户名为:<h2><font color=red>"+name+"</font></h2>请牢记!</center>");
	response.setHeader("Refresh","3;URL=login.html");}
	conn.close();
    %>
  </body>
</html>

⌨️ 快捷键说明

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