JDBC连接数据库

JDBC连接数据库
首先要有jdbc架包
需要jdbc架包的可以私聊我

简写jdbc:mysql:///lol
jdbc :mysql://ip:3306/lol
IP如果是本地可以是127 .0.0.1或者localhost

package com.cs.model;

import java.sql.DriverManager;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Driver;
import com.mysql.jdbc.Statement;

public class JdbcTest {

	/**
	 * @param args
	 */
	public static void main(String[] args) {

		jdbcDelete(1,"as","as");

	}
	public static void jdbcDelete(int id,String name,String pifu){
		try {
			Class.forName("com.mysql.jdbc.Driver");
			Connection connection = (Connection) DriverManager.getConnection(
					"jdbc:mysql://127.0.0.1:3306/lol", "root", "123456");
			Statement stmt = (Statement) connection.createStatement();
			stmt
					.execute("INSERT INTO hero(id,name,pifu) VALUES("+id+",'"+name+"','"+pifu+"')");
			stmt.close();
			connection.close();

		} catch (Exception e) {
			e.printStackTrace();
		}
	}

}

效果图

重新创建一个方法更简便