Java连接SQL Server数据库

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class ConnectSqlDB {

	/**
	 * @param args
	 * @param SQLEXPRESS
	 */
	// static Connection connect;
	static String sql = "";

	// static String delete = "";
	// static Statement state;
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		Connection connect;
		Statement state;
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");// 加载SQL驱动程序
		} catch (ClassNotFoundException ce) {
			System.out.println("SQLExceptionOn:" + ce.getMessage());
		}

		try {
			String url = "jdbc:odbc:MyDB";
			connect = DriverManager.getConnection(url, "sa", "123456");// 与数据库建立连接
			// System.out.println(111); 测试连接
			state = connect.createStatement();

			ResultSet rs = state.executeQuery("select * from purchase");// 对表purchase进行查询

			System.out.println("purchaseNo" + "    " + "purDay"
					+ "                       " + "purSum" + "    "
					+ "employeeNo" + "    " + "pressNo");

			while (rs.next()) {
				System.out.println(rs.getString(1) 
						+ "\t " + "     " + rs.getString(2) 
						+ "\t " + "  " + rs.getString(3)
						+ "\t " + "    " + rs.getString(4) 
						+ "\t " + "  " + rs.getString(5));
			}

			insert(sql);
			state.executeUpdate(sql);
			System.out.println("插入数据成功");

		    rs.close(); //关闭数据库
			state.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}

	public static void insert(String sql) throws SQLException {

		sql = "INSERT INTO Press(pressNo, pressName,preAddress,zipCode,telephone)"
				+ " VALUES ('HJ489201', '曙光音像供应商', '海滨城市', '513400','18218179622')"; // 插入数据的sql语句

	}

}

简单连接SQL Server数据库，中途遇到一个不是问题的问题，坑！