java web okhttp,WebServlet.Sqlite OkHttp实现账户管理系统的设计

package demo01;

import java.io.IOException;

import java.io.PrintWriter;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.Statement;

import java.util.Scanner;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

/**

* Servlet implementation class   Login

*/

@WebServlet("/login.do")

public class Login extends HttpServlet {

private static final long serialVersionUID = 1L;

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

response.setContentType("text/html;charset=UTF-8");

PrintWriter   out=response.getWriter();

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

//String   pwd=request.getParameter("pwd");

if(name!=null){

name=new String(request.getParameter("name").getBytes("ISO-8859-1"),"UTF-8");

}

out.println("欢迎您 !"+name);

System.out.println(request.getRemoteAddr()+"-"+name);

}

/**

* @see   HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)

*/

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

response.setContentType("text/html;charset=UTF-8");

PrintWriter   out=response.getWriter();

request.setCharacterEncoding("UTF-8");

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

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

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

if(type.equals("login")){

try {

String   sql="select * from user where name=? and pwd=?";

Class.forName("org.sqlite.JDBC");

Connection   conn=DriverManager.getConnection("jdbc:sqlite:/c:/sqlite/db/my.db");

PreparedStatement   stmt=conn.prepareStatement(sql);

stmt.setString(1,name);

stmt.setString(2,pwd);

ResultSet   rs=stmt.executeQuery();

if(rs.next()){

out.println("登录成功!欢迎"+name);

}else{

out.println("用户名或密码错误!");

}

rs.close();

stmt.close();

conn.close();

out.close();

}   catch (Exception   e) {

e.printStackTrace();

}

}else if(type.equals("A")){

try {

String   sql="select * from user";

Class.forName("org.sqlite.JDBC");

Connection   conn=DriverManager.getConnection("jdbc:sqlite:/c:/sqlite/db/my.db");

PreparedStatement   stmt=conn.prepareStatement(sql);

ResultSet   rs=stmt.executeQuery();

while(rs.next()){

out.println("姓名:"+rs.getString(1)+"----"+"密码:"+rs.getString(2));

}

stmt.close();

rs.close();

conn.close();

out.close();

}   catch (Exception   e) {

e.printStackTrace();

}

}else if(type.equals("B")){

String   sql="insert into user values('"+name+"'"+","+"'"+pwd+"'"+")";

try {

Class.forName("org.sqlite.JDBC");

Connection   conn=DriverManager.getConnection("jdbc:sqlite:/c:/sqlite/db/my.db");

Statement   stmt=conn.createStatement();

int rs=stmt.executeUpdate(sql);

if(rs>0){

out.println("添加成功!");

}else{

out.println("添加失败！");

}

stmt.close();

conn.close();

out.close();

}   catch (Exception   e) {

e.printStackTrace();

}

}else if(type.equals("C")){

String   sql="update user set pwd="+"'"+pwd+"'"+"where   name="+"'"+name+"'";

try {

Class.forName("org.sqlite.JDBC");

Connection   conn=DriverManager.getConnection("jdbc:sqlite:/c:/sqlite/db/my.db");

Statement   stmt=conn.createStatement();

int rs=stmt.executeUpdate(sql);

if(rs>0){

out.println("修改成功!");

}else{

out.println("修改失败 ！");

}

stmt.close();

conn.close();

}   catch (Exception   e) {

e.printStackTrace();

}

}else if(type.equals("D")){

String   sql="delete from User where name="+"'"+name+"'";

try {

Class.forName("org.sqlite.JDBC");

Connection   conn=DriverManager.getConnection("jdbc:sqlite:/c:/sqlite/db/my.db");

Statement   stmt=conn.createStatement();

int rs=stmt.executeUpdate(sql);

if(rs>0){

out.println("删除成功!");

}else{

out.println("删除失败!");

}

stmt.close();

conn.close();

}   catch (Exception   e) {

e.printStackTrace();

}

}

}

}