import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBCException {
static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
static final String DB_URL = "jdbc:mysql://127.0.0.1:3306/mldn";//Ĭ��3306
static final String USER = "root";
static final String PASS = "123456";
public static void main(String[] args) {
Connection conn = null;
try {
Class.forName(JDBC_DRIVER);
System.out.println("Connecting to database...");
conn = DriverManager.getConnection(DB_URL, USER, PASS);
System.out.println("Creating statement...");
Statement stmt = conn.createStatement();
String sql = "SELECT * FROM emp";
ResultSet rs = stmt.executeQuery(sql);//���������executeUpdate
while (rs.next()) {
int empno = rs.getInt("empno");//����д1��д��empno�����ݿⶨ��Ľṹȡ
String ename = rs.getString("ename");
String job = rs.getString("job");
System.out.print("empno: " + empno);
System.out.print(", ename: " + ename);
System.out.println(", job: " + job);//����� �ٻ���
}
rs.close();//�������ջ��ƣ����Լ��ز��˷�
stmt.close();
conn.close();//����أ�һ�����ݿ����ӡ�����
} catch (SQLException se) {//����쳣˳���ܻ�
se.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (conn != null) conn.close();//��Ȼ����ʲô��
} catch (SQLException se) {
se.printStackTrace();
}
}
}
}
一是要导包(驱动文件)
2是安装了MYSQL数据库并且导入了数据表;