JDBC练习

版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/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>

阅读更多
换一批

没有更多推荐了,返回首页