刚学JSP,求一段代码

你有java的书么里面就有，改成javabean就行了
***********************************
ConData.java
***********************************
package myBank;
import java.sql.*;
public class ConData
{
Connection con=null;
public void getCon()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:MyBankData","sa","3036");//自己在配置一下数据源
}
catch(Exception db_e)
{
System.out.println(db_e);
}
}
}***********************************
AcceptData .java
***********************************
package myBank;
import java.sql.*;
public class AcceptData extends ConData
{
private String nameEnter;
private String passwordEnter;
PreparedStatement stat;
public boolean insertCheck=false;
public String getNameEnter()
{
return this.nameEnter;
}
public void setNameEnter(String name)
{
this.nameEnter=name;
}
public String getPasswordEnter()
{
return this.passwordEnter;
}
public void setPasswordEnter(String pass)
{
this.passwordEnter=pass;
}

public boolean InsertCheckMethod()
{
try
{
super.getCon();
stat=con.prepareStatement("insert into CustomerInfo values (?,?)");
stat.setString(1,nameEnter);
stat.setString(2,passwordEnter);
stat.executeUpdate();

insertCheck=true;
}
catch(Exception db_insert)
{
System.out.println(db_insert);
insertCheck=false;
}
finally
{
try
{
stat.close();
}
catch(Exception db_close)
{
System.out.println(db_close);
}
}
return insertCheck;
}
}
***********************************
ConData.java
***********************************
package myBank;
import java.sql.*;
public class CheckData extends ConData
{
ResultSet res;
PreparedStatement stat;
private String userId;
private String userPassword;
public boolean check=false;
public String getUserId()
{
return this.userId;
}
public void setUserId(String id)
{
this.userId=id;
}

public String getUserPassword()
{
return this.userPassword;
}
public void setUserPassword(String pass)
{
this.userPassword=pass;
}

public boolean Check()
{
try
{
super.getCon();
stat=super.con.prepareStatement("select * from CustomerInfo where Name=? and Password=?");
stat.setString(1,this.userId);
stat.setString(2,this.userPassword);
res=stat.executeQuery();
while(res.next())
{
check=true;
}
}
catch(Exception db_e)
{
System.out.println(db_e);
}
finally
{
try
{
stat.close();
}
catch(Exception db_close)
{
System.out.println(db_close);
}
}
return check;

}
}
***********************************
MyBankJSPSql.sql
***********************************
create database MyBankDataBase
go
use MyBankDataBase
go
create table CustomerInfo
(
Name varchar(10) constraint pkNa primary key,
Password varchar(10) not null
)
go
***********************************
Check.jsp
***********************************
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
<jsp:useBean id="checkD" class="myBank.CheckData"/>
<jsp:setProperty name="checkD" property="*"/>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head><body></body>
</html>
<%
if(checkD.Check()==true)
{
out.println("恭喜恭喜！");
}
else
{
out.println("error");
}
%>
***********************************
Disp.jsp
***********************************
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">

</style>
</head><body>
<form name="form1" method="post" action="Result.jsp" onSubmit="return ch(this)">
  <table width="465" height="147" border="0">
    <tr>
      <td colspan="4"><div align="center"><span class="style1">简简单单的注个册吧！</span></div></td>
    </tr>
    <tr>
      <td width="92"> </td>
      <td width="13"> </td>
      <td width="82"><div align="right">用户名:</div></td>
      <td width="260"><input name="nameEnter" type="text" id="nameEnter" size="14"></td>
    </tr>
    <tr>
      <td> </td>
      <td> </td>
      <td><div align="right">密码：</div></td>
      <td><input name="passwordEnter" type="password" id="passwordEnter_id"></td>
    </tr>
    <tr>
      <td> </td>
      <td> </td>
      <td><div align="right">密码验证：</div></td>
      <td><input name="repasswordEnter" type="password" id="repasswordEnter_id"></td>
    </tr>
  </table>
  <table width="465" border="0">
    <tr>
      <td width="459" height="32">
        <div align="center">
          <input type="submit" name="Submit" value="确定">
        </div></td>
    </tr>
  </table>
</form>
</body>
</html><script>
function ch(form1)
{
var pa=form1.passwordEnter_id.value;
var repa=form1.repasswordEnter_id.value;
if(pa!=repa)
{
alert("两次输入的密码不一致");
return false;
}
}
</script>
***********************************
Login.jsp
***********************************
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">

</style>
</head><body>
<form name="form1" method="post" action="Check.jsp" target="DispFrame">
  <table width="310" height="112" border="0">
    <tr>
      <td colspan="5"><div align="center" class="style1">个人银行登陆</div></td>
    </tr>
    <tr>
      <td width="3"> <div align="right"></div></td>
      <td colspan="2">用户个人帐号</td>
      <td colspan="2"><input name="userId" type="text" id="userId"></td>
    </tr>
    <tr>
      <td> <div align="right"></div></td>
      <td colspan="2">用户帐号密码</td>
      <td colspan="2"><input name="userPassword" type="password" id="userPassword"></td>
    </tr>
    <tr>
      <td> </td>
      <td width="78"><div align="right">
        <input type="submit" name="Submit" value="验证账户">
      </div></td>
      <td width="7"> </td>
      <td width="14"> </td>
      <td width="168"><input type="button" name="Submit2" value="新用户开户" onClick="reg()"></td>
    </tr>
  </table>
</form>
</body>
</html>
<script>
function reg()
{
window.open('Disp.jsp',target="DispFrame");
}
</script>
***********************************
Result.jsp
***********************************
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
<jsp:useBean id="myBean" class="myBank.AcceptData"/>
<jsp:setProperty name="myBean" property="*"/>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head><body></body>
</html><%
if(myBean.InsertCheckMethod()==true)
{
out.println("注册成功");
}
else
{
out.println("注册失败");
}
%>
***********************************
_frame.html
***********************************
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN" "http://www.w3.org/TR/html4/frameset.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head><frameset rows="*" cols="*,476" framespacing="0" frameborder="NO" border="0">
  <frame src="Login.jsp" name="LoginFrame" frameborder="yes" scrolling="yes" id="LoginFrame">
  <frame src="" name="DispFrame" frameborder="yes" scrolling="yes" id="DispFrame">
</frameset>
<noframes><body>
</body></noframes>
</html>首页文件是_frame.html。具体怎么部署应该不用再说了吧！呵呵！

调试易

刚学JSP,求一段代码

解决方案 »