数据库连接Statement对象

在Eclipse中构建路径MySQL数据库JDBC驱动mysql-connector-java-5.1.39-bin.jar

C:\Program Files (x86)\MySQL\Connector.J 5.1\mysql-connector-java-5.1.39-bin.jar

数据库：MySQL

znzn/tb1

Eclipse:.java

package zn;

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

public class database2 {

	public static void main(String[] args) throws SQLException {
		// TODO Auto-generated method stub
		//数据库MySQL,用statement对象来执行对表的插入并输出
		//3306 数据库端口  znzn数据库名  root 数据库管理员 123456数据库密码
		String driver="com.mysql.jdbc.Driver";
		String url="jdbc:mysql://localhost:3306/znzn";
		String username="root";
		String password="123456";
		String sql3="insert into tb1(id, name)value(6,'damao')";
		Connection conn=null;
		Statement stmt=null;
		int n;
		try{
			Class.forName(driver);
			conn=DriverManager.getConnection(url,username,password);
			stmt=conn.createStatement();
			n=stmt.executeUpdate(sql3);
			if(n==0){
				System.out.println("没有成功");
			}else{
				System.out.println("添加成功");
			}
			stmt.close();
			conn.close();
		}catch(ClassNotFoundException e){
			e.printStackTrace();
		}catch (SQLException e) {
			// TODO: handle exception
			e.printStackTrace();
		}
	}

}