JDBC操作数据库实例

[color=orange]一个JDBC操作数据库的一个示例：[/color]


注意：链接数据库需要用到一个JAR：
mysql-connector-java-5.1.30.jar


package sdfsdf;

package sdfsdf;

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

public class JDBC {
	private static final String URL = "jdbc:mysql://192.168.1.11:3306/anguea";
	private static final String USER = "root";
	private static final String PASSWORD = "root";

		public static void main(String[] args) throws ClassNotFoundException, SQLException {
			//1.加载驱动程序
			Class.forName("com.mysql.jdbc.Driver");
			//.获得数据库的链接
			Connection conn = DriverManager.getConnection(URL, USER, PASSWORD);
			//通过数据库的链接操作数据库，实现增删改查
			Statement stmt = conn.createStatement();
			ResultSet set =  stmt.executeQuery("select name,age from user");
			while(set.next()){
				System.out.println("姓名：" +set.getString("name") + "年龄：" + set.getInt("age"));
			}
		}
}

• mysql-connector-java-5.1.30.jar (931.7 KB)
• 下载次数: 0