insert.java

实现从某个网站的全部遍历

package com.yinyueku;

import java.sql.*;

public class Insert {

	/**
	 * @param args
	 * @throws ClassNotFoundException
	 * @throws SQLException
	 */
	String searchUrl;

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

			Connection con = DriverManager
					.getConnection(
							"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=chenlei",
							"sa", "12345");
			System.out.println(con.getCatalog());
			Statement stmt = con.createStatement();
			//stmt.executeUpdate("CREATE TABLE SINGERS "
			//		+ "(SINGER_NAME VARCHAR(32), SINGER_URL VARCHAR(64))");

			//System.out.println("Creat table ok!");

			String sql = "SELECT * FROM SINGERS001";
			System.out.println(sql);
			ResultSet rs = stmt.executeQuery(sql);
			//ResultsetMetaData rsmd=rs.getMetaData();
			// rsmd.getColumnCount(); //返回结果集中的列数
			// rsmd.getColumnLabel(1); //返回第一列的列名（字段名）
			// for(int i=1; i<=rs.getMetaData().getColumnCount(); i++)
			// //跟踪显示各个列的名称
			// { System.out.print(rs. getColumnName(i)+"\t");
			// }
			while (rs.next()) { // 跟踪显示各个列的值
				String searchName=rs.getString("SINGER_NAME");
				String searchUrl=rs.getString("SINGER_URL");
			    System.out.println(searchName +":"+ searchUrl);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}