SQL,数据库操作语言,全面测试汇总:example:
section:
String sql="SELECT * FROM tbl_stugrade where math>? or lang>? LIMIT 10";
ps=conn.prepareStatement(sql);
ps.setInt(1, name);
ps.setInt(2, id);
rs=ps.executeQuery();
section:
String sql="SELECT * FROM tbl_stugrade where name like ?";
ps=conn.prepareStatement(sql);
ps.setString(1, "%"+name+"%");
//ps.setInt(2, id);
rs=ps.executeQuery();
section:
String sql="SELECT * FROM tbl_stugrade where not name like ?";
ps=conn.prepareStatement(sql);
ps.setString(1, "%"+name+"%");
//ps.setInt(2, id);
rs=ps.executeQuery();
section:
String sql="SELECT * FROM tbl_stugrade where not name like ? and math>?";
ps=conn.prepareStatement(sql);
ps.setString(1, "%"+name+"%");
ps.setInt(2, id);
rs=ps.executeQuery();
section:
String sql="SELECT * FROM tbl_stugrade where not name like ? and math>? limit ?";
ps=conn.prepareStatement(sql);
ps.setString(1, "%"+name+"%");
ps.setInt(2, id);
ps.setInt(3, count);
rs=ps.executeQuery();
section:
String sql="ALTER TABLE tbl_stugrade ADD native varchar(50) null";
ps=conn.prepareStatement(sql);
ps.executeUpdate();
section:
String sql="UPDATE tbl_stugrade set native=? where id=?";
ps=conn.prepareStatement(sql);
ps.setString(1, name);
ps.setInt(2, id);
ps.executeUpdate();
section:
String sql="insert into tbl_sports values(?,?,?,?,?,?,?,?) ";
ps=conn.prepareStatement(sql);
ps.setInt(1, id);
ps.setString(2, classT);
ps.setString(3, name);
ps.setString(4, sex);
ps.setInt(5, age);
ps.setInt(6, jump);
ps.setInt(7, power);
ps.setInt(8, stamina);
ps.executeUpdate();
section:
String sql="SELECT * FROM tbl_sports ,tbl_stugrade where tbl_sports.name like ? and tbl_sports.power > ? "
+ "limit 5 ";
ps=conn.prepareStatement(sql);
ps.setString(1, "%"+name+"%");
ps.setInt(2, power);
//ps.setInt(3, count);
//ps.setInt(4, power);
rs=ps.executeQuery();
section:
String sql="SELECT tbl_sports.power,tbl_stugrade.math,tbl_stugrade.id, tbl_stugrade.sex,tbl_stugrade.age,tbl_stugrade.name FROM tbl_sports"
+",tbl_stugrade where tbl_sports.name like ? and tbl_sports.power > ? "+ "limit 5 ";
ps=conn.prepareStatement(sql);
ps.setString(1, "%"+name+"%");
ps.setInt(2, power);
//ps.setInt(3, count);
//ps.setInt(4, power);
rs=ps.executeQuery();
section:
String sql="SELECT tbl_stugrade.*,tbl_sports.power FROM tbl_stugrade INNER JOIN tbl_sports "
+ "on tbl_stugrade.name=tbl_sports.name ORDER BY tbl_stugrade.id";
ps=conn.prepareStatement(sql);
//ps.setString(1, "%"+name+"%");
//ps.setInt(1, id);
//ps.setInt(2, id2);
//ps.setInt(3, count);
//ps.setInt(4, power);
rs=ps.executeQuery();
section:
String sql="SELECT stu.*,sp.power,sp.jump,sp.classT FROM tbl_stugrade as stu INNER JOIN tbl_sports as sp"
+ " on stu.name=sp.name ORDER BY sp.id";
ps=conn.prepareStatement(sql);
//ps.setString(1, "%"+name+"%");
//ps.setString(1, name);
//ps.setString(2, name2);
//ps.setInt(3, count);
//ps.setInt(4, power);
rs=ps.executeQuery();