java jdbc mysql如何连接急急急急急
来源:百度知道 编辑:UC知道 时间:2024/05/16 16:27:50
public class MySql4 {
public MySql4() {
JFrame f = new JFrame();
String[][] Info = new String[10][6];
String[] a = { " ", " ", " ", " ", " ", " " };
Info[0] = a;
for (int i = 0; i < 10; i++);
String[] Names = { "ID", "姓名", "爱好", "年龄", "学历", "性别" };
JTable t = new JTable(Info,Names);
DefaultTableModel dt = new DefaultTableModel();
t.setModel(dt);
// 以下是连接数据库
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("localhost", "root", "123");
Statement sta = con.createStatement();
ResultSet rs = sta.executeQuery("select * from gar");
ResultSetMetaData rsmd = rs.getMetaData();
int numberOfColumns = rsmd.getColumnCount()
public MySql4() {
JFrame f = new JFrame();
String[][] Info = new String[10][6];
String[] a = { " ", " ", " ", " ", " ", " " };
Info[0] = a;
for (int i = 0; i < 10; i++);
String[] Names = { "ID", "姓名", "爱好", "年龄", "学历", "性别" };
JTable t = new JTable(Info,Names);
DefaultTableModel dt = new DefaultTableModel();
t.setModel(dt);
// 以下是连接数据库
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("localhost", "root", "123");
Statement sta = con.createStatement();
ResultSet rs = sta.executeQuery("select * from gar");
ResultSetMetaData rsmd = rs.getMetaData();
int numberOfColumns = rsmd.getColumnCount()
第一,你url写的不对,也就是
Connection con = DriverManager.getConnection("localhost", "root", "123");
中的”localhost“应该为
"jdbc:mysql://localhost:3306/test";//数据库连接
第二,你导jar包了吗?
String mySqlDriver = "org.gjt.mm.mysql.Driver";
String url = "jdbc:mysql://localhost/test";//数据库连接
Connection conn;
Class.forName(mySqlDriver);
conn = DriverManager.getConnection( url,"root","cleversoft");//
首先确定你已经将mysql的驱动jar包导入项目中,还有一个致命错误就是你的url写法有问题,如下:
Connection con = DriverManager.getConnection("localhost", "root", "123");
还有一个重要的是数据库用完了后,要释放ResultSet,Statement,Connection。
java mysq l数据库的问题
java 中jdbc连接问题
JAVA 中JDBC和JDBC-ODBC的转换
JAVA访问数据库,JDBC驱动怎么配置?
java -jar为什么找不到连接jdbc驱动?
用ACCESS连接JAVA需要JDBC吗??
java.lang.ClassNotFoundException: sun.jdbc.odbc.jdbcodbcDriver
用jdbc连接数据库时出现java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDrive
什么叫java bean?和jsp、jdbc有什么关系?
JDBC如何配置和在JAVA中应用