写一个可以连接到数据库的todolist

一个可以连接到数据库的todolist

package com.westos.todo;

public class todolist {
	private Integer id;
	private String type;
	private String direction;
	private String content;

	public todolist() {
	}

	public todolist(String type, String direction, String content, Integer id) {
		super();
		this.id = id;
		this.type = type;
		this.direction = direction;
		this.content = content;
	}

	public String getType() {
		return type;
	}

	public void setType(String type) {
		this.type = type;
	}

	public String getDirection() {
		return direction;
	}

	public void setDirection(String direction) {
		this.direction = direction;
	}

	public String getContent() {
		return content;
	}

	public void setContent(String content) {
		this.content = content;
	}

	public Integer getId() {
		return id;
	}

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

	@Override
	public String toString() {
		return "todolist [id=" + id + ", type=" + type + ", direction=" + direction + ", content=" + content + "]";
	}

}

数据库连接：

package com.westos.util;

import java.sql.Connection;
import java.sql.DriverManager;

public class Util {
	private static String DRIVERCLASS = "com.mysql.jdbc.Driver";
	private static String URL = "jdbc:mysql://localhost/javaweb?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull";
	private static String USERNAME = "root";
	private static String PASSWORD = "123456";

	public static Connection getConnection() {
		try {
			Class.forName(DRIVERCLASS);
			Connection conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);
			return conn;

		} catch (Exception e) {
			e.printStackTrace();
			return null;
		}
	}
}

service

package com.westos.todo;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import com.westos.util.Util;

public class TodoService {

	public boolean save(Integer id,String type,String direction,String content){
	        String sql="";
	        Connection conn= Util.getConnection