java数据库Mysql简单操作-简易银行管理系统

**

java数据库Mysql简单操作-简易银行管理系统

**
主函数代码

public class maintest {

	public static void main(String[] args) {
		execute_operation useropration=new execute_operation();
		try {
			int flag;
			flag=useropration.creat_user("胡广生",  10000);
			System.out.println(flag>0?"success!":"false!");
			flag=useropration.creat_user("任素汐", 10000);
			System.out.println(flag>0?"success!":"false!");
			flag=useropration.creat_user("真真",  10000);
			System.out.println(flag>0?"success!":"false!");
			flag=useropration.creat_user("刘十三",  10000);
			System.out.println(flag>0?"success!":"false!");
			flag=useropration.select_user();
			System.out.println(flag>0?"success!":"false!");
			flag=useropration.pass_user(3);
			System.out.println(flag>0?"success!":"false!");
			flag=useropration.change_money_user(1, 2, 1000);
			System.out.println(flag>0?"success!":"false!");
			flag=useropration.select_user();
			System.out.println(flag>0?"success!":"false!");
			flag=useropration.select_user_id(4);
			System.out.println(flag>0?"success!":"false!");
			
		} catch (Exception e) {
			System.out.println("操作失败！");
			System.out.println("请自检系统运行是否正常！");
			System.out.println(e.getMessage());
		}
		
	}

}

存储用户信息代码

public class user_information {
	private int id;
	private String name;
	private double money;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public double getMoney() {
		return money;
	}
	public void setMoney(double money) {
		this.money = money;
	}
	@Override
	public String toString() {
		return "user_information [id=" + id + ", name=" + name + ", money=" + money + "]";
	}
	
}

功能实现代码

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
public class execute_operation {
	Connection con=null;
	PreparedStatement pta=null;
	PreparedStatement pta1=null;
	ResultSet mis=null;
	public Connection creat_connection() throws ClassNotFoundException, SQLException
	{
		Class.forName("com.mysql.jdbc.Driver");
		con=DriverManager.getConnection("jdbc:MySQL://localhost:3307/bank?useUnicode=true&characterEncoding=utf-8",
				"root","usbw");
		return con;
	}
	public void close()
	{
		try {
			if(con!=null)
				con.close();
			if(pta!=null)
				pta.close();
			if(mis!=null)
				mis.close();
			if(pta1!=null)
				pta1.close();
		} catch (Exception e) {
			System.out.println("关闭异常！");
		}
	}
	public int creat_user(String name,double money) throws ClassNotFoundException, SQLException 
	{
		con=creat_connection();
		String sql="insert into account values(null,?,?)";
		pta=con.prepareStatement(sql);
		pta.setString(1, name);
		pta.setDouble(2,money);
		int result=pta.executeUpdate();
		close();
		return result;
	}
	public int pass_user(int id) throws ClassNotFoundException, SQLException
	{
		con=creat_connection();
		String sql="delete from account where id=?";
		pta=con.prepareStatement(sql);
		pta.setInt(1, id);
		int result=pta.executeUpdate();
		close();
		return result;
	}
	public int change_money_user(int Int_id,int Out_id,double Upmoney) throws ClassNotFoundException, SQLException
	{
		con=creat_connection();
		con.setAutoCommit(false);
		String sql="update account set money=money+? where id=?";
		pta=con.prepareStatement(sql);
		pta1=con.prepareStatement(sql);
		pta.setDouble(1,Upmoney );
		pta.setInt(2, Int_id);
		int r1=pta.executeUpdate();
		pta1.setDouble(1, -Upmoney);
		pta1.setInt(2, Out_id);
		int r2=pta1.executeUpdate();
		if(r1*r2!=0)
		{
			con.commit();
		}
		else 
		{
			con.rollback();
		}
	
		close();
		return r1*r2;
	}
	public int select_user() throws ClassNotFoundException, SQLException
	{
		con=creat_connection();
		String sql="select *from account";
		
		pta=con.prepareStatement(sql);
		mis=pta.executeQuery();
		List<user_information> stulist=new ArrayList<user_information>();
		while(mis.next())
		{
			user_information stu=new user_information();
			stu.setId(mis.getInt(1));
			stu.setName(mis.getString(2));
			stu.setMoney(mis.getDouble(3));
			stulist.add(stu);
		}
		int result=mis!=null?1:0;
		close();
		Iterator<user_information> is=stulist.iterator();
		while(is.hasNext())
		{
			String ty=is.next().toString();//将is指针向后移动。
			System.out.println(ty);
		}
		
		return result;
	}
	public int select_user_id(int id) throws SQLException, ClassNotFoundException
	{
		con=creat_connection();
		String sql="select *from account where id=?";
		pta= con.prepareStatement(sql);
		pta.setInt(1, id);
		mis=pta.executeQuery();
		int result=mis!=null?1:0;
		user_information hook=new user_information();
		while(mis.next())
		{
			hook.setId(mis.getInt(1));
			hook.setName(mis.getString(2));
			hook.setMoney(mis.getDouble(3));
		}
		System.out.println(hook.toString());
		close();
		return result;
		
	}
}