package pkg;
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Example11_2 {
public static void main(String[] args) {
Connection dbConn = null;
Statement sql;
ResultSet rs = null;
String dbURL = “jdbc:sqlserver://127.0.0.1:1433;DatabaseName=students”;
String userName = “sa”;
String userPwd = “123”;
try {
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
} catch (SQLException e) {
}
if (dbConn == null)
return;
String c1 = “year(birthday)<2000 and month(birthday)>7”;
String c2 = “name Like ‘张_%’”;
String c3 = “height>1.65”;
String sqlStr = “SELECT * FROM Mess where” + c1 + “and” + c2 + “and” &