package com.cjt.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class MysqlTest {
/**
* @param args
* @throws ClassNotFoundException
* @throws SQLException
*/
public static void main(String[] args) throws ClassNotFoundException, SQLException {
// TODO Auto-generated method stub
Class.forName(“com.mysql.jdbc.Driver”);
//org.gjt.mm.mysql.Driver
Connection conn = null;
Statement stmt = null;
ResultSet rs =null;
String url = “jdbc:mysql://localhost:3306/mysql”;
conn = DriverManager.getConnection(url,”root”,””);
stmt = conn.createStatement();
rs = stmt.executeQuery(“select * from user”);
while(rs.next())
{
System.out.println(rs.getObject(1));
}
stmt.close();
conn.close();
}
}
发布者:全栈程序员-用户IM,转载请注明出处:https://javaforall.cn/100548.html原文链接:https://javaforall.cn
【正版授权,激活自己账号】: Jetbrains全家桶Ide使用,1年售后保障,每天仅需1毛
【官方授权 正版激活】: 官方授权 正版激活 支持Jetbrains家族下所有IDE 使用个人JB账号...