import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class Mysqltest1 {
public static void main(String[] args) {
// TODO Auto-generated method stub
//java连接数据库 步骤
try{
//1、加载驱动
Class.forName("com.mysql.jdbc.Driver");
//2、获得连接
String url="jdbc:mysql://localhost:3306/mysqldb";//10.25.44.2
String username="root";
String password="lin123";
Connection con=DriverManager.getConnection(url,username,password);
System.out.println(con);
//3、获得执行sql 语句平台
Statement st=con.createStatement();
// 4、执行sql语句 获得结果集 ResultSet
ResultSet rs=st.executeQuery("select * from dept where deptno=10");
//5、处理结果集
while(rs.next()){
System.out.println(rs.getInt("deptno")+","+rs.getString("dname")+","+rs.getString("loc"));
}
//6、关闭连接
rs.close();
st.close();
con.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
