jsp第七次作业

index.jsp

<%@ 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%>">
    
    <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">
    <!--
    <link rel="stylesheet" type="text/css" href="styles.css">
    -->
  </head>
  
  <body>
    <form name="form1" method="post" action="control.jsp" >
        <table>
        <tr>    
            <td>编号：</td>
                <td> <input type="text" name="sid" id="userName"  ></td>
            </tr>
            <tr>    
                <td>用户名：</td>
                <td> <input type="text" name="uname" id="userName"  ></td>
            </tr>
            <tr>    
                 <td>输入登录密码：</td>
                <td><input type="password" name="upwd" id="pwd"></td>
            </tr>
            
            <tr>    
                <td colspan="2"><input type="submit" value="注册"></td>
            </tr>
        </table>
    </form>
  </body>
</html>

数据库运行

select * from Stu;

newfile.sql

create table stu(
sid int primary key,
uname varchar(20),
upwd varchar(20)
)

delete from stu;

insert into stu values(1,'zs','123');
insert into stu values(2,'ls','456');

Stu.java

package com.gd.bean;

public class Stu {
    private int sid;
    private String uname;
    private String upwd;
    //访问器
    public int getSid() {
        return sid;
    }
    public void setSid(int sid) {
        this.sid = sid;
    }
    public String getUname() {
        return uname;
    }
    public void setUname(String uname) {
        this.uname = uname;
    }
    public String getUpwd() {
        return upwd;
    }
    public void setUpwd(String upwd) {
        this.upwd = upwd;
    }
    //构造器
    public Stu(int sid, String uname, String upwd) {
        super();
        this.sid = sid;
        this.uname = uname;
        this.upwd = upwd;
    }
    public Stu() {
        super();
    }
    
    
    
    
    

}

StuDao.java

package com.gd.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

import com.gd.bean.Stu;

public class StuDao {
    //学生数据访问类
    
    //添加学生
    public int addStu(Stu s){
        int i=0;
        
        try {
            //加载驱动
            Class.forName("com.mysql.jdbc.Driver");
            //建立连接
            Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql", "root", "root");            
            //写SQL语句
            String sql="insert into stu values(?,?,?)";            
            //执行
            PreparedStatement ps=con.prepareStatement(sql);
            ps.setInt(1, s.getSid());
            ps.setString(2, s.getUname());
            ps.setString(3, s.getUpwd());
            i=ps.executeUpdate();
            
            
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return i;
        
        
        
        
        
        
        
    }
    
   
}

 

 

 

 

posted @ 2021-04-16 21:44  এ三月⍤⃝有点甜  阅读(47)  评论(0)  编辑  收藏  举报