标准-JDBC-项目示例一

1.软件包规范的结构:

2.开始步骤顺序:

3.代码示范:

package com.yunhe.bean;

public class BanJi {
	private int id;
	private String name;

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public BanJi() {
		super();
		// TODO Auto-generated constructor stub
	}

	public BanJi(int id, String name) {
		super();
		this.id = id;
		this.name = name;
	}

	@Override
	public String toString() {
		return "BanJi [id=" + id + ", name=" + name + "]";
	}

}

-----------------------------

<span style="font-size:18px;">package com.yunhe.util;

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

public class JDBCUtil {
	private static String url;
	private static String user;
	private static String password;
	static {
		try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public static Connection getConnection() throws SQLException {
		Properties properties = new Properties();
		try {
			properties
					.load(new FileInputStream(new File("cfg/jdbc.properties")));
			url = properties.getProperty("url");
			user = properties.getProperty("user");
			password = properties.getProperty("password");
		} catch (IOException e) {
			e.printStackTrace();
		}

		return DriverManager.getConnection(url, user, password);

	}

	public static void free(ResultSet rs, Statement stmt, Connection conn) {
		try {
			if (rs != null)
				rs.close();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			rs = null;
			try {
				if (stmt != null)
					stmt.close();
			} catch (SQLException e) {
				e.printStackTrace();
			} finally {
				stmt = null;
				try {
					if (conn != null)
						conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				} finally {
					conn = null;
				}
			}
		}

	}

}
</span>

--------------------------

package com.yunhe.dao;

import java.sql.SQLException;
import java.util.List;

import com.yunhe.bean.BanJi;

public interface BanJiDao {
	public abstract int addBanJi(String sql) throws SQLException;

	public int editBanJiById(String sql) throws SQLException;

	public int delBanJiById(String sql) throws SQLException;

	public BanJi findBanJiById(String sql) throws SQLException;

	public List<BanJi> findAllBanJi(String sql) throws SQLException;

}

-------------------------

package com.yunhe.dao.impl;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import com.yunhe.bean.BanJi;
import com.yunhe.dao.BanJiDao;
import com.yunhe.util.JDBCUtil;

public class BanJiDaoImpl implements BanJiDao {

	@Override
	public int addBanJi(String sql) throws SQLException {
		Connection conn = JDBCUtil.getConnection();
		Statement stmt = conn.createStatement();
		int res = stmt.executeUpdate(sql);
		if (1 == res)
			System.out.println("add success");
		return res;
	}

	@Override
	public int editBanJiById(String sql) throws SQLException {
		Connection conn = JDBCUtil.getConnection();
		Statement stmt = conn.createStatement();
		int res = stmt.executeUpdate(sql);
		if (1 == res)
			System.out.println("editBanJi success");
		return res;

	}

	@Override
	public int delBanJiById(String sql) throws SQLException {
		Connection conn = JDBCUtil.getConnection();
		Statement stmt = conn.createStatement();
		int res = stmt.executeUpdate(sql);
		if (1 == res)
			System.out.println("delBanJi success");
		return res;

	}

	@Override
	public BanJi findBanJiById(String sql) throws SQLException {
		Connection conn = JDBCUtil.getConnection();
		Statement stmt = conn.createStatement();
		ResultSet res = stmt.executeQuery(sql);
		BanJi banJi = null;
		while (res.next()) {
			banJi = new BanJi();
			banJi.setId(res.getInt("id"));
			banJi.setName(res.getString("name"));
		}
		return banJi;

	}

	@Override
	public List<BanJi> findAllBanJi(String sql) throws SQLException {
		Connection conn = JDBCUtil.getConnection();
		Statement stmt = conn.createStatement();
		ResultSet res = stmt.executeQuery(sql);
		List<BanJi> banjilist = new ArrayList<BanJi>();
		while (res.next()) {
			BanJi banJi;
			banJi = new BanJi();
			banJi.setId(res.getInt("id"));
			banJi.setName(res.getString("name"));
			banjilist.add(banJi);
		}
		return banjilist;
	}

}

----------------------

package com.yunhe.dao;

import java.sql.SQLException;
import java.util.List;

import org.junit.Test;

import com.yunhe.bean.BanJi;
import com.yunhe.dao.impl.BanJiDaoImpl;

public class BanJiDaoTest {

	@Test
	public void testAddBanJi() {
		BanJiDaoImpl dao = new BanJiDaoImpl();
		try {
			String sql = "insert into tb_banJi(id,name) values(105,'android')";
			dao.addBanJi(sql);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	@Test
	public void testEditBanJiById() {
		BanJiDaoImpl dao = new BanJiDaoImpl();
		try {
			String sql = "update tb_banJi set name='java' where id=1001";
			dao.editBanJiById(sql);
		} catch (SQLException e) {
			e.printStackTrace();
		}

	}

	@Test
	public void testDelBanJiById() {
		BanJiDaoImpl dao = new BanJiDaoImpl();
		try {
			String sql = "delete from tb_banJi where id=105";
			dao.delBanJiById(sql);
		} catch (SQLException e) {
			e.printStackTrace();
		}

	}

	@Test
	public void testFindBanJiById() {
		BanJiDaoImpl dao = new BanJiDaoImpl();
		try {
			String sql = "select id,name from tb_banJi where id=105";
			BanJi res = dao.findBanJiById(sql);
			System.out.println(res);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	@Test
	public void testFindAllBanJi() {
		BanJiDaoImpl dao = new BanJiDaoImpl();
		try {
			String sql = "select id,name from tb_banJi";
			List<BanJi> res = dao.findAllBanJi(sql);
			for (BanJi temp : res)
				System.out.println(temp);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

}

存储账号 密码

<span style="font-size:24px;">url=jdbc:mysql://localhost:3306/test
user=root
password=root</span>