jdbc结合Service和Dao案例

package com.you.test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import com.you.entity.User;
import com.you.service.UserServiceImp;

public class Jdbc {
   

	private static String url = "jdbc:mysql://192.168.0.117:3306/yq";
	private static String user = "root";
	private static String password = "root";
	private static Connection con = null;
//	private static Statement sta = null;
//	private static PreparedStatement pre = null;
//	private static ResultSet res = null;

	/**
	 * 创建数据库连接
	 * 
	 * @return
	 */
	public static Connection getConnection() {
   
		try {
   
			Class.forName("com.mysql.jdbc.Driver"); // 加载mysql驱动
			con = DriverManager.getConnection(url, user, password);// 调用连接方法并传入参数
		} catch (ClassNotFoundException e) {
   
			e.printStackTrace();
		} catch (SQLException e) {
   
			e.printStackTrace();
		}
		return con;// 返回一个Connection对象
	}

	/**
	 * 关闭连接
	 * 
	 * @param con
	 */
	public static void close(Connection con) {
   // 传入connection对象
		try {
   
			if (con != null) {
    // 保证con对象不为空
				con.close(); // 关闭数据库连接
				System.out.println("数据库断开成功");
			}
		} catch (SQLException e) {
   
			e.printStackTrace();
		}
	}
	public static void main(String[] args) {
   
		/**
		 * 查询所有user
		 */
		
		List<User> userList =new UserServiceImp().getUserList();
		for (User user : userList) {
   
			System.out.println(user.getId() + user.getName() + user.getPassword());
		}
		/**
		 * 根据name删除
		 */if(new UserServiceImp().deleteName(new User("11")