【Java开源代码栏目提醒】:网学会员鉴于大家对Java开源代码十分关注,论文会员在此为大家搜集整理了“updateData.java”一文,供大家参考学习
import java.sql.*;
import java.io.*;
public class updateData {
public static void main(String[] args) {
Connection con=null;
Statement stmt;
String sqlString;
int k;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:forStudy","","");
//SQL命令字符串
sqlString="update student set sex='女' where sex='男'";
stmt=con.createStatement();
//执行SQL命令
k=stmt.executeUpdate(sqlString);
System.out.println("修改了"+k+"条记录");
}catch(Exception e){
e.printStackTrace();
}finally{
try{
con.close();
}catch(SQLException e){
e.printStackTrace();
}
}
}
}