以下查询修改操作基于上图数据库:
package 数据库;
import java.sql.*;
import java.util.Scanner;
public class online {
public static void main(String[] args) {
// TODO Auto-generated method stub
String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbURL="jdbc:sqlserver://localhost:1433;DatabaseName=test1";
String userName="李奎超"; //默认用户名
String userPwd="123123123"; //密码
try{
Class.forName(driverName); //获取驱动
Connection con=DriverManager.getConnection(dbURL,userName,userPwd); //与驱动建立连接
System.out.println("成功加载MYSQL驱动!");
//---------------------------查询数据的代码-----------------------------
Statement st=con.createStatement();
String sqlStr1="select cname,cnum,csex from customer";//要执行的SQL
ResultSet rs=st.executeQuery(sqlStr1); //执行查询
System.out.println("--------------------查询数据的代码------------------------");
System.out.println("姓名\t"+"编号\t"+"性别\t");
while(rs.next()){
System.out.printf(rs.getString(1)+"\t");
System.out.printf(rs.getString(2)+"\t");
System.out.printf(rs.getString(3)+"\t");
System.out.println();
}
System.out.println("查询成功!");
//---------------------------修改数据的代码-----------------------------
System.out.println("--------------------修改数据的代码----------------");
String sqlStr2="update customer set cname=? where cnum=?";
PreparedStatement pst=con.prepareStatement(sqlStr2);
pst.setString(1, "张继科");
pst.setString(2, "123");
pst.executeUpdate();
System.out.println("修改成功!");
//---------------------------删除数据的代码---------------------------
System.out.println("--------------------删除数据的代码----------------");
String sqlStr3="delete from customer where cname=?";
pst=con.prepareStatement(sqlStr3);
pst.setString(1, "小杨");
pst.executeUpdate();
System.out.println("删除成功!");
//---------------------------查询删除以后的数据的代码-----------------------------
ResultSet rs2=st.executeQuery(sqlStr1);
System.out.println("姓名\t"+"编号\t"+"性别\t");
while(rs2.next()){
System.out.printf(rs2.getString(1)+"\t");
System.out.printf(rs2.getString(2)+"\t");
System.out.printf(rs2.getString(3)+"\t");
System.out.println();
}
rs.close();
st.close();
con.close();
}catch(Exception e){
System.out.println("连接失败!");
}
}
}