1.Java连接Mysql数据库:
所需文件:Mysql驱动文件;使用方式:右键工程->BuildPath->Add External Archives选择Mysql驱动文件;以下为测试代码
数据库为mydb,表为studinfo ;字段为ID、Name、Age均为vnchar;
import java.sql.*;
public class MysqlDemo
{
public static void main(String args[])
{
// 驱动程序名
String driver = "com.mysql.jdbc.Driver";
// URL指向要访问的数据库名mydb
String url = "jdbc:mysql://127.0.0.1:3306/mydb";
// MySQL配置时的用户名
String user = "root"; // MySQL配置时的密码
String password = "1234";
try
{
// 加载驱动程序
Class.forName(driver);
// 连续数据库
Connection conn = DriverManager.getConnection(url, user, password);
if(!conn.isClosed())
System.out.println("Succeeded connecting to the Database!");
// statement用来执行SQL语句
Statement statement = conn.createStatement();
// 要执行的SQL语句
String sql = "select * from studinfo";
// 结果集
ResultSet rs = statement.executeQuery(sql);
while(rs.next())
{
String ID=rs.getString("ID");
String age= rs.getString("Age");
String name = rs.getString("Name");
System.out.println(ID + "\t" + name+"\t"+age);
}
rs.close();
conn.close();
}
catch(ClassNotFoundException e)
{
System.out.println("Sorry,can`t find the Driver!");
//e.printStackTrace();
}
catch(SQLException e)
{
//e.printStackTrace();
}
catch(Exception e)
{
// e.printStackTrace();
}
}
}