音乐系统之用户管理模块

音乐系统再优化版。。
还不是最终版本，仅供参考

这里是用户注册模块
package com.zhongruan.dao;

import com.zhongruan.beam.User;
import com.zhongruan.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.Scanner;

public class UserDao {
public boolean login(String username, String password) throws Exception {
Connection connection = DBUtil.getConnection( );
Scanner input = new Scanner(System.in);
connection = DBUtil.getConnection( );
String sql = “selectfrom tb_user where username=? and password=?";
PreparedStatement preparedStatement = connection.prepareStatement(sql);
preparedStatement.setString(1,username);
preparedStatement.setString(2,password);
ResultSet resultSet = preparedStatement.executeQuery(