Java连接mysql数据库
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.util.Scanner;
public class TestConnect {
private final static String url = "jdbc:mysql://localhost:3306/test";
private final static String username = "root";
private final static String password = "123456";
public static void main(String[] args) {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (Exception e) {
e.printStackTrace();
}
try {
Connection connect = DriverManager.getConnection(url, username, password);
Statement stmt = connect.createStatement();
Scanner sc = new Scanner(System.in);
int id = sc.nextInt();
String name = sc.next();
float temper = sc.nextFloat();
int number = sc.nextInt();
String sql = "insert into tb1(id,name,temper,number) values ("+id+",'"+name + "',"+temper+","+number+");";
int count = stmt.executeUpdate(sql);
System.out.println(count == 1? "保存成功" : "保存失败");
sc.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}