DBConnect

来源：互联网发布：it 产业链编辑：程序博客网时间：2024/06/16 21:53

package com.test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class DBConnect {

  // String connectionUrl = "jdbc:sqlserver://120.76.97.151:1433;" +
  // "databaseName=TestZhouWei"; // Create a variable for the connection
  // string.
  //String connectionUrl = "jdbc:mysql://localhost:3306/ll";

     public static void main(String arg[]) {
         try {
             Connection con = null; //定义一个MYSQL链接对象
             Class.forName("com.mysql.jdbc.Driver").newInstance(); //MYSQL驱动
             con = DriverManager.getConnection("jdbc:mysql://localhost:3306/ll", "root", "root"); //链接本地MYSQL

Statement stmt; //创建声明
stmt = con.createStatement();

             //新增一条数据
             stmt.executeUpdate("INSERT INTO user (name, password) VALUES ('init2', '123456')");
             ResultSet res = stmt.executeQuery("select LAST_INSERT_ID()");
             int ret_id;
             if (res.next()) {
                 ret_id = res.getInt(1);
                 System.out.print(ret_id);
             }

         } catch (Exception e) {
             System.out.print("MYSQL ERROR:" + e.getMessage());
         }
     }
}

阅读全文

0 0