连接数据库.txt

来自「用Eclipse里面的SWT控件对连接数据库的实现」· 文本 代码 · 共 36 行

import java.sql.*;

public class zxj {
	public static void main(String arg[])
	{
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection con=DriverManager.getConnection("jdbc:odbc:test");
			Statement stmt=con.createStatement();
			ResultSet rs=stmt.executeQuery("SELECT * FROM student");
			String id,name,home,department;
			int age;
			while(rs.next())
			{
				id =rs.getString("id");
				name=rs.getString("name");
				age=rs.getInt("age");
				home=rs.getString("home");
				department=rs.getString("department");
				System.out.println(id+name+age+"\t"+home+department);
			}
			rs.close();
			stmt.close();
			con.close();
		}
		catch(ClassNotFoundException e)
		{
			System.out.println("错误: "+e);
		}
		catch(SQLException e)
		{
			System.out.println("错误: "+e);
		}
	}
}