jsp之 javabean （mysql数据库2） jsp与javabean组合

最新推荐文章于 2024-11-06 10:59:12 发布

ykendy

最新推荐文章于 2024-11-06 10:59:12 发布

阅读量471

点赞数

文章标签： jsp mysql 数据库 string stylesheet exception

本文链接：https://blog.csdn.net/ykendy/article/details/2305145

版权

javabean:

package yun;
import java.sql.*;

public class Shujuku {
          private int id;
          private int mima;
          private String sex;
          private String email;
  public String getEmail() {
   return email;
  }
  public void setEmail(String email) {
   this.email = email;
  }
  public int getId() {
   return id;
  }
  public void setId(int id) {
   this.id = id;
  }
  public int getMima() {
   return mima;
  }
  public void setMima(int mima) {
   this.mima = mima;
  }
  public String getSex() {
   return sex;
  }
  public void setSex(String sex) {
   this.sex = sex;
  }
  private Connection getConnection(){
   Connection con=null;
   try{
        Class.forName("org.gjt.mm.mysql.Driver").newInstance();
     con=DriverManager.getConnection("jdbc:mysql://localhost/myfirst","root","123456");

     }
    catch(Exception e){
     e.printStackTrace(System.err);
     }

   return con;
  }

  public void insert(){
   Connection con2=null;
   con2=getConnection();
   StringBuffer q=new StringBuffer(200);
   q.append("insert into ZhuChe values(?,?,?,?)");
   try{
    PreparedStatement stmt=null;
    stmt=con2.prepareStatement(q.toString());


    stmt.setInt(1,id);
    stmt.setInt(2,mima);
    stmt.setString(3,sex);
    stmt.setString(4,email);

    stmt.executeUpdate();
    stmt.close();
    con2.close();
   }

   catch(Exception exc){
    exc.printStackTrace(System.err);
   }

  }

}

这是index.jsp页面是个用户注册提交页面......

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
    <base href="<%=basePath%>">
    <title>My JSP 'index.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">

</head>

<body> <br>

out.println(lon);

<form action="second.jsp" method=post>
ID
<input type="type" name="id"><br>
Mima
<input type="password" name="mima"><br>
Sex
<input type="type" name="sex"><br>
Email
<input type="type" name="email"><br>

</body>
</html>

out.println(lon);

提交到second.jsp页面............

<%@ page language="java" import="java.util.*" pageEncoding="GB2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
    <base href="<%=basePath%>">

    <title>My JSP 'second.jsp' starting page</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">

</head>

<body>

    <jsp:useBean id="s2" scope="page" class="yun.Shujuku"/>
     <jsp:setProperty name="s2" property="*"/>
     <% s2.insert(); %>
     <%=s2.getEmail() %>                               < %--测试是否提交到javabean中--%>
     完成

</body>
</html>

ykendy@yahoo.cn 完成