java连接sqlserver数据库增删改查
时间: 2023-04-13 16:01:56 浏览: 79
Java连接SQL Server数据库可以使用JDBC API。以下是增删改查的示例代码:
1. 增加数据:
```
String url = "jdbc:sqlserver://localhost:1433;databaseName=mydatabase";
String user = "username";
String password = "password";
Connection conn = DriverManager.getConnection(url, user, password);
String sql = "INSERT INTO mytable (name, age) VALUES (?, ?)";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, "John");
pstmt.setInt(2, 25);
pstmt.executeUpdate();
```
2. 删除数据:
```
String url = "jdbc:sqlserver://localhost:1433;databaseName=mydatabase";
String user = "username";
String password = "password";
Connection conn = DriverManager.getConnection(url, user, password);
String sql = "DELETE FROM mytable WHERE id=?";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, 1);
pstmt.executeUpdate();
```
3. 修改数据:
```
String url = "jdbc:sqlserver://localhost:1433;databaseName=mydatabase";
String user = "username";
String password = "password";
Connection conn = DriverManager.getConnection(url, user, password);
String sql = "UPDATE mytable SET age=? WHERE name=?";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, 30);
pstmt.setString(2, "John");
pstmt.executeUpdate();
```
4. 查询数据:
```
String url = "jdbc:sqlserver://localhost:1433;databaseName=mydatabase";
String user = "username";
String password = "password";
Connection conn = DriverManager.getConnection(url, user, password);
String sql = "SELECT * FROM mytable WHERE age=?";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, 25);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
int id = rs.getInt("id");
String name = rs.getString("name");
int age = rs.getInt("age");
System.out.println("id: " + id + ", name: " + name + ", age: " + age);
}
```