JDBC练习

最新推荐文章于 2021-12-16 13:58:33 发布

eRRRchou

最新推荐文章于 2021-12-16 13:58:33 发布

阅读量737

点赞数

本文链接：https://blog.youkuaiyun.com/erchouchou/article/details/79933050

版权

package erchou;

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class GetInfo extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}

public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");

String name = request.getParameter("name");

String password = request.getParameter("password");

System.out.println("姓名："+name + "密码："+password);

Connection connection = null;

PreparedStatement statement = null;

ResultSet result = null;

connection = JdbcUtil.getConnection();

String sql = "SELECT *FROM userr WHERE userName = ?";

try {
statement = connection.prepareStatement(sql);

statement.setString(1, name);

result = statement.executeQuery();

if(result.next()){
response.getWriter().write("<html><head><meta charset = 'utf-8'></head><body>该用户已经存在<body></html>");
}else{
sql = "INSERT userr(userName, PASSWORD)VALUES(?,?);";

statement = connection.prepareStatement(sql);

statement.setString(1, name);

statement.setString(2, password);

statement.executeUpdate();

response.getWriter().write("<html><head><meta charset = 'utf-8'></head><body>注册成功!<body></html>");
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}

}

//附加html页面

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta charset = "utf-8" />

</head>
<body>
<form action="http://localhost:8080/MyIndex/servlet/GetInfo" method="POST">
用户名： <input type = "text" value = "请输入用户名" name="name"/>
密码： <input type = "password" name = "password"/>
<input type = "submit" value = "提交">
</form>
</body>
</html>