利用JAVA想数据库中提交数据

1.用户信息提交界面

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>注册新用户</title>
<script type="text/javascript">

function check()
{    
    if(zhuce.userid.value == null || zhuce.userid.value.trim().length ==0)
        {
        alert("请输入用户代码")
        return false;
        }
    if(zhuce.username.value == null || zhuce.username.value.trim().length ==0)
        {
        alert("请输入用户名称");
        return false;
        }
    if(zhuce.password.value == null || zhuce.password.value.trim().length ==0)
        {
        alert("请输入密码");
        return false;
        }
    if(zhuce.password2.value == null || zhuce.password2.value.trim().length ==0)
        {
        alert("请再次密码");
        return false;
        }
    if(zhuce.password2.value != zhuce.password.value)
        {
        alert("两次输入的密码不一致");
        return false;
        }
    return true;
}


</script>
</head>
<body>
<form >

用户代码:<input  width=30 />
<br><br>
用户名称:<input  width=30 />
<br><br>
输入密码:<input  width=30 />
<br><br>
确认密码:<input  width=30 />
<br><br>
<input type="submit" value="提交" />

</form>

</body>
</html>

2.用户信息存储代码

package com.hanqi;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;

/**
 * Servlet implementation class SaveUser
 */
@WebServlet("/SaveUser")
public class SaveUser extends HttpServlet {
    private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public SaveUser() {
        super();
        // TODO Auto-generated constructor stub
    }

    /**
     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        
        //转换中文字符防止出现乱码
        request.setCharacterEncoding("UTF-8");
        
        response.setContentType("text/html;charset=UTF-8");
        
        String userID = request.getParameter("userid");
        String userName = request.getParameter("username");
        String pw = request.getParameter("password");
        
        if(userID == null || userID.trim().length() == 0)
        {
            response.getWriter().append("用户ID不能为空");
        }
        else if(userName == null || userName.trim().length() == 0)
        {
            response.getWriter().append("用户名称不能为空");
        }
        else
        {
            //异常信息捕获
            try{
            Class.forName("oracle.jdbc.driver.OracleDriver");
            
            String url = "jdbc:oracle:thin:@localhost:1521:ORCL";
            
            Connection conn = DriverManager.getConnection(url,"test1","test1");
            
            if(conn != null)
            {
                //操作数据库
                String sql = "insert into t_user (user_id,user_name,password)" + "values (?,?,?)";
                
                //执行SQL的类
                PreparedStatement pps = conn.prepareStatement(sql);
                
                userName = new String(userName.getBytes("ISO-8859-1"),"UTF-8");
                
                pps.setString(1, userID);
                pps.setString(2, userName);
                pps.setString(3, pw);
                
                int row = pps.executeUpdate();//执行SQL语句并返回数据行数
                
                if(row > 0)
                {
                    response.getWriter().append("保存了" + row + "条数据");
                }
                else
                {
                    response.getWriter().append("保存数据失败");
                }
                
                //释放
                pps.close();
                
                conn.close();
            }
            else
            {
                response.getWriter().append("连接数据库失败");
            }
                    
            
            }
            catch(ClassNotFoundException e){
                e.printStackTrace();
            }    
            catch(Exception e){
                e.printStackTrace();
                
                response.getWriter().append(e.getMessage());
            }
        
        }
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        doGet(request, response);
    }

}

利用JAVA想数据库中提交数据

相关推荐