SELECT * FROM Products WHERE Product_ID={0} AND Product_Code={1}有这么写SQL的吗?Product_ID='0'都这样的呀 你这样写 "SELECT * FROM Products WHERE Product_ID='"+你的变量+"' AND Product_Code='"+你的变量+"'";
如果是要操作数据库,用PresparedStatemnt,用?代替你的{n} Class.forName("com.mysql.jdbc.Driver"); Connection con = DriverManager.getConnection("jdbc:mysql://localhost/test", "feng", ""); //Statement st = con.createStatement(); PreparedStatement pst = con.prepareStatement("select * from course where cid=?"); //ResultSet rs = st.executeQuery("select * from course"); pst.setString(1, "01"); ResultSet rs = pst.executeQuery(); while(rs.next()){ System.out.println(rs.getString(2)); }如果是纯粹的字符串替换,"...".replace("{0}","val1").replace("{1}","val2")
你这样写
"SELECT * FROM Products WHERE Product_ID='"+你的变量+"' AND Product_Code='"+你的变量+"'";
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/test", "feng", "");
//Statement st = con.createStatement();
PreparedStatement pst = con.prepareStatement("select * from course where cid=?");
//ResultSet rs = st.executeQuery("select * from course");
pst.setString(1, "01");
ResultSet rs = pst.executeQuery();
while(rs.next()){
System.out.println(rs.getString(2));
}如果是纯粹的字符串替换,"...".replace("{0}","val1").replace("{1}","val2")
str.replace("{1}",val1);
在yourString有几个{0},{1},...后面就对应几个就可以了~
这是更一般的情况~