连接mysql数据库执行写入语句

package insert;

import java.sql.DriverManager;
import java.sql.SQLException;
 
import com.mysql.jdbc.Connection;
 
public class DButil {
		/*
		 * 打开数据库
		 */
	    private static String driver;//连接数据库的驱动
	    private static String url;
	    private static String username;
	    private static String password;
	    
	    static {
	    	driver="com.mysql.jdbc.Driver";//需要的数据库驱动
	    	url="jdbc:mysql://localhost:3306/test?serverTimezone=GMT%2B8&useSSL=false";//数据库名路径
	    	username="root";
	    	password="xxxx";
	    }
		public static Connection open()
		{
			try {
				Class.forName(driver);
				return (Connection) DriverManager.getConnection(url,username, password);
			} catch (Exception e) {
				System.out.println("数据库连接失败！");
				// TODO Auto-generated catch block
				e.printStackTrace();
			}//加载驱动
 
			return null;
		}
        
		/*
		 * 关闭数据库
		 */
		public static void close(Connection conn)
		{
			if(conn!=null)
			{
				try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
 
}

　　需要引入   mysql-connector-java-5.1.45-bin.jar

 

执行类

package insert;

import java.sql.SQLException;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.PreparedStatement;
 
public class jdbcconnection {
 
	public static void main(String[] args) {
		// TODO Auto-generated method stub
       insert("yangxu",1,"beijing","15022009896",false);
	}
 
	static void insert(String name,int age,String address,String phone,boolean flag)
	{
		String sql="insert into student(name,age,address,phone,flag) value(?,?,?,?,?)";
		Connection conn=DButil.open();
		try {
			PreparedStatement pstmt=(PreparedStatement) conn.prepareStatement(sql);
			pstmt.setString(1,name);
			pstmt.setInt(2,age);
			pstmt.setString(3,address);
			pstmt.setString(4,phone);
			pstmt.setBoolean(5, flag);
			pstmt.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally {
			DButil.close(conn);
		}
		
	}
}

　　//实体类

package insert;

public class Customer {
	
	 String name;
	 int age;
	 String address;
	 String phone;
	 boolean flag;
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public int getAge() {
		return age;
	}
	public void setAge(int age) {
		this.age = age;
	}
	public String getAddress() {
		return address;
	}
	public void setAddress(String address) {
		this.address = address;
	}
	public String getPhone() {
		return phone;
	}
	public void setPhone(String phone) {
		this.phone = phone;
	}
	public boolean isFlag() {
		return flag;
	}
	public void setFlag(boolean flag) {
		this.flag = flag;
	}
	@Override
	public String toString() {
		return "Customer [name=" + name + ", age=" + age + ", address=" + address + ", phone=" + phone + ", flag="
				+ flag + "]";
	}
	 
	
}