用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(