JDBC连接SQLServer和MySQL基础程序源码.doc

连接SQLServerpackage jdbc.sqlserver.test;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class student_test public static void main(String args) /创建空连接Connection conn = null;/加载数据库驱动try Class.forName(com.microsoft.sqlserver.jdbc.SQLServerDriver); catch (ClassNotFoundException e) e.printStackTrace();/建立数据库连接try conn = DriverManager.getConnection(jdbc:sqlserver:/localhost:1433;DatabaseName=MYDB, sa, 123456); catch (SQLException e) e.printStackTrace();/创建语句String sql = select * from student;/执行语句try Statement stmt = conn.createStatement();ResultSet rs = stmt.executeQuery(sql);/遍历结果集while (rs.next()int id = rs.getInt(id);String name = rs.getString(name);String email = rs.getString(email);System.out.println(id+t+name+t+email); catch (SQLException e) e.printStackTrace();/关闭数据库连接finally if (conn != null)try conn.close(); catch (SQLException e) e.printStackTrace();连接MYSQLpackage jdbc.mysql.test;import java.sql.*;public class StudentTest public static void main(String args) Connection conn = null;try Class.forName(com.mysql.jdbc.Driver); catch (ClassNotFoundException e) e.printStackTrace();try conn = DriverManager.getConnection(jdbc:mysql:/localhost:3306/MYDB, root, 123456); catch (SQLException e) e.printStackTrace();String sql = select * from student;try Statement stmt = conn.createStatement();ResultSet rs = stmt.executeQuery(sql);while (rs.next()int id = rs.getInt(id);String name = rs.getString(name);String email = rs.getString(email);System.out.println(id+t+name+t+email); catch (SQLException e) e.printStackTrace();