shopregister.java

用户需要注册

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
//店主注册
public class ShopRegister {
	public static final String INSERTUSER = "insert into  shopkeeper(name,password,id,question,answer,shopname,account) values(?,?,?,?,?,?,?)";
	
	public static boolean insertUser(String name, String password2,String id, String question,String answer,String shopname,String account)
    {
        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(INSERTUSER);//预编译方式执行SQL
            pstmt.setString(1, name);
            pstmt.setString(2, password2);
            pstmt.setString(3, id);
            pstmt.setString(7, account);
            pstmt.setString(4, question);
            pstmt.setString(5, answer);
            pstmt.setString(6, shopname);
            count = pstmt.executeUpdate(); // 对数据库内容进行更改，记录操作执行的记录条数
            if (count != 0)
            {
                flag = true;
            }
        }
        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;
    }

}