java中怎样向SQLserver中插入数据

（最基本的连接方法）

1。获取连接

获取连接需要两步，

一是使用DriverManager来注册驱动（Class.forName(“com.mysql.jdbc.Driver”)），二是使用DriverManager来获取Connection对像DriverManager.getConnection(url,username,password)

2.获取Statement（Statement stmt =con.createStatement()）

Statement就是执行sql语句的；

3.执行sql语句

String sql = “insertinto user value(’zhangSan’, ’123’)”

int m =stmt.executeUpdate(sql)

//总代码如下

      publicstatic Connection getConnection() throws Exception  {    

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

          String url = "jdbc:mysql://localhost:3306/mydb1"  

          return DriverManager.getConnection(url,  "root", "123")  

             }     

      @Test 

     publicvoid insert() throws Exception  { 

    Connection con = getConnection()  

     Statement stmt = con.createStatement() 

      String sql = "insert into user values('zhangSan', '123')"  

     stmt.executeUpdate(sql)

      System.out.println("插入成功！")  

        }

从M$网站下载最新JDBC驱动或都使用maven:

<dependency>

<groupId>com.microsoft.sqlserver</groupId>

<artifactId>mssql-jdbc</artifactId>

<version>9.4.1.jre11</version>

</dependency>

import java.sql.Connection

import java.sql.DriverManager

import java.sql.PreparedStatement

import java.sql.ResultSet

import java.sql.Statement

public class SQLDatabaseConnection {

// Connect to your database.

// Replace server name, username, and password with your credentials

public static void main(String[] args) {

String connectionUrl =

"jdbc:sqlserver://yourserver.database.windows.net:1433"

+ "database=AdventureWorks"

+ "user=yourusername@yourserver"

+ "password=yourpassword"

+ "encrypt=true"

+ "trustServerCertificate=false"

+ "loginTimeout=30"

String insertSql = "INSERT INTO SalesLT.Product (Name, ProductNumber, Color, StandardCost, ListPrice, SellStartDate) VALUES "

+ "('NewBike', 'BikeNew', 'Blue', 50, 120, '2016-01-01')"

ResultSet resultSet = null

try (Connection connection = DriverManager.getConnection(connectionUrl)

PreparedStatement prepsInsertProduct = connection.prepareStatement(insertSql, Statement.RETURN_GENERATED_KEYS)) {

prepsInsertProduct.execute()

// Retrieve the generated key from the insert.

resultSet = prepsInsertProduct.getGeneratedKeys()

// Print the ID of the inserted row.

while (resultSet.next()) {

System.out.println("Generated: " + resultSet.getString(1))

}

}

// Handle any errors that may have occurred.

catch (Exception e) {

e.printStackTrace()

}

}

}

---