今天完成内容：
学习web
连接数据库，爬取数据
public class User {
private String id;
private String name;
private String link;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getLink() {
return link;
}
public void setLink(String link) {
this.link = link;
}
public User() {
super();
// TODO Auto-generated constructor stub
}
}
package dao;
import java.util.stream.Collectors;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.LinkedHashMap;
import bean.User;
import java.util.Map;
import util.DBUtil;
import java.util.HashMap;
public class UserDao {
public int adduser(User bean) {
int i=0;
Connection con=null;
PreparedStatement pstmt=null;
ResultSet rs=null;
try {
con=DBUtil.getConn();
String sql="insert into words(id,name,link) values(?,?,?,?,?)";
pstmt=con.prepareStatement(sql);
pstmt.setString(1, bean.getId());
pstmt.setString(2, bean.getName());
pstmt.setString(3, bean.getLink());
i = pstmt.executeUpdate();
}
catch (SQLException e) {
e.printStackTrace();
}
finally {
DBUtil.close(rs, pstmt, con);
}
return i;
}
public ArrayList<User> getall(){
ArrayList<User> list=new ArrayList<>();
Connection con=null;
Statement state=null;
ResultSet rs=null;
try {
con=DBUtil.getConn();
String sql="select * from words";
state=con.createStatement();
rs=state.executeQuery(sql);
while(rs.next())
{
User bean=new User();
bean.setId(rs.getString("id"));
bean.setName(rs.getString("name"));
bean.setLink(rs.getString("link"));
list.add(bean);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
DBUtil.close(rs, state, con);
return list;
}
public User searchbyId(String id) {
// TODO Auto-generated method stub
Connection con=null;
Statement state=null;
ResultSet rs=null;
User bean=new User();
try {
con=DBUtil.getConn();
String sql="select * from words where id='"+id+"'";
state=con.createStatement();
rs=state.executeQuery(sql);
while(rs.next())
{
bean.setId(rs.getString("id"));
bean.setName(rs.getString("name"));
bean.setLink(rs.getString("link"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
DBUtil.close(rs, state, con);
return bean;
}
public int update(User bean) {
// TODO Auto-generated method stub
int i=0;
Connection con=null;
ResultSet rs=null;
PreparedStatement pstmt=null;
try {
con=DBUtil.getConn();
String sql="update words set id=?,name=?,link=? where id=?";
pstmt=con.prepareStatement(sql);
pstmt.setString(1, bean.getId());
pstmt.setString(2, bean.getName());
pstmt.setString(3, bean.getLink());
i = pstmt.executeUpdate();
}
catch (SQLException e) {
e.printStackTrace();
}
finally {
DBUtil.close(rs, pstmt, con);
}
return i;
}
public int del(String id) {
Connection con=null;
ResultSet rs=null;
PreparedStatement pstmt=null;
int i=0;
try {
con=DBUtil.getConn();
String sql="delete from words where id='" + id + "'";
pstmt=con.prepareStatement(sql);
i = pstmt.executeUpdate();
}
catch (SQLException e) {
e.printStackTrace();
}
finally {
DBUtil.close(rs, pstmt, con);
}
return i;
}
public static Map<String,Integer> getrc()
{
int tnumi=0;
String sql="select * from words ";
Map<String, Integer>map= new HashMap<String, Integer>();
Map<String, Integer>results= new LinkedHashMap<String, Integer>();
Connection conn =DBUtil.getConn();
Statement st=null;
ResultSet rs=null;
try {
st=conn.createStatement();
st.executeQuery(sql);
rs=st.executeQuery(sql);
while(rs.next())
{
String keywords=rs.getString("name");
keywords=keywords.substring(0, keywords.length());
String[] split = keywords.split(" ");
for(int i=0;i<split.length;i++)
{
if(map.get(split[i])==null)
{
map.put(split[i],1);
}
else
{
map.replace(split[i], map.get(split[i])+1);
}
}
tnumi++;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
// System.out.println("of的个数为"+map.get("of")+"MAP个数"+map.size());
DBUtil.close(rs, st, conn);
map.entrySet()
.stream()
.sorted((p1, p2) -> p2.getValue().compareTo(p1.getValue()))
.collect(Collectors.toList())
.forEach(ele -> results.put(ele.getKey(), ele.getValue()));
return results;
}
public ArrayList<User> select(String content,String way){
ArrayList<User> list=new ArrayList<>();
Connection con=null;
Statement state=null;
ResultSet rs=null;
String sql="select * from words";
if(content!=""&&"1".equals(way)){
sql +=" where id='"+content+"'";
}else if(content!=""&&"2".equals(way)){
sql += " where name like'%" + content + "%'";
}else if(content!=""&&"3".equals(way)){
sql += " where link='"+content+"'";
}else{
sql ="select * from words";
}
try {
con=DBUtil.getConn();
state=con.createStatement();
rs=state.executeQuery(sql);
while(rs.next())
{
User bean=new User();
bean.setId(rs.getString("id"));
bean.setName(rs.getString("name"));
bean.setLink(rs.getString("link"));
list.add(bean);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
DBUtil.close(rs, state, con);
return list;
}
}
看视频
遇到问题：
无
明日目标：
学习web端的开发
学习css