abc.java

java做的一个选课系统

package db;

import java.sql.*;

public class abc {

	public abc() {
		super();
		// TODO Auto-generated constructor stub
	}

	/**
	 * @param args
	 * @throws SQLException 
	 */
	public static void main(String[] args)  {
		// TODO Auto-generated method stub
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection conn=DriverManager.getConnection("jdbc:odbc:selLesson","sa","123");
			Statement st=conn.createStatement();
			ResultSet rs = st.executeQuery("select * from student");
			while (rs.next()){
				System.out.println(rs.getString("id"));
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		System.out.println("ok");
	}

}