Java寒假19

com.maike.service

UserService

package com.maike.service;

import java.util.List;

import com.maike.model.Trade;
import com.maike.model.TradeDto;

public interface UserService {

int insertUser(String userName,String userPwd,String userRePwd);
int judgeLogin(String userName,String userPwd);

List<Trade> seleTradeAll();
int addTrade(TradeDto tradeDto);
int updateTrade(Trade trade);
int deleteTrade(Integer pid);
Trade getTradeByName(Integer tradeId);

}

 

UserServiceImpe 

package com.maike.service;

import java.util.List;

import com.maike.dao.TradeDao;
import com.maike.dao.TradeDaoImpl;
import com.maike.dao.UserDao;
import com.maike.dao.UserDaoImpl;
import com.maike.model.Trade;
import com.maike.model.TradeDto;
import com.maike.model.User;

public class UserServiceImpe implements UserService {
UserDao userDao = new UserDaoImpl();

@Override
public int insertUser(String userName, String userPwd, String userRePwd) {
// TODO Auto-generated method stub
int k = 0;
if(userName == "" || userName == null || userPwd == "" || userRePwd == null) {
return k;
}
if(!userPwd.equals(userRePwd)) {
return k;
}

k = userDao.insert(userName,userPwd);

return k;
}

@Override
public int judgeLogin(String userName, String userPwd) {
// TODO Auto-generated method stub
int k = 0;
if(userName == "" || userName == null || userPwd == ""|| userPwd == null) {
return k;
}
User user = userDao.selectByName(userName);

if(!userPwd.equals(user.getUserPwd())) {
k = 0;
}else {
k = 1;
}
return k;
}

// private TradeDao tradeDao;
@Override
public List<Trade> seleTradeAll() {
// TODO Auto-generated method stub
TradeDao tradeDao = new TradeDaoImpl();
return tradeDao.selectAll();
}

@Override
public int addTrade(TradeDto tradeDto) {
// TODO Auto-generated method stub
System.out.println("--------------2----------------");
TradeDao tradeDao = new TradeDaoImpl();
int k = 0;
String tradeName = tradeDto.getTradeName();
String tradePrice = tradeDto.getTradePrice();
if(tradeName == null || tradePrice == null) {
return k;
}
// int IntPrice = Integer.parseInt(tradePrice);
Trade trade = new Trade();
trade.setTradeName(tradeName);
trade.setTradePrice(tradePrice);
System.out.println("--------------3----------------");
k = tradeDao.insert(trade);
return k;
}

/**
* updateTrade:修改 .<br/>
*/
@Override
public int updateTrade(Trade trade) {
// TODO Auto-generated method stub
TradeDao tradeDao = new TradeDaoImpl();
return tradeDao.update(trade);
}

/**
* deleteTrade :删除.<br/>
*/
@Override
public int deleteTrade(Integer pid) {
// TODO Auto-generated method stub
TradeDao tradeDao = new TradeDaoImpl();
return tradeDao.delete(pid);
}

@Override
public Trade getTradeByName(Integer tradeId) {
// TODO Auto-generated method stub
TradeDao tradeDao = new TradeDaoImpl();
return tradeDao.selectByName(tradeId);
}

}

 com.maike.util

 ConnectionUtil 

package com.maike.util;

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

public class ConnectionUtil {
private static String url = "jdbc:mysql://localhost:3306/nafeng?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC";
private static String rootName = "root";
private static String rootPwd = "root";

private ConnectionUtil() {};

static {
try {

Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}

/**
* getConnection:.<br/>
* @return
* @throws SQLException
*/
public static Connection getConnection() throws SQLException {
return DriverManager.getConnection(url,rootName,rootPwd);
}

/**
* closeRe:.<br/>
* @param con
* @param pt
* @param rs
*/
public static void closeRe(Connection con,PreparedStatement pt,ResultSet rs) {
if(rs != null) {
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
if(pt != null) {
try {
pt.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
if(con != null) {
try {
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
}
}
}

/**
* closeRe:.<br/>
* @param con
* @param pt
*/
public static void closeRe(Connection con,PreparedStatement pt) {
if(pt != null) {
try {
pt.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
if(con != null) {
try {
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
}

}

 

SetCharacterEncodingFilter

package com.maike.util;

import java.io.IOException;
import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.annotation.WebFilter;

/**
* Servlet Filter implementation class SetCharacterEncodingFilter
*/
@WebFilter("/SetCharacterEncodingFilter")
public class SetCharacterEncodingFilter implements Filter {

/**
* Default constructor.
*/
public SetCharacterEncodingFilter() {
// TODO Auto-generated constructor stub
}

/**
* @see Filter#destroy()
*/
public void destroy() {
// TODO Auto-generated method stub
}

/**
* @see Filter#doFilter(ServletRequest, ServletResponse, FilterChain)
*/
public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain) throws IOException, ServletException {
request.setCharacterEncoding("UTF-8");//
response.setCharacterEncoding("UTF-8");//
chain.doFilter(request, response);//
}

/**
* @see Filter#init(FilterConfig)
*/
public void init(FilterConfig fConfig) throws ServletException {
// TODO Auto-generated method stub
}

}