testcondb.java

来自「本远程教育系统是采用jsp技术配合SqlServer 2000数据库和Tomca」· Java 代码 · 共 24 行

package condb;
import condb.ConDB;
import java.sql.*;
public class TestConDB{
	public static void main(String args[]){
		ConDB condb = new ConDB();		
		ResultSet rs = null;
		String name = "(,hello,,world,)";
		String sql = "select * from users where user_id in"+name;		
		try{
			rs=condb.getRs("select * from users");
			while(rs.next()){
				System.out.println(rs.getString(4));
			}
		}
		catch(Exception e){
			System.err.println(e.getMessage());
		}
		finally{
			condb.close();
		}
		
	}
}