Statement接口

package jdbc;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * Statement接口 表示数据库的状态
 * @author Administrator
 *
 */
public class StatementTest {

	public static void main(String[] args) {
		//获取数据库连接对象
		Connection conn = JDBCUtil.getConnection();


		/*******插入数据*************/
//		//String sql="INSERT INTO score(sno,sname,score) values('200608001','wuyu',88)";
//		String sno="200608002";
//		String sname="吴予";
//		String score="88.8";
//		String sql="INSERT INTO score(sno,sname,score) values('"+sno+"','"+sname+"',"+score+")";
//		System.out.println("sql:"+sql);

		/*******更新数据*************/
//		double score=99;
//		String sql="UPDATE score SET score="+score+" WHERE sno='200608002'";
//		System.out.println(sql);

		/***********删除数据***************/
		String sql="DELETE FROM score WHERE sno='20060'";


		try {
			//获取statement接口
			Statement stmt = conn.createStatement();
			 //返回更新记录的条数
			int result = stmt.executeUpdate(sql);
			System.out.println("更新了:"+result+" 条数据！");
		} catch (SQLException e) {
			e.printStackTrace();
		}
		JDBCUtil.close(null, stmt, conn);
	}

}