import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class SqlConnection {
	private static Connection con = null;
	private static Statement stat = null;
	private static String url = "jdbc:mysql://localhost:3308/db_diaryms?user=root&&password=root";

	public SqlConnection() {
		try {
			Class.forName("com.mysql.jdbc.Driver");
			con = DriverManager.getConnection(url);
			stat = con.createStatement();
		} catch (ClassNotFoundException | SQLException e) {
			// TODO 自动生成的 catch 块
			e.printStackTrace();
		}
	}

	public boolean Select(String select) throws SQLException {// 登陆查询
		ResultSet resultSet = stat.executeQuery(select);
		resultSet.last();
		if (resultSet.getRow() > 0) {
			return true;
		} else {
			return false;
		}
	}

	public ResultSet Select_Return(String select) throws SQLException {
		ResultSet resultSet = stat.executeQuery(select);
		return resultSet;
	}

	public void Insert(String insert) throws SQLException {// 插入
		stat.executeUpdate(insert);
	}

	public void Delete(String delete) throws SQLException {// 刪除
		stat.execute(delete);
	}

	public void Update(String update) throws SQLException {
		stat.executeUpdate(update);
	}

}