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();
}
}
}
效果图
重新创建一个方法更简便