简单的数据库处理

1.对数据库表查询处理
        String id="1";  Connection con=getConnection();//getConnection();是连接数据库
    [1] String sql="selcet * from wenxian where id=?";
        PreparedStatement prepStmt=con.prepareStatement(sql);
        prepStmt.setString(1,id);
        ResultSet rs=prepStmt.executeQuery();
    [2] String sql="select * from wenxian where id='"+id+"'";
        Statement stmt=con.createStatement();
        ResultSet rs=stmt.executeQuery(sql);
    [3] //查询前10条记录 按时间倒排
        String sql="select top 10 * from wenxian order by date desc";
2.对数据库表删除处理
        String sql="delete from wenxian where id='"+id+"'";
        Statement stmt=con.createStatement();
        stmt.executeUpdate(sql);
3.对数据库表的添加处理
             String id="1";String name="yihuei";String tetcont="nihao";
        [1] String sql="insert into wenxian(id,name,tetcont) values(?,?,?)";
            PreparedStatement prepStmt=con.prepareStatement(sql);
            prepStmt.setString(1,id);
            prepStmt.setString(2,name);
            prepStmt.setString(3,tetcont);
            prepStmt.executeQuery();
        [2] String sql="insert into wenxian(id,name,tetcont) values('"+id+"','"+name+"','"+tetcont+"')";
            Statement stmt=con.createStatement();
            stmt.executeUpdate(sql);