jsp,javaBean与oracle连接问题……谢谢各位啊!
简单的注册页面连接的数据库是oracle,做了两个javaBean 一个是得到数据的,一个是往oracle插入数据的
下面是代码 为什么插入不成功呢?谢谢各位了啊!
jsp:<%@ page contentType= "text/html;charset=gb2312"%>
<%@ include file="login.html"%>
<jsp:useBean id="login" scope="session" class="login.LoginBean">
<jsp:setProperty name ="login" property="*"/>
</jsp:useBean>
<jsp:useBean id="date" scope="session" class="login.DateBean"/>
<%
try{
date.setLoginBean(login);
date.login();
}catch (Exception e){
out.println(e.toString());
}
%>
----------------------------------------------------------------------------------
html:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>欢迎注册!</title>
</head>
<body>
<form method=get action="login.jsp">
<!--webbot bot="SaveResults" U-File="fpweb:///_private/form_results.txt"
S-Format="TEXT/CSV" S-Label-Fields="TRUE" -->
<p>name: <input type="text" name="name" size="20">
</p>
<p>password:<input type="text" name="password" size="20"></p>
<p>
</p>
<p>
<input type="submit" value="submit" name="submit"></p>
</form>
</body>
</html>
-----------------------------------------------------------------------------------
javaBean(得到数据的)
package login;
import java.io.Serializable;
/**
* @author Administrator
*
* 更改所生成类型注释的模板为
* 窗口 > 首选项 > Java > 代码生成 > 代码和注释
*/
public class LoginBean implements Serializable {
private String name;
private String password;
/**
* @return
*/
public String getName() {
return name;
}
/**
* @return
*/
public String getPassword() {
return password;
}
/**
* @param string
*/
public void setName(String string) {
name = string;
}
/**
* @param string
*/
public void setPassword(String string) {
password = string;
}
}
------------------------------------------------------------------------------------
javaBean(连接数据库插入数据的)
package login;
import java.io.Serializable;
import java.sql.*;
/**
* @author Administrator
*
* 更改所生成类型注释的模板为
* 窗口 > 首选项 > Java > 代码生成 > 代码和注释
*/
public class DateBean implements Serializable{
public LoginBean loginBean;
private Connection conn=null;
private PreparedStatement pstmt =null;
//连接数据库
public DateBean(){
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@127.0.0.1:1521:CUIBIAO";
conn= DriverManager.getConnection(url,"system","manager");
}catch(Exception e){
System.out.println(e.toString());
}
}
public void setLoginBean(LoginBean loginBean){
this.loginBean = loginBean;
}
//注册信息
public void login(){
try{
pstmt = conn.prepareStatement("INSERT INTO LOGIN VALUES(?,?)");
pstmt.setString(1,loginBean.getName());
pstmt.setString(2,loginBean.getPassword());
pstmt.executeUpdate();
}catch (Exception e1){
System.out.println(e1.toString());
}
finally{
if(pstmt!=null)
try{
pstmt.close();
}catch(SQLException e2){
}
if(conn!=null)
try{
conn.close();
}catch(SQLException e3){
}
}
}
}