- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.SQLException;
- import java.sql.Statement;
- public class Test {
- public static void main(String[] args) {
- Connection conn = null;
- try {
- //使用jdbc加载数据库驱动
- Class.forName("com.mysql.jdbc.Driver");
- //使用jdbc获取数据库连接
- conn = DriverManager.getConnection("jdbc:mysql:///product", "账号", "密码");
- String sql = "insert into product(productname,productprice,typeid,provider) value ('复读机','105','3','恒大电子')";
- Statement stat = conn.createStatement();
- stat.executeUpdate(sql);
- } catch (Exception e) {
- e.printStackTrace();
- } finally {
- System.out.println("关闭资源!");
- try {
- conn.close();
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
- }
- }
- //该片段来自于http://www.codesnippet.cn/detail/1010201513778.html
来源: http://www.codesnippet.cn/detail/1010201513778.html