菜鸟求救[不会用JSP做小系统]

先做一个首页，index.html，然后这个主页上有五个超链，其中要做三个，一个是“用户注册”，一个是“用户登录”，一个是“更改信息”，需要跟数据库连，小菜选的是ACCESS，然后不会用JSP连数据库，还有高手解决一下啊？这边能不能上传代码的，我想把我写的代码传上来，让高手看一下哪里有问题撒。谢了。万分感谢。

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

这是index.html<html>
<head>
<title>用户注册</title>
</head><body bgcolor=#ffcc33><center>
<table bgcolor=#ffcc33 border=0 width="100%">
<tbody>
<tr>
  <div align="center">
  <h1><b>用户注册示例</b></h1>
  </div>
</tr>
<tr>
  <td align=top valign=top width="18%"><br><br>
<ul>
<li><a href ='index.html'><font class=itm>首页</font></a></li><br><br>
<li><a href ='usernew.html'><font class=itm>用户注册</font></a></li><br><br>
<li><a href ='userlogin.html'><font class=itm>用户登录</font></a></li><br><br>
<li><a href ='editinfo.jsp'><font class=itm>更改信息</font></a></li><br><br>
<li><a href ='http://www.flyinf.com' target=_blank><font class=itm>公司主页</font></a></li><br><br>
</ul>
  </td>
  <td colspan=2 width="82%">
  </td>
</tr>
</tbody>
</table>
</center>
</body>
</html>这是userlogin.html<HTML>
<HEAD>
<TITLE> 用户注册 </TITLE>
<META http-equiv="Content-Type" content="text/html;charset=gb2312">
</HEAD><BODY bgcolor=#FFCC33><div align="center">
  <h2>会员登录</h2>
</div><form method="post" action="login.jsp" name="loginform">
<table width="600" border="1" cellspacing="0" cellpadding="0">
<tr>
<td width="178">
  <div align="right">用户名:</div>
</td>
<td width="416">
  <input type="text" name="username">
</td>
</tr>

<tr>
<td width="178">
  <div align="right">密码:</div>
</td>
<td width="416">
  <input type="password" name="password">
</td>
</tr> <tr>
<td width="178">
           
</td>
<td width="416">
  <input type="submit" name="Submit" value="提交注册" >
  <input type="reset" name="Submit2" value="重写" >
</td>
</tr>
</table>
</form></BODY>
</HTML>这是usernew.html<HTML>
<HEAD>
<TITLE> 用户注册 </TITLE>
<META http-equiv="Content-Type" content="text/html;charset=gb2312">
</HEAD><BODY bgcolor=#FFCC33><div align="center">
  <h2>会员注册</h2>
</div><form method="post" action="register.jsp" name="regform">
<table width="600" border="1" cellspacing="0" cellpadding="0">
<tr>
<td width="178">
  <div align="right">登录名:</div>
</td>
<td width="416">
  <input type="text" name="username">
</td>
</tr> <tr>
<td width="178">
  <div align="right">密码:</div>
</td>
<td width="416">
  <input type="password" name="password">
</td>
</tr> <tr>
<td width="178">
  <div align="right">真实姓名:</div>
</td>
<td width="416">
  <input type="text" name="name">
</td>
</tr> <tr>
<td width="178">
  <div align="right">性别:</div>
</td>
<td width="416">
  <input type="radio" name="sex" value="1" checked>男
  <input type="radio" name="sex" value="0">女
</td>
</tr> <tr>
<td width="178">
  <div align="right">学历:</div>
</td>
<td width="416">
  <input type="text" name="education">
</td>
</tr> <tr>
<td width="178">
  <div align="right">Email:</div>
</td>
<td width="416">
  <input type="text" name="email">
</td>
</tr> <tr>
<td width="178">
  <div align="right">个人简介:</div>
</td>
<td width="416">
   
</td>
</tr> <tr>
<td width="178">
           
</td>
<td width="416">
  <textarea name="resume" cols="50" rows="10"></textarea>
</td>
</tr> <tr>
<td width="178">
           
</td>
<td width="416">
  <input type="submit" name="Submit" value="提交注册" >
  <input type="reset" name="Submit2" value="重写" >
</td>
</tr>
</table>
</form></BODY>
</HTML>
这是register.jsp<%@page language="java" contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*,java.lang.String"%>
<jsp:useBean id="Database" scope="page" class="padish.Database" /><%
Database.setDatabase("members");
String name1=Database.getParam(request,"username");
String name2=Database.getParam(request,"name");
String password=Database.getParam(request,"password");
String e_mail=Database.getParam(request,"email");
String education=Database.getParam(request,"education");
String sex=Database.getParam(request,"sex");
String resume=Database.getParam(request,"resume");if ((name1==null)||(password==null))
{
%>
<p>用户名和密码不能为空!</p>
<input type="button" value="返回修改" onclick="histroy.back()">
<%
}
else
{
String sql="select * from userinfo where username='"+name1+"'";
ResultSet rs=Database.executeQuery(sql);
if (rs.next())
{
rs.close();
session.putValue("register_message","duplicate name foung!");
%>
<script language=javascript>
window.location="info.jsp?str=用户<%=name1%>已经存在"
</script>
<%
}
else
{
rs.close();
%>
<form method="post" action="register2.jsp">
<input type="hidden" name="username" value="<%=name1%>">
<input type="hidden" name="password" value="<%=password%>">
<input type="hidden" name="name" value="<%=name2%>">
<input type="hidden" name="email" value="<%=e_mail%>">
<input type="hidden" name="education" value="<%=education%>">
<input type="hidden" name="sex" value="<%=sex%>">
<input type="hidden" name="resume" value="<%=resume%>">
请检查您的注册信息<br><br>
<table width="60%" border="1"> <tr>
<td>
  登录名:
</td>
<td>
  <%=name1%>
</td>
</tr> <tr>
<td>
  真实姓名:
</td>
<td>
  <%=name2%>
</td>
</tr> <tr>
<td>
  性别:
</td>
<td>
  <%=sex%>
</td>
</tr> <tr>
<td>
  简历:
</td>
<td>
  <%=resume%>
</td>
</tr> <tr>
<td>
  Email:
</td>
<td>
  <%=e_mail%>
</td>
</tr> <tr>
<td>
  学历:
</td>
<td>
  <%=education%>
</td>
</tr>
</table>
<br>

<input type="submit" value="提交注册">  
<input type="reset" value="返回修改" onclick="histroy.back()">
</form>
<%
}
%>
</center>
<%
}
%></body>
</html>这是register2.jsp<%@page language="java" contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*"%>
<jsp:useBean id="database" scope="page" class="padish.Database" />
<%
/*
String name1=database.wrapParam(request,"username");
String name2=database.wrapParam(request,"name");
String password=database.wrapParam(request,"password");
String e_mail=database.wrapParam(request,"email");
String education=database.wrapParam(request,"education");
String sex=database.wrapParam(request,"sex");
String resume=database.wrapParam(request,"resume");
*/
database.setDatabase("members");
String name1=database.wrap(request.getParameter("username"));
String name2=database.wrap(request.getParameter("name"));
String password=database.wrap(request.getParameter("password"));
String e_mail=database.wrap(request.getParameter("email"));
String education=database.wrap(request.getParameter("education"));
String sex=database.wrap(request.getParameter("sex"));
String resume=database.wrap(request.getParameter("resume"));
//生成注册用的SQl语句
String strSQL="insert into userinfo (username,name,password,email,education,sex,resume)values("+name1+","+name2+","+password+","+e_mail+","+education+","+sex+","+resume+")";
//使用opendb的executQuery方法执行SQL语句
database.executeUpdate(strSQL);
session.putValue("username",name1);
%>
<html>
<body>
<script language=javascript>
window.location="info.jsp?str=注册成功"
</script>
</body>
</html>
这是login.jsp<%@page language="java" contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*"%>
<jsp:useBean id="Database" scope="page" class="padish.Database" /><%
  Database.setDatabase=Database.getDatDatabase.setDatabase("members");
  String name1=request.getParameter("username");
  String pwd1=request.getParameter("password");
  String sql="select * from members where username='"+name1+"' and password='"+pwd1+"'";
//  String sql="select * from userinfo";

  ResultSet rs=Database.executeQuery(sql);
  if (rs.next())
  {
    rs.close();
    session.putValue("username",name1);
%>
  <script language=javascript>
  window.location="info.jsp?str=登录成功"
  </script>
<%
  }
  else
  {
    rs.close();
    session.putValue("login_message","Error on Login!");
%>
  <script language=javascript>
  window.location="info.jsp?str=登录失败"
  </script>
<%
  }
%>
这是editinfo.jsp<%@page language="java" contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*"%>
<jsp:useBean id="database" scope="page" class="padish.Database" /><%
database.setDatabase("members");
String name1=(String)session.getValue("username");
if(name1==null)name1='null';
String sql="select * from userinfo where username='"+name1+"'";
ResultSet rs=database.executeQuery(sql);
if (rs.next())
{
%> <body bgcolor=#ffcc33>
<center>
<h2>修改信息</h2>
<form method="post" action="editinfo1.jsp" >
<table width="85%" border="2" >
<tr>
<td align="left" height="20" width="28%">
  <p align="right">真实姓名:</p>
</td>
<td align="left" height="20" width="72%">
  <p><input type="text" name="name" value="<%out.print(rs.getString("name"));%>">
</td>
</tr> <tr>
<td align="left" height="20" width="28%">
  <p align="right">Email:</p>
</td>
<td align="left" height="20" width="72%">
  <p><input type="text" name="email" value="<%out.print(rs.getString("email"));%>">
</td>
</tr>

<tr>
<td align="left" height="20" width="28%">
  <p align="right">教育:</p>
</td>
<td align="left" height="20" width="72%">
  <p><input type="text" name="education" value="<%out.print(rs.getString("education"));%>">
</td>
</tr> <tr>
<td align="left" height="20" width="28%">
  <p align="right">个人简介:</p>
</td>
<td align="left" height="20" width="72%">
  <p><textarea name="resume" cols="50" rows="10">
<%out.print(rs.getString("resume"));%>
  </textarea></p>
</td>
</tr>
<tr>
<td align="left" height="20" width="28%">
  <p align="right"><input type="submit" value="确定"></p>
</td>
<td align="left" height="20" width="72%">
  <p align="center"><input type="reset" value="清空"></p>
</td>
</tr>
</table>
</form>
</center>
<%
rs.close();
}
else
{
rs.close();
%>
<script language=javascript>
window.location="info.jsp?str=请先登录"
</script>
<%
}
%>这是editinfo1.jsp<%@page language="java" contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*"%>
<jsp:useBean id="database" scope="page" class="padish.Database" />
<%
String name1=database.wrapValue(session,"username");
String name2=database.wrap(request.getParameter("name"));
String e_mail=database.wrap(request.getParameter("email"));
String education=database.wrap(request.getParameter("education"));
String resume=database.wrap(request.getParameter("resume"));
database.setDatabase("myusers");String strSQL="update userinfo set name="+name2+",email="+e_mail+",education="+education+",resume="+resume+" where username="+name1;
database.executeUpdate(strSQL);
%>
<script language=javascript>
window.location="info.jsp?str=修改信息成功"
</script>这是info.jsp<html>
<head>
<title>用户注册示例</title>
</head><body bgcolor=#ffcc33><center>
<table bgcolor=#ffcc33 border=0 width="100%">
<tbody>
<tr>
  <div align="center">
  <h1><b>用户注册示例</b></h1>
  </div>
</tr>
<tr>

<%
String str=request.getParameter("str");
%>
  <td>
<%=str%>
  </td>
</tr>
</tbody>
</table>
<a href="index.html">返回首页</a>
</center>
</body>
</html>这是Database.javapackage padish;
import java.sql.*;
import java.lang.String;
public class Database {
String sDBDriver =" sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr =" jdbc:odbc:Database";
Connection conn = null;
ResultSet rs = null;
public Database () {
try {
Class.forName(sDBDriver);
}
catch (java.lang.ClassNotFoundException e ) {
System.err.println("Database():" + e.getMessage() );
}
}
public ResultSet executeQuery (String sql ) {
rs = null;
try {
System.out.println("1");
conn = DriverManager.getConnection (sConnStr);
System.out.println(conn);
System.out.println("2");
Statement stmt = conn.createStatement();
System.out.println("3");
rs = stmt.executeQuery (sql);
System.out.println("4");
}
catch (SQLException ex){
System.err.println("aq.executeQuery:"+ ex.getMessage() );
}
return rs;
}
}就这些多文件，高手一定要帮我啊。
Database是一个数据源的名称吧
你看看是不是已经建立一个数据源叫database,看看数据源的用户命跟密码对不对
:),努力：）
我自己做了一个ACCESS的表格，这算不算啊？然后把工程引到ECLIPSE里面跑，就报错，说是什么database.wrapValue这些标记找不着，是不是要在Database.java文件里声明这些方法啊？如何声明呢？
数据源配置是不是就是在“控制面板”-“管理工具”-“ODBC数据源”这里配啊，已经配了的啊。