package userBean;
public class UserBean {
private String name;
private String sex;
private String brith;
private String password;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public Stri..
package util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class UserUtil {
// 建立数据库的链接
public Connection getConn() throws Exception {
String Driver = "com.mysql.jdbc.Driver"; // 驱动程序
String URL = "jdbc:mysql://localhost:3306/zydb"; // 连接的URL,ccb为数据库名
String Username = "root"..
package servlet;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import service.MyService;
import userBean.UserBean;
public class MyServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
..
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
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%>">
..
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ page import="service.MyService" %>
<%@ page import="userBean.UserBean" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
..
package service;
import java.util.HashSet;
import dao.UserDao;
import userBean.UserBean;
public class MyService {
public void addUser(UserBean ub) throws Exception{
UserDao ud = new UserDao();
ud.insertSql(ub);
}
public HashSet<UserBean> getAllUsers() throws Exception{
UserDao ud = new UserDao();
return ud.getAllUsers();
}
}
package dao;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.HashSet;
import userBean.UserBean;
import util.UserUtil;
public class UserDao {
// 插入
public void insertSql(UserBean ub) throws Exception{
String s1 = ub.getName();
String s2 = ub.getSex();
String s3 = ub.getBrith();
String s4 = ub.getPassword();
String sql = &..
1.建数据库
2.建表
CREATE DATABASE zydb；
CREATE TABLE tlogin2 (
name varchar( 100 ) not null primary key,
xb varchar( 100 ) not null,
birth varchar( 100 ) not null,
password varchar( 100 )not null
);
3.web project
4.改成1.6版本的jdk
5.建bean：数据库中表的字段
6.建util：数据库的连接等相关操作
7.建dao：增删改查
8.建server：封装dao
9.建jsp
10.建servlet
导入包
动态生成内表的code
REPORT ztest_dynamic.
TYPE-POOLS:slis.
PARAMETERS:p_col TYPE i DEFAULT 10 OBLIGATORY, "动态列
p_rec TYPE i DEFAULT 15 OBLIGATORY. "记录数-行数
DATA:gv_index TYPE char2.
DATA:BEGIN OF gt_data OCCURS 0,
index TYPE char4,
&nb..
社区：
