1. 下载jdbc连接jar包
2.导入jar包
- msbase.jar、mssqlserver.jar,msutil.jar for sqlserver
- mysql-connector-java-3.0.16-ga-bin.jar for mysql
3.连sqlserver查询
import java.sql.*;
public class Hello {
private static Connection con;
private static Statement stmt;
private static ResultSet rst;
public static void main(String[] args) {
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MyDB","sa","1234");
stmt = con.createStatement();
rst = stmt.executeQuery("select * from Users;");
while(rst.next())
{
System.out.println();
System.out.println(rst.getInt("UserID"));
System.out.println(rst.getString("Username"));
System.out.println(rst.getString("Password"));
System.out.println(rst.getString("Email"));
System.out.println(rst.getString("Address"));
System.out.println();
}
} catch (SQLException ex) {
ex.printStackTrace();
} catch (InstantiationException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IllegalAccessException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
if(!con.isClosed())
con.close();
if(!rst.isClosed())
rst.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
输出:
4.连接mysql查询
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Hello2 {
private static Connection con;
private static Statement stmt;
private static ResultSet rst;
public static void main(String[] args) {
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql://localhost/test?user=root&password=root");
stmt = con.createStatement();
rst = stmt.executeQuery("select * from Employee;");
while(rst.next())
{
System.out.println();
System.out.println(rst.getInt("EmployeeID"));
System.out.println(rst.getString("EmployeeName"));
System.out.println(rst.getString("EmployeePhone"));
System.out.println(rst.getString("EmployeeAddress"));
System.out.println(rst.getString("EmployeeCreateDate"));
System.out.println();
}
} catch (SQLException ex) {
ex.printStackTrace();
} catch (InstantiationException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IllegalAccessException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
if(!con.isClosed())
con.close();
//if(!rst.isClosed())
//rst.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
输出:
话说mysql IDE很高大上的感觉!
总结:
1.自己写JDBC的底层很繁琐,于是有了Hibernate等ORM框架,下一节学习之。
2.MySql其实很强大,与sql server 语法差别并不大,值得学习。