import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet;

public class Test {

讯享网

讯享网</span><span style="color: rgba(0, 0, 255, 1)">public</span> <span style="color: rgba(0, 0, 255, 1)">static</span> <span style="color: rgba(0, 0, 255, 1)">void</span><span style="color: rgba(0, 0, 0, 1)"> main(String[] args){ </span><span style="color: rgba(0, 0, 255, 1)">try</span><span style="color: rgba(0, 0, 0, 1)">{ </span><span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">首先加载驱动</span> Class.forName("com.mysql.cj.jdbc.Driver"<span style="color: rgba(0, 0, 0, 1)">); </span><span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">提供JDBC连接的URL</span> String url="jdbc:mysql://<strong><span style="color: rgba(255, 0, 0, 1)">0.0.0.0</span></strong>:3306/<strong><span style="color: rgba(255, 0, 0, 1)">xxxx</span></strong>"<span style="color: rgba(0, 0, 0, 1)">; String username</span>="root"<span style="color: rgba(0, 0, 0, 1)">; String password</span>="root"<span style="color: rgba(0, 0, 0, 1)">; </span><span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">创建数据库的连接</span> Connection con =<span style="color: rgba(0, 0, 0, 1)"> DriverManager.getConnection(url,username,password); </span><span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">创建一个statement执行者</span> String sql="SELECT * FROM biz_spot WHERE spot_id = ?"<span style="color: rgba(0, 0, 0, 1)">; PreparedStatement statement </span>=<span style="color: rgba(0, 0, 0, 1)"> con.prepareStatement(sql); statement.setLong(</span>1,11L<span style="color: rgba(0, 0, 0, 1)">); </span><span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">执行SQL语句</span> ResultSet result =<span style="color: rgba(0, 0, 0, 1)"> statement.executeQuery(); </span><span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">处理返回结果</span> <span style="color: rgba(0, 0, 255, 1)">while</span><span style="color: rgba(0, 0, 0, 1)"> (result.next()){ System.out.println(result.getString(</span>"<strong><span style="color: rgba(255, 0, 0, 1)">xxx</span></strong>") + "---" + result.getString("<strong><span style="color: rgba(255, 0, 0, 1)">xxx</span></strong>"<span style="color: rgba(0, 0, 0, 1)">)); } </span><span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">关闭JDBC对象</span> 

con.close();

 result.close(); statement.close(); }</span><span style="color: rgba(0, 0, 255, 1)">catch</span><span style="color: rgba(0, 0, 0, 1)">(ClassNotFoundException e){ System.out.println(</span>"加载驱动失败！"<span style="color: rgba(0, 0, 0, 1)">); } </span><span style="color: rgba(0, 0, 255, 1)">catch</span><span style="color: rgba(0, 0, 0, 1)">(Exception e){ } } 

}