前端学习-servlet编写数据接口JSON文件形式

public class User {
    private int id;
    private String username;
    private String passwd;


    public int getId() {
        return id;
    }

    public String getUsername() {
        return username;
    }

    public String getPasswd() {
        return passwd;
    }

    public void setId(int id) {
        this.id = id;
    }

    public void setUsername(String username) {
        this.username = username;
    }
    public void setPasswd(String passwd) {
        this.passwd = passwd;
    }

    public String toString(){
        return "user"+id+","+username+","+passwd;
    }

}

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

public class UserDAO {
    private String userName = "root";//这里是你最开始刚下载mysql是输入的账号
    private String password = "1234";//这里是你最开始mysql设置的密码，
    private String url = "jdbc:mysql://localhost:3306/login";

    public List<User> getUserAll(String sql) throws ClassNotFoundException, SQLException {
        List<User> listBill = null;
        //这里不用更改，如果你要连的不是mysql的话再换这个括号内的代码
        Class.forName("com.mysql.jdbc.Driver");
        System.out.println("驱动加载成功！");
        Connection connection = DriverManager.getConnection(url, userName, password);//把上面的三个属性传过来，应该就连接成功了，不成功的话应该就是你的账号密码不正确
        System.out.println("数据库连接成功！");
        if (connection == null) {
            System.out.println("连接失败");
        } else {
            Statement statement = connection.createStatement();
            ResultSet rs = statement.executeQuery(sql);
            //整理数据
            listBill = new ArrayList<User>();
            // 展开结果集数据库
            while (rs.next()) {
                User user = new User();
                // 通过字段检索
                //String id=rs.getString("id");
                String uname = rs.getString("user");
                String passwd = rs.getString("mi");
                user.setUsername(uname);
                user.setPasswd(passwd);
                listBill.add(user);
                // 输出数据
                System.out.println("地址是: " + passwd);
                System.out.print("用户名是: " + uname);

            }
            connection.close();
        }
        return listBill;

    }
    public UserDAO(){

    }
}

import com.alibaba.fastjson.JSON;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.SQLException;
import java.util.List;

public class JDBCServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        String sql="select * from user";
        UserDAO dao=new UserDAO();
        try {
            List<User> list=dao.getUserAll(sql);
            //设置json数据中文不为乱码
            resp.setContentType("application/json;charset=utf-8");
            resp.getWriter().write(JSON.toJSONString(list));
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        super.doPost(req, resp);
    }
}

要记得配置web.xml

<servlet>
        <servlet-name>JDBCServlet</servlet-name>
        <servlet-class>com.sise.servlet.JDBCServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>JDBCServlet</servlet-name>
        <url-pattern>/JDBCServlet</url-pattern>
    </servlet-mapping>