首先我们在本地创建数据库:test
然后创建一张表user
CREATE TABLE `user` (
`id` int(11) NOT NULL,
`age` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
接着在java工程中导入mysql驱动jar包:mysql-connector-java-5.1.37.jar。好了,可以开始编码了:
package interview;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class JdbcTest {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test", "root", "123456");
PreparedStatement ps = con.prepareStatement("insert into user values(?,?)");
ps.setInt(1, 111);
ps.setInt(2, 20);
int result = ps.executeUpdate();
if(result == 1){
System.out.println("插入成功!");
}else{
System.out.println("插入失败");
}
con.close();
}
}
如果执行成功的话,你的数据库中将会增加一行:
id age
111 20