java对sql server的增删改查操作
时间: 2023-08-23 07:05:07 浏览: 133
Java对SQL Server数据库的增删改查操作可以使用JDBC进行实现,以下是一个简单的示例代码:
1. 连接数据库
```
String url = "jdbc:sqlserver://localhost:1433;DatabaseName=test";
String username = "username";
String password = "password";
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn = DriverManager.getConnection(url, username, password);
```
2. 插入数据
```
String sql = "INSERT INTO table_name (column1, column2, column3) VALUES (?, ?, ?)";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, "value1");
pstmt.setInt(2, 2);
pstmt.setDouble(3, 3.14);
pstmt.executeUpdate();
```
3. 查询数据
```
String sql = "SELECT * FROM table_name WHERE column1 = ?";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, "value1");
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
String column1 = rs.getString("column1");
int column2 = rs.getInt("column2");
double column3 = rs.getDouble("column3");
// do something with the data
}
```
4. 更新数据
```
String sql = "UPDATE table_name SET column1 = ? WHERE column2 = ?";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, "new_value");
pstmt.setInt(2, 2);
pstmt.executeUpdate();
```
5. 删除数据
```
String sql = "DELETE FROM table_name WHERE column1 = ?";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, "value1");
pstmt.executeUpdate();
```
注意:在实际使用中,需要根据具体的情况修改SQL语句和参数。同时,还需要进行异常处理和资源释放等操作。