快速学习搭建shopping网上商城笔记day01

day01

网上商城
spring3.2+hibernate4.1.1+mysql+ExtJs4.1
不用xml配置文件方式，用annotation的方式
开发速度快，效率高
开发工具：eclipse jdk spket extjs mysql spring

ExtJs 配置 我用的4.2版本的，已经出到6.0了
1.下载www.spket.com 下载spket压缩包,解压将里边的文件放到eclipse文件夹下
重启eclipse打开windows中的Preferences,找到spket;选中JavaScript Prefile 新new一个文件。
再将下载好的extjs文件下的extjs-all.jar添加到其中。

DB.java封装数据库连接关闭

package com.bjsxt.shopping.util;
import java.sql.*;
public class DB {

    static{
    
        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
    private DB(){}
    public static Connection getConn(){
        Connection conn=null;
        try{
            conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/mydata?user=root&password=123456");
            
        }catch(SQLException e){
            e.printStackTrace();
        }
        return conn;
    }
    public static void closeConn(Connection conn){
        
            try {
                if(conn!=null){
                conn.close();
                conn=null;
                
                }
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        
    }
    public static Statement getStmt(Connection conn){
        Statement stmt=null;
        try {
            stmt=conn.createStatement();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return stmt;
    }
    
public static PreparedStatement PreparedStemt(Connection conn,String sql){
        PreparedStatement pStmt=null;
        try {
            pStmt=conn.prepareStatement(sql);
            
            
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return pStmt;
    
}
    
    public static void closeStemt(Statement stmt){
        
        try {
            if(stmt!=null){
                stmt.close();
                stmt=null;
            
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    
}
    public static ResultSet executeQuery(Statement stmt,String sql){
        ResultSet rs=null;
        try {
            rs=stmt.executeQuery(sql);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return rs;
    }
public static void closeResultSet(ResultSet rs){
        
        try {
            if(rs!=null){
                rs.close();
                rs=null;
            
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    
}
}

创建数据库信息代码

create database shopping;

use shoppping;

create table ruser
{
id int primary key auto_increment,
username varchar(40),
password varchar(16),
phone varchar(40),
addr varchar(255),
rdate datetime
};

create table category
{
id int primary key auto_increment,
name varchar(255),
descr varchar(255),
pid int,
isleaf int, #0表示leaf 1表示非leaf
grade int
};

create table product
{
id int primary key auto_increment,
name varchar(255),
descr varchar(255),
normalprice double,
memberprice double,
pdate datetime,
categoryid int references catetory(id)
};

create table salesorder
{
id int primary key auto_increment,
userid int,
addr varchar(255),
odate datetime,
status int
};

create table salesitem
{
id int primary key auto_increment,
productid int,
unitprice double,
pcount int,
orderid int
};