**
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;
}
}