java jdbc 操作mysql 数据库 小例子

 1、编写JDBCdb.java  文件

package tests;

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

public class JDBCdb {
	private static final String URL = "jdbc:mysql://192.168.1.186:3306/test";
	private static final String USER = "root";
	private static final String PASSWORD = "root";
	
	
	public static void main(String[] args) throws Exception{
		Class.forName("com.mysql.jdbc.Driver");
		
		Connection conn = DriverManager.getConnection(URL,USER,PASSWORD);
		
		Statement stmt = conn.createStatement();
		ResultSet rs = stmt.executeQuery("select * from bao_goods where goods_id>0 order by goods_id desc limit 10");
		
		while(rs.next()) {
			System.out.println(rs.getString("title")+","+rs.getInt("goods_id"));
		}
		
	}
	


}

 

2、编写后 试运行