1.将所有的jar包都是放到web工程lib目录下,mysql-connector-java-x.x-bin.jar也是一样,把该JAR包拷贝到lib目录下即可
2用jdbc直接链接mysql代码如下
public static void main(String[] args) throws SQLException {
DriverManager.registerDriver(new com.mysql.jdbc.Driver())
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/day15", "root", "123456")
System.out.println(conn.getClass().getName())
Statement stmt = conn.createStatement()
ResultSet rs = stmt.executeQuery("select id,name,password,email,birthday from users")
while (rs.next()) {
System.out.println("-------------------------")
System.out.println(rs.getObject("id"))
System.out.println(rs.getObject("name"))
System.out.println(rs.getObject("password"))
System.out.println(rs.getObject("email"))
System.out.println(rs.getObject("birthday"))
}
rs.close()
stmt.close()
conn.close()
}
1、下载连接mysql数据库jar包,地址:http://files.cnblogs.com/files/xiaoxitest/mysql-connector-java-5.1.28.zip(因不支持上传.jar文件,下载后需要手动把扩展名改为.jar)2、将文件拷贝到Jmeter\lib\ext目录下,我的是:D:\Program Files\apache-jmeter-2.11\lib\ext
3、启动Jmeter,在测试计划点击浏览添加刚刚拷贝的jar包
java连接mysql数据库的步骤如下:首先要下载mysql-connection-java-5.0.16-bin.jar这个jar包(版本不一致没关系),然后在工程中导入该库文件。
然后写一个类(DBHelper)用来打开或关闭数据库:
package com.hu.demo
import java.sql.Connection
import java.sql.DriverManager
import java.sql.PreparedStatement
import java.sql.SQLException
public class DBHelper {
public static final String url = "jdbc:mysql://127.0.0.1/student"
public static final String name = "com.mysql.jdbc.Driver"
public static final String user = "root"
public static final String password = "root"
public Connection conn = null
public PreparedStatement pst = null
public DBHelper(String sql) {
try {
Class.forName(name)//指定连接类型
conn = DriverManager.getConnection(url, user, password)//获取连接
pst = conn.prepareStatement(sql)//准备执行语句
} catch (Exception e) {
e.printStackTrace()
}
}
public void close() {
try {
this.conn.close()
this.pst.close()
} catch (SQLException e) {
e.printStackTrace()
}
}
}
最后再写一个Demo类来执行相关查询 *** 作:
package com.hu.demo
import java.sql.ResultSet
import java.sql.SQLException
public class Demo {
static String sql = null
static DBHelper db1 = null
static ResultSet ret = null
public static void main(String[] args) {
sql = "select *from stuinfo"//SQL语句
db1 = new DBHelper(sql)//创建DBHelper对象
try {
ret = db1.pst.executeQuery()//执行语句,得到结果集
while (ret.next()) {
String uid = ret.getString(1)
String ufname = ret.getString(2)
String ulname = ret.getString(3)
String udate = ret.getString(4)
System.out.println(uid + "\t" + ufname + "\t" + ulname + "\t" + udate )
}//显示数据
ret.close()
db1.close()//关闭连接
} catch (SQLException e) {
e.printStackTrace()
}
}
}
这样就完成了mysql数据库的连接了。
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)