用tomcat的java web简单登录实验

用tomcat的java web简单登录实验

利用事先写好的Dao包里面有操作数据库的简单方法。其中的工具类DbUtil和实体类User就不进行代码展示了。这里只用到了UserDao里的selectbyid()方法。

package work2.Dao;

import work2.bean.User;
import work2.util.DbUtil;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class UserDao {
   
    Connection connection= null;
    PreparedStatement pstmt=null;
    ResultSet rs=null;
    public void delete(String username) {
   
        try {
   
            connection = DbUtil.getConnection();
            String sql="DELETE FROM User where username="+username;
            pstmt = connection.prepareStatement(sql);
            pstmt.executeUpdate(sql);
        } catch (ClassNotFoundException e) {
   
            e.printStackTrace();
        } catch (SQLException e) {
   
            e.printStackTrace();
        }finally {
   
            try {
   
                DbUtil.closeall(null,pstmt,connection);
            } catch (SQLException e) {
   
                e.printStackTrace();
            }
        }
    }
    public List<User> selectall(User user) {
   
        List<User> userList=new ArrayList<>();
        try {
   
            connection = DbUtil.getConnection();
            String sql="SELECT * FROM User";
            pstmt = connection.prepareStatement(sql);
            rs = pstmt.executeQuery(