说出一下程序的功能

来源:百度知道 编辑:UC知道 时间:2024/06/18 06:12:54
import java.sql.*;
import javax.swing.*;
class jdbcExample1 {
public static void main(String args[]) {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url ="jdbc:odbc:studyDSN";
String login = "sa";
String password ="";
Connection conn =
DriverManager.getConnection(url,login,password);
Statement statement =conn.createStatement();
String sqlQuery="select * from course";
ResultSet rs= statement.executeQuery(sqlQuery);
while(rs.next()){
System.out.print(rs.getString(1)+" ,");
System.out.print(rs.getString(2)+",");
System.out.println(rs.getInt(3));
}
statement.close();
conn.close();
}
catch ( SQLException sqlException ) {
JOptionPane.

import java.sql.*;
import javax.swing.*;
class jdbcExample1 {
public static void main(String args[]) {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//Java连接odbc数据库
String url ="jdbc:odbc:studyDSN";//连接 studyDSN数据库
String login = "sa";//数据库用户名sa
String password ="";//密码 ""
Connection conn =
DriverManager.getConnection(url,login,password);//打开数据库连接
Statement statement =conn.createStatement();//创建Statement
String sqlQuery="select * from course";//写查询语句,查询course表中所有课程
ResultSet rs= statement.executeQuery(sqlQuery);//执行查询语句
while(rs.next()){//把查询出来的结果循环输出到控制台里
System.out.print(rs.getString(1)+" ,");
System.out.print(rs.getString(2)+",");
System.out.println(rs.getInt(3));
}
statement.close();