package Bean;

import java.sql.*;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class Insert {
	
		Connection conn = null;
		
//		conn.createStatement().executeUpdate("insert into UsersTable(ID, userName, passWord) values('aaa','bbb','aaa')");
public void Insert(UserBean user)
{
		conn = new DBConn().getConn();
		String sql = null;
		sql = "INSERT INTO users (userName, password,gender,email,telphone,money,usertype) VALUES (?,?,?,?,?,?,?)";
		
		try {
			PreparedStatement ps=conn.prepareStatement(sql);
			
			ps.setString(1, user.getUsername());
			ps.setString(2, user.getPassword());
			ps.setString(3, user.getGender());
			ps.setString(4, user.getEmail());
			ps.setString(5, user.getTelphone());
			ps.setDouble(6, user.getMoney());	
			ps.setString(7, user.getUsertype());
			
			ps.executeUpdate();//
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		System.out.println("數(shù)據(jù)成功插入到數(shù)據(jù)庫中！");
}
public void Clean()
{
	String sql;
	
	try 
	{
		Connection conn=new DBConn().getConn();
		sql = "";
		PreparedStatement ps=conn.prepareStatement(sql);
		ps.execute();
		
		ps.close();
		conn.close();
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
}
}