java与sqlserver 2008_java连接SqlServer2008

package org.apache.hadoop.examples;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.IOException;

import java.lang.reflect.Field;

import java.lang.reflect.Method;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.ArrayList;

import java.util.List;

import java.util.Properties;

public class Sqlhelper {

private static Connection con = null;

private static Statement st = null;

private static ResultSet rs = null;

private static String user = "sa";

private static String url = "jdbc:sqlserver://192.168.2.210:1433;databaseName=LogBase";

private static String password = "Sa123456";

// 得到链接

public static Connection getConnection() throws ClassNotFoundException {

try {

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

con = DriverManager.getConnection(url, user, password);

} catch (SQLException e) {

// TODO Auto-generated catch block

System.out.print("error:connect the sqlserver!!");

con = null;

e.printStackTrace();

}

return con;

}

private static ResultSet search(String sql, Connection con)

throws SQLException {

if (con == null) {

try {

con=getConnection();

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

if (st == null) {

st = con.createStatement();

}

ResultSet rs = st.executeQuery(sql);

return rs;

}

public static ArrayList GetData() throws ClassNotFoundException

{

ArrayList re=new ArrayList();

String sp="select a.PID as ppid,a.ProductID as pid,a.[Level],a.BrandAttr from ProductInfo a,ProductInfo b where a.PID=B.ProductID order by a.[Level]";

try {

rs=search(sp,con);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

try {

int col=rs.getMetaData().getColumnCount();

while(rs.next()){

String ppid = rs.getString("ppid");

String pid = rs.getString("pid");

System.out.println("ppid："+ppid+" pid："+pid);

}

dbclose();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return re;

}

private static void dbclose() {

try {

st.close();

con.close();

} catch (SQLException e) {

e.printStackTrace();

}

st = null;

con = null;

}

}sqljdbc4