<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ page language="Java" contentType="text/html; charset=gb2312"%>
<%@ page import="java.sql.*,java.io.*,java.util.*"%>
<%String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\Tomcat\\webapps\\ROOT\\myApp\\msgcenter.mdb"; //指定的建立的.mdb文件的位置
Connection conn = null;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(Exception ex){}
boolean lflag = false;
try{
conn=DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
/*一下用来获取你前一个注册页面的值*/
String subject = request.getParameter("content");
String answer = request.getParameter("answer");
String guest = "guest";
String sql = "insert into User(Name,Password,type) values('sys','sys',0)";
stmt.executeUpdate(sql); //插入数据库!
lflag = true;
%>
<!--<BR>
<BR>
<center>
<font size = "3" face = "Arial" color = "#226699"> <strong>Ìí¼Ó³É¹¦</strong></font>
</center>
<BR>
<form action = "index.jsp">
<P align = center><input name="Button" type="submit" value="·µ»Ø"></P>
</form>-->
<%
stmt.close();
}
catch(Exception ex)
{ lflag = false;
}
finally
{
conn.close();
}
if(lflag)
{
out.println("<script lanugage=\"javascript\">alert(\"success");location.href=\"index.jsp\";</script>");
}else{
out.println("<script lanugage=\"javascript\">alert(\"false\");history.back();</script>");
}
%>
<%@ page language="Java" contentType="text/html; charset=gb2312"%>
<%@ page import="java.sql.*,java.io.*,java.util.*"%>
<%String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\Tomcat\\webapps\\ROOT\\myApp\\msgcenter.mdb"; //指定的建立的.mdb文件的位置
Connection conn = null;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(Exception ex){}
boolean lflag = false;
try{
conn=DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
/*一下用来获取你前一个注册页面的值*/
String subject = request.getParameter("content");
String answer = request.getParameter("answer");
String guest = "guest";
String sql = "insert into User(Name,Password,type) values('sys','sys',0)";
stmt.executeUpdate(sql); //插入数据库!
lflag = true;
%>
<!--<BR>
<BR>
<center>
<font size = "3" face = "Arial" color = "#226699"> <strong>Ìí¼Ó³É¹¦</strong></font>
</center>
<BR>
<form action = "index.jsp">
<P align = center><input name="Button" type="submit" value="·µ»Ø"></P>
</form>-->
<%
stmt.close();
}
catch(Exception ex)
{ lflag = false;
}
finally
{
conn.close();
}
if(lflag)
{
out.println("<script lanugage=\"javascript\">alert(\"success");location.href=\"index.jsp\";</script>");
}else{
out.println("<script lanugage=\"javascript\">alert(\"false\");history.back();</script>");
}
%>
把他的注册功能拿来看看改一下不就好了?
String answer = request.getParameter("answer");
String guest = "guest";
String sql = "insert into User(Name,Password,type) values('sys','sys',0)";
stmt.executeUpdate(sql); //插入数据库!subject、answer就是注册页面的文本框的名称吗?sys指的是什么?