change.java

用户需要注册

import java.sql.*;

//修改user表
public class Change {	
	public static boolean updateUser(String name,String password2,String id,String question,String answer,String account,double sum,String shopname,String state)
	{//注册
        boolean flag = false;
        Connection conn = null;
        String username="root";
   	 	String password="111111";
   	 	String url = "jdbc:mysql://localhost:3306/shoppingmall";
   	 try{  
   		 //-------------加载驱动-------------------------   
   		 Class.forName("org.gjt.mm.mysql.Driver").newInstance();
   		 System.out.println("Success loading Mysql Driver!");
   	 }
   	 catch(Exception e){
   		 System.out.println("Error loading Mysql Driver!");
   	 }
   	 try{   
   		 conn = DriverManager.getConnection(url,username,password);
   		 System.out.println("Success connect Mysql Database!"); 
   	}
	 catch(SQLException e){
		 System.out.println(e.getMessage());
  }
	 PreparedStatement pstmt = null;
     int count = 0;
     try
     {
         pstmt = conn.prepareStatement("update user set password=?,id=?,question=?,answer=?,account =?,sum=?,shopname=?,state=? where name='"+name+"'");
         //pstmt.setString(1, name);
         pstmt.setString(1, password2);
         pstmt.setString(2, id);
         pstmt.setString(3, question);
         pstmt.setString(4, answer);
         pstmt.setString(5, account);
         pstmt.setDouble(6, sum);
         pstmt.setString(7, shopname);
         pstmt.setString(8, state);
         count = pstmt.executeUpdate();
         if (count != 0)
         {
             flag = true;
         }
         //conn.commit();
     }
     catch (SQLException e)
     {
         e.printStackTrace();
     }
     finally
     {
         if (null != conn)
         {
             try
             {
                 conn.close();
             }
             catch (SQLException e)
             {
                 e.printStackTrace();
             }
         }
         if (null != pstmt)
         {
             try
             {
                 pstmt.close();
             }
             catch (SQLException e)
             {
                 e.printStackTrace();
             }
         }
     }
     return flag;
 }
	public static boolean updateUser(String name,double sum)
	{//修改金额
        boolean flag = false;
        Connection conn = null;
        String username="root";
   	 	String password="111111";
   	 	String url = "jdbc:mysql://localhost:3306/shoppingmall";
   	 try{  
   		 //-------------加载驱动-------------------------   
   		 Class.forName("org.gjt.mm.mysql.Driver").newInstance();
   		 System.out.println("Success loading Mysql Driver!");
   	 }
   	 catch(Exception e){
   		 System.out.println("Error loading Mysql Driver!");
   	 }
   	 try{   
   		 conn = DriverManager.getConnection(url,username,password);
   		 System.out.println("Success connect Mysql Database!"); 
   	}
	 catch(SQLException e){
		 System.out.println(e.getMessage());
  }
	 PreparedStatement pstmt = null;
     int count = 0;
     try
     {
         pstmt = conn.prepareStatement("update user set sum=?where name='"+name+"'");
         //pstmt.setString(1, name);
         pstmt.setDouble(1, sum);
         //System.out.println("jingle");
         count = pstmt.executeUpdate();
         if (count != 0)
         {
             flag = true;
         }
         //conn.commit();
     }
     catch (SQLException e)
     {
         e.printStackTrace();
     }
     finally
     {
         if (null != conn)
         {
             try
             {
                 conn.close();
             }
             catch (SQLException e)
             {
                 e.printStackTrace();
             }
         }
         if (null != pstmt)
         {
             try
             {
                 pstmt.close();
             }
             catch (SQLException e)
             {
                 e.printStackTrace();
             }
         }
     }
     return flag;
 }
	public static boolean updateUser(String name,String shopname,int state)
	{//店主离线时修改状态
        boolean flag = false;
        Connection conn = null;
        String username="root";
   	 	String password="111111";
   	 	String url = "jdbc:mysql://localhost:3306/shoppingmall";
   	 try{  
   		 //-------------加载驱动-------------------------   
   		 Class.forName("org.gjt.mm.mysql.Driver").newInstance();
   		 System.out.println("Success loading Mysql Driver!");
   	 }
   	 catch(Exception e){
   		 System.out.println("Error loading Mysql Driver!");
   	 }
   	 try{   
   		 conn = DriverManager.getConnection(url,username,password);
   		 System.out.println("Success connect Mysql Database!"); 
   	}
	 catch(SQLException e){
		 System.out.println(e.getMessage());
  }
	 PreparedStatement pstmt = null;
     int count = 0;
     try
     {
         pstmt = conn.prepareStatement("update user set shopname=?,state=? where name='"+name+"'");
         pstmt.setString(1, shopname);
         pstmt.setInt(2, state);
         count = pstmt.executeUpdate();
         if (count != 0)
         {
             flag = true;
         }
         //conn.commit();
     }
     catch (SQLException e)
     {
         e.printStackTrace();
     }
     finally
     {
         if (null != conn)
         {
             try
             {
                 conn.close();
             }
             catch (SQLException e)
             {
                 e.printStackTrace();
             }
         }
         if (null != pstmt)
         {
             try
             {
                 pstmt.close();
             }
             catch (SQLException e)
             {
                 e.printStackTrace();
             }
         }
     }
     return flag;
 }
	public static boolean updateUser(String name,String newaccount,String newpassword)
	{//修改个人资料
        boolean flag = false;
        Connection conn = null;
        String username="root";
   	 	String password1="111111";
   	 	String url = "jdbc:mysql://localhost:3306/shoppingmall";
   	 try{  
   		 //-------------加载驱动-------------------------   
   		 Class.forName("org.gjt.mm.mysql.Driver").newInstance();
   		 System.out.println("Success loading Mysql Driver!");
   	 }
   	 catch(Exception e){
   		 System.out.println("Error loading Mysql Driver!");
   	 }
   	 try{   
   		 conn = DriverManager.getConnection(url,username,password1);
   		 System.out.println("Success connect Mysql Database!"); 
   	}
	 catch(SQLException e){
		 System.out.println(e.getMessage());
  }
	 PreparedStatement pstmt = null;
     int count = 0;
     try
     {
         pstmt = conn.prepareStatement("update user set account=?,password=?where name='"+name+"'");
         //pstmt.setString(1, name);
         pstmt.setString(1, newaccount);
         pstmt.setString(2, newpassword);
         //System.out.println("jingle");
         count = pstmt.executeUpdate();
         if (count != 0)
         {
             flag = true;
         }
         //conn.commit();
     }
     catch (SQLException e)
     {
         e.printStackTrace();
     }
     finally
     {
         if (null != conn)
         {
             try
             {
                 conn.close();
             }
             catch (SQLException e)
             {
                 e.printStackTrace();
             }
         }
         if (null != pstmt)
         {
             try
             {
                 pstmt.close();
             }
             catch (SQLException e)
             {
                 e.printStackTrace();
             }
         }
     }
     return flag;
 }
	public static boolean updateUser1(String name,String newpassword)
	{//修改密码
        boolean flag = false;
        Connection conn = null;
        String username="root";
   	 	String password1="111111";
   	 	String url = "jdbc:mysql://localhost:3306/shoppingmall";
   	 try{  
   		 //-------------加载驱动-------------------------   
   		 Class.forName("org.gjt.mm.mysql.Driver").newInstance();
   		 System.out.println("Success loading Mysql Driver!");
   	 }
   	 catch(Exception e){
   		 System.out.println("Error loading Mysql Driver!");
   	 }
   	 try{   
   		 conn = DriverManager.getConnection(url,username,password1);
   		 System.out.println("Success connect Mysql Database!"); 
   	}
	 catch(SQLException e){
		 System.out.println(e.getMessage());
  }
	 PreparedStatement pstmt = null;
     int count = 0;
     try
     {
         pstmt = conn.prepareStatement("update user set password=?where name='"+name+"'");
         pstmt.setString(1, newpassword);
         //System.out.println("jingle");
         count = pstmt.executeUpdate();
         if (count != 0)
         {
             flag = true;
         }
         //conn.commit();
     }
     catch (SQLException e)
     {
         e.printStackTrace();
     }
     finally
     {
         if (null != conn)
         {
             try
             {
                 conn.close();
             }
             catch (SQLException e)
             {
                 e.printStackTrace();
             }
         }
         if (null != pstmt)
         {
             try
             {
                 pstmt.close();
             }
             catch (SQLException e)
             {
                 e.printStackTrace();
             }
         }
     }
     return flag;
 }
	
	public static boolean updateUser2(String name,String newaccount)
	{//修改账号
        boolean flag = false;
        Connection conn = null;
        String username="root";
   	 	String password1="111111";
   	 	String url = "jdbc:mysql://localhost:3306/shoppingmall";
   	 try{  
   		 //-------------加载驱动-------------------------   
   		 Class.forName("org.gjt.mm.mysql.Driver").newInstance();
   		 System.out.println("Success loading Mysql Driver!");
   	 }
   	 catch(Exception e){
   		 System.out.println("Error loading Mysql Driver!");
   	 }
   	 try{   
   		 conn = DriverManager.getConnection(url,username,password1);
   		 System.out.println("Success connect Mysql Database!"); 
   	}
	 catch(SQLException e){
		 System.out.println(e.getMessage());
  }
	 PreparedStatement pstmt = null;
     int count = 0;
     try
     {
         pstmt = conn.prepareStatement("update user set account=?where name='"+name+"'");
         pstmt.setString(1, newaccount);
         //System.out.println("jingle");
         count = pstmt.executeUpdate();
         if (count != 0)
         {
             flag = true;
         }
         //conn.commit();
     }
     catch (SQLException e)
     {
         e.printStackTrace();
     }
     finally
     {
         if (null != conn)
         {
             try
             {
                 conn.close();
             }
             catch (SQLException e)
             {
                 e.printStackTrace();
             }
         }
         if (null != pstmt)
         {
             try
             {
                 pstmt.close();
             }
             catch (SQLException e)
             {
                 e.printStackTrace();
             }
         }
     }
     return flag;
 }
	public static boolean updateUser(String name,int state1)
	{
        boolean flag = false;
        Connection conn = null;
        String username="root";
   	 	String password="111111";
   	 	String url = "jdbc:mysql://localhost:3306/shoppingmall";
   	 try{  
   		 //-------------加载驱动-------------------------   
   		 Class.forName("org.gjt.mm.mysql.Driver").newInstance();
   		 System.out.println("Success loading Mysql Driver!");
   	 }
   	 catch(Exception e){
   		 System.out.println("Error loading Mysql Driver!");
   	 }
   	 try{   
   		 conn = DriverManager.getConnection(url,username,password);
   		 System.out.println("Success connect Mysql Database!"); 
   	}
	 catch(SQLException e){
		 System.out.println(e.getMessage());
  }
	 PreparedStatement pstmt = null;
     int count = 0;
     try
     {
         pstmt = conn.prepareStatement("update user set state=?where name='"+name+"'");
         //pstmt.setString(1, name);
         pstmt.setDouble(1, state1);
         //System.out.println("jingle");
         count = pstmt.executeUpdate();
         if (count != 0)
         {
             flag = true;
         }
         //conn.commit();
     }
     catch (SQLException e)
     {
         e.printStackTrace();
     }
     finally
     {
         if (null != conn)
         {
             try
             {
                 conn.close();
             }
             catch (SQLException e)
             {
                 e.printStackTrace();
             }
         }
         if (null != pstmt)
         {
             try
             {
                 pstmt.close();
             }
             catch (SQLException e)
             {
                 e.printStackTrace();
             }
         }
     }
     return flag;
 }
}