package com.sinosoft.test;
import java.sql.*;
public class DBTest {
//mysql驅(qū)動包名
? ? private static final StringDRIVER_NAME ="com.mysql.jdbc.Driver";
//數(shù)據(jù)庫連接地址
? ? private static final StringURL ="jdbc:mysql://IP(具體IP):3306/數(shù)據(jù)庫名()?useUnicode=true&characterEncoding=UTF-8&characterSetResults=UTF-8&zeroDateTimeBehavior=convertToNull";
//用戶名
? ? private static final StringUSER_NAME ="數(shù)據(jù)庫賬戶名";
//密碼
? ? private static final StringPASSWORD ="密碼";
public static void main(String[] args) {
Connection connection =null;
try {
//加載mysql的驅(qū)動類
? ? ? ? ? ? Class.forName(DRIVER_NAME);
//獲取數(shù)據(jù)庫連接
? ? ? ? ? ? connection = DriverManager.getConnection(URL,USER_NAME,PASSWORD);
//mysql查詢語句
? ? ? ? ? ? String sql ="SELECT productname FROM lrproduct";
PreparedStatement prst = connection.prepareStatement(sql);
//結(jié)果集
? ? ? ? ? ? ResultSet rs = prst.executeQuery();
while (rs.next()) {
System.out.println("用戶名:" + rs.getString("productname"));
}
rs.close();
prst.close();
}catch (Exception e) {
e.printStackTrace();
}finally {
if (connection !=null) {
try {
connection.close();
}catch (SQLException e) {
e.printStackTrace();
}
}
}
? ? }
}
jdbc
https://blog.csdn.net/u012075383/article/details/78254482
https://blog.csdn.net/u014631593/article/details/52791391
