javalinksqlserver.java

本程序主要用于JAVA连接 MICROSOFT SQL200 ,献上此代码,供大家参考

import java.sql.*;

public class JavaLinkSQLServer 
{
	public static void main(String[] args) 
	{	String DBdirver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
		String ConnStr = "jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=XX;User=sa;Password=sa";
		Connection conn = null;
		Statement  stmt = null;
		ResultSet  rs = null;
		try{
			Class.forName(DBdirver);
			conn = DriverManager.getConnection(ConnStr);
			stmt = conn.createStatement();
			rs = stmt.executeQuery("select * from Job_Info");
			while(rs.next())
				{
				System.out.println(rs.getString("Job_Name"));
				}catch(ClassNotFoundException ex )
			
						{ex.printStackTrace();}
			
				 catch(SQLException e )
						{
							System.out.println("SQLException:"+e.getMessage());
							System.out.println("SQLState:"+e.getSQLState());
							System.out.println("VenderError:"+e.getErrorCode());

						}finally{
						
								try{
								if(rs != null)
									rs.close();
								rs = null;
								if(stmt != null)
									stmt.close();
								stmt = null;
								if(conn != null)
									conn.close();
								conn = null;
								}catch(SQLException e )
										{
									e.getMessage();
										}
			}
		}
	}