//插入数据

@Test

public void insert() {

Connection connection = null;

Statement statement = null;

try {

Class.forName("com.mysql.jdbc.Driver");

connection = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/test"+"?useUnicode=true&characterEncoding=utf-8","root","root");

statement = (Statement) connection.createStatement();

String sqlString = "insert goods(id,name,price,desp) values(null,'耳机',200,'蓝牙耳机')";

int i = statement.executeUpdate(sqlString);

if (i>0) {

System.out.println("success!");

}

} catch (Exception e) {

e.printStackTrace();

} finally {

if (connection != null) {

try {

connection.close();

} catch (SQLException e1) {

e1.printStackTrace();

}

connection=null;

}

if (statement != null) {

try {

statement.close();

} catch (SQLException e1) {

e1.printStackTrace();

}

statement=null;

}

}

}