1.先创建一个文件
2,.创建一个model包放实体类
3.创建一个dao包放 方法
在实体类里并getset
dao包UserDao与Music基本差不多
代码如下
package com.zhongruan.dao;
import com.zhongruan.model.User;
import com.zhongruan.util.DBUtil;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class UserDao {
public User findUserByUsername(String username){
ResultSet resultSet=null;
PreparedStatement statement=null;
Connection connection=null;
User user=null;
try {
connection= DBUtil.getConnection();
//3.写sql
String sql=“select * from tb_user where username=?”;
//4.得到statement对象
statement=connection.prepareStatement(sql);
statement.setString(1,username);
//5.执行sql
resultSet = statement.executeQuery();
//6.处理结果集
while (resultSet.next()){
user=new User();
user.setUsername(resultSet.getString(2));
user.setPassword(resultSet.getString(3));
user.setType(resultSet.getInt(4));
}
} catch (Exception e) {
e.printStackTrace();
}finally {
//7.关闭资源
DBUtil.closeAll(resultSet,statement,connection);
}
return user;
}
public void charu(String username,String password){
ResultSet resultSet=null;
PreparedStatement statement=null;
Connection connection=null;
try {
connection= DBUtil.getConnection();
//3.写sql
String sql=“insert into tb_user (username,password) values (?,?)”;
//4.得到statement对象
statement=connection.prepareStatement(sql);
statement.setString(1,username);
statement.setString(2,password);
statement.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}finally {
//7.关闭资源
DBUtil.closeAll(resultSet,statement,connection);
}
}
}
主文件如下:
package com.zhongruan;
import com.zhongruan.dao.MusicDao;
import com.zhongruan.dao.UserDao;
import com.zhongruan.exception.LoginException;
import com.zhongruan.model.Music;
import com.zhongruan.model.User;
import java.sql.SQLException;
import java.util.List;
import java.util.Scanner;
public class View {
public static void main(String[] args) throws LoginException, SQLException, ClassNotFoundException {
boolean flag=true;
while (flag){
Scanner input=new Scanner(System.in);
System.out.println("-----------您尚未登入,请先登入--------");
System.out.println("-----------请输入用户名:--------------");
String username=input.next();
System.out.println("------------请输入密码:---------------");
String password=input.next();
//1.用户名没有 提示注册
//2.密码错误
//3.登入成功
//通过用户名来数据库查询,如果有数据 看密码是否一样
UserDao userDao=new UserDao();
User user = userDao.findUserByUsername(username);
if (user==null){
System.out.println("------该用户尚未注册,请先注册------");
System.out.println("-------请输入注册名:---------------");
String name=input.next();
System.out.println("-------请输入注册密码:-------");
String pw=input.next();
userDao.charu(name,pw);
}else if(user.getPassword().equals(password)){
System.out.println("----欢迎来到音乐管理系统--------");
musicSystem(user);
flag=false;
}else {
// System.out.println("------密码错误,请重新输入--------");
throw new LoginException("登入失败");
}
}
}
public static void musicSystem(User user) throws SQLException, ClassNotFoundException {
Scanner input =new Scanner(System.in);
System.out.println("1.音乐查询 2.音乐添加 3.音乐修改 4.音乐删除 5.退出");
int choice=input.nextInt();
MusicDao musicDao=new MusicDao();
switch (choice){
case 1:
//1.音乐查询
List<Music> musics = musicDao.findMusics();
System.out.println(musics);
break;
case 2:
if (user.getType()!=0){
System.out.println("权限不足,请联系管理员");
break;
}
System.out.println("请输入要插入的音乐名:");
String ym=input.next();
System.out.println("请输入插入的作者名:");
String au=input.next();
musicDao.charu(ym,au);
break;
case 3:
System.out.println("请输入要删除的id:");
int id=input.nextInt();
musicDao.delete(id);
break;
case 4:
System.out.println("请输入要修改的id");
int id1=input.nextInt();
System.out.println("请输入新的音乐名");
String newym=input.next();
System.out.println("请输入新的作者名:");
String newau=input.next();
MusicDao.updateMusic(id1,newym,newau);
break;
case 5:
System.exit(0);
}
}
}
即可