一、往db3数据库中的account表添加数据
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
/**
* account表 添加一条记录 insert 语句
*/
public class demo1 {
public static void main(String[] args){
Statement stmt = null;
Connection conn = null;
try {
//注册驱动
Class.forName("com.mysql.jdbc.Driver");
//定义sql
String sql="insert into account values(null,'王五',3000)";
//获取Connection对象
conn = DriverManager.getConnection("jdbc:mysql:///db3","root","admin");
//获取执行sql的对象,Statement
stmt = conn.createStatement();
//执行sql
int count = stmt.executeUpdate(sql); //count为影响的行数
System.out.println(count);
if(count>0){
System.out.println("添加成功&