change1.java

用户需要注册

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;

//修改shopcar表
public class Change1 {	
	public static boolean updateUser(String name,String shopkeepername,String goodsname)
	{//删除商品
        boolean flag = false;
        Connection conn = null;
		Statement stmt = 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
		{   
			conn = DriverManager.getConnection(url,username,password);
			stmt = conn.createStatement();  //Statement对象用于将sql语句发送到数据库中 
			stmt.executeUpdate("delete FROM shopcar where name = '"+name +"'and goodsname='"+goodsname+"'and shopkeepername='"+shopkeepername+"'");
		}
		catch(SQLException e)
		{
			System.out.println(e.getMessage());
		}
     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 goodsname,String shopkeepername,double price,int number)
	{//商品加入购物车
        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 shopcar set price=?,number=? where name='"+name+"'and shopkeepername = '"+shopkeepername+"' and goodsname = '"+goodsname +"'");
         pstmt.setDouble(1, price);
         pstmt.setInt(2, number);
         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 void main(String [] args){
	}
}