dbtest.java

动态的树型目录

package com.xial.sqlserver.util;

  
import java.sql.*;  


public class DbTest {
	Connection con;

	Statement sta;

	ResultSet rs;

	String driver;

	String url;

	String user;

	String pwd;

	public DbTest() {
		driver = "sun.jdbc.odbc.JdbcOdbcDriver";
		url = "jdbc:odbc:sqlserver_pubs";
		user = "sa";
		pwd = "";
		init();
	}

	public void init() {
		try {
			Class.forName(driver);
			System.out.println("driver is ok");
			con = DriverManager.getConnection(url, user, pwd);
			System.out.println("conection is ok");
			sta = con.createStatement();
			rs = sta.executeQuery("select * from [dbo].[SQCLUB]");
			System.out.println("ID" + " ||" + " father");
			while (rs.next()){
				System.out.println(rs.getInt("ID") + " ||" + rs.getInt("followid"));
			}
			System.out.println("bb");
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	public static void main(String args[]) {
		new DbTest();
	}
}
																																																																																																																																																																																																																																																																																																																								// {
																																																																																																																																																																																																																																																																																																																								// new
																																																																																																																																																																																																																																																																																																																								// DbTest();
																																																																																																																																																																																																																																																																																																																								// } }