MySQL数据库的增删查修

准备：

创建数据库kuai_di

在该数据库下创建表user

并根据数据库表创建bean类User:

package cn.hpu.edu.android.dao;

public class User {
	private int id ;
	private String username;
	private String password;
	private String phoneNumber;
	public User(String username,String password,String phonenumber){
		this.username  = username;
		this.password = password;
		this.phoneNumber = phonenumber;
	}
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	public String getPhoneNumber() {
		return phoneNumber;
	}
	public void setPhoneNumber(String phoneNumber) {
		this.phoneNumber = phoneNumber;
	}
}

第一步：

导入连接mySql数据库的驱动包

mysql-connector-java-5.0.6-bin.jar

可以在我的下载资源中下载

第二步：

编写连接数据库的类JdbcConnection

package cn.hpu.edu.android.util;

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

public class JdbcConnection {
	private final static String driver = "com.mysql.jdbc.Driver";//连接mySql数据库的驱动
	private final static String url = "jdbc:mysql://localhost:3306/kuai_di";//
	private final static String user = "root";
	private final static String password = "113914";
	static {

		try {
			Class.forName(driver);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	public static Connection getConnection(){
		Connection conn = null;

		try {
			conn = DriverManager.getConnection(url,user,password);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		return conn;


	}
	public static void close(Connection conn){
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}

第三步：编写增删改查的ManagerUser_serviceImpl类

package cn.hpu.edu.android.service.impl;

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

import cn.hpu.edu.android.dao.User;
import cn.hpu.edu.android.service.ManagerUser_Service;
import cn.hpu.edu.android.util.JdbcConnection;

public class ManagerUser_ServiceImpl implements ManagerUser_Service{
	private Connection conn = null;
	private PreparedStatement pst = null;
	@Override
	public boolean addUser(User user) {
		conn = JdbcConnection.getConnection();

		String sql = "insert into user(username,password,phonenumber) value(?,?,?)";
		try {
			pst = conn.prepareStatement(sql);
			pst.setString(1, user.getUsername());
			pst.setString(2, user.getPassword());
			pst.setString(3, user.getPhoneNumber());

			int low = pst.executeUpdate();
			if(low>0){
				return true;
			}
			pst.close();

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			JdbcConnection.close(conn);
		}
		return false;
	}

	@Override
	public boolean checkLogin(String username, String pwd) {
		// TODO Auto-generated method stub
		return false;
	}

	@Override
	public boolean findUserbyUsername(String username) {
		// TODO Auto-generated method stub
		return false;
	}



}