package com.MySQL;
/*
* java 数据库的链接
*/
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class MySQL {
static int a;
public static void main(String[] args){
Connection con = null; //定义与数据库链接的变量
Statement sta = null; //定义操纵sql语句的变量
ResultSet rs = null; //定义返回结果的变量
try{
try{
Class.forName("com.mysql.jdbc.Driver"); //加载mysql数据库的驱动
}catch(ClassNotFoundException e){
System.out.println("驱动没有找到");
}
//与数据库建立连接 getConnertion的三个参数分别是,数据库,账号,密码
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/student1","root","guest");
System.out.println("连接成功!");
sta = con.createStatement();
//通过操纵语句的变量操纵sql语句
rs = sta.executeQuery("select uid , uname from users");
//通过循环遍历把结果返回
while(rs.next()){
a= rs.getInt("uid");
System.out.println(rs.getString("uname"));
System.out.println(rs.getInt("uid"));
}
}catch(Exception e){
e.printStackTrace();
}
System.out.println(a);
}
}
/*
* java 数据库的链接
*/
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class MySQL {
static int a;
public static void main(String[] args){
Connection con = null; //定义与数据库链接的变量
Statement sta = null; //定义操纵sql语句的变量
ResultSet rs = null; //定义返回结果的变量
try{
try{
Class.forName("com.mysql.jdbc.Driver"); //加载mysql数据库的驱动
}catch(ClassNotFoundException e){
System.out.println("驱动没有找到");
}
//与数据库建立连接 getConnertion的三个参数分别是,数据库,账号,密码
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/student1","root","guest");
System.out.println("连接成功!");
sta = con.createStatement();
//通过操纵语句的变量操纵sql语句
rs = sta.executeQuery("select uid , uname from users");
//通过循环遍历把结果返回
while(rs.next()){
a= rs.getInt("uid");
System.out.println(rs.getString("uname"));
System.out.println(rs.getInt("uid"));
}
}catch(Exception e){
e.printStackTrace();
}
System.out.println(a);
}
}