JAVA sql语句动态参数问题

提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

对sql语句设置动态参数

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;public class sqlTest {
static String url = "jdbc:oscar://192.168.1.208:2004/OSRDB";
static String username = "SYSDBA";
static String password = "szoscar55";
public static void main(String[] args) throws Exception{
Class.forName("com.oscar.Driver");
Connection con = DriverManager.getConnection(url, username, password);
DatabaseMetaData data = con.getMetaData();
// String sql = "select * from SINAWEIBO_500 where USER_ID = ?";
PreparedStatement st = con.prepareStatement("select * from SINAWEIBO_500 where MESSAGE_TYPE = ?");
st.setObject(1, "1");
ResultSet rs = st.executeQuery();
while(rs.next()){
System.out.println(rs.getString(2));
}
}}