import java.lang.Class;
import java.sql.Connection;
import java.sql.SQLException;
public class DBTest
{
public static void main(String[] args)
{
try
{
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/demo";
String user = "root";
String password = "123";
Connection conn = DriverManager.getConnection(url,user,password);
String _sta = conn.isClosed();
System.out.println(_sta); }
catch (IOException e)
{
e.printStackTrace();
}
}
}
import java.sql.Connection;
import java.sql.SQLException;
public class DBTest
{
public static void main(String[] args)
{
try
{
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/demo";
String user = "root";
String password = "123";
Connection conn = DriverManager.getConnection(url,user,password);
String _sta = conn.isClosed();
System.out.println(_sta); }
catch (IOException e)
{
e.printStackTrace();
}
}
}
{
e.printStackTrace();
}
??????????????????????????
getConnection
public static Connection getConnection(String url,
String user,
String password)
throws SQLException试图建立到给定数据库 URL 的连接。DriverManager 试图从已注册的驱动程序集中选择一个适当的驱动程序。 参数:
url - jdbc:subprotocol:subname 形式的数据库 url
user - 数据库用户,连接是为该用户建立的
password - 用户的密码
返回:
到 URL 的连接
抛出:
SQLException - 如果发生数据库访问错误--------------------------------------------------------------------------------
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class DBTest
{
public static void main(String[] args)
{
try
{
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/bbb";
String user = "root";
String password = "123";
Connection conn = DriverManager.getConnection(url,user,password);
Statement stmt = conn.createStatement();
if(!conn.isClosed())
{
System.out.println("已连接!");
stmt.excuteUpdate("insert into table1(Name) values('123987')");
}
else
{
System.out.println("未连接!");
} }
catch (Exception e)
{
System.out.println("出错啊");
e.printStackTrace();
}
}
}
===============================
已连接上了,但是怎么执行这个语句啊,其中table1是数据库bbb中的一个表,只有两个字段,id(主键),Name
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBConnection {
private Connection con;
private String driverPath="com.mysql.jdbc.Driver";
private String url="jdbc:mysql://127.0.0.1:3306/soft0801";
private String user="root";
private String password="zhangsuhang";
public Connection getConnection(){
try {
Class.forName(driverPath);
con=DriverManager.getConnection(url,user,password);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return con;
}
}