add.jsp

来自「jsp做的一个个人网站」· JSP 代码 · 共 29 行

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" errorPage=""%>
<%
//String yonghuming=request.getParameter("name");

request.setCharacterEncoding("gb2312");
String username=request.getParameter("name");
String password=request.getParameter("pwd");
String gender=request.getParameter("radiobutton");
String info=request.getParameter("textarea");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:test","sa","sa");
String sq="select * from gly where name='"+username+"'";
Statement set=con.createStatement();
ResultSet rs=set.executeQuery(sq);
//set.executeQuery(sq);

if(rs.next())
{ //if(username.equals(rs.getString("name")))
 out.print("<script> {alert('该用户名已经存在，请重新选择用户名！');window.open('regist.jsp','_self') }</script>");}
 else
{String sql="insert into gly(name,password,sex,sign_text) values('"+username+"','"+password+"','"+gender+"','"+info+"')";
//out.print(sql);
Statement st=con.createStatement();
st.executeUpdate(sql);
con.close();
out.print("注册成功！");}

%>
<a href="index.jsp">返回首页</a>