1、java連接MySQL數據庫需要有壹個驅動jar包
例如:mysql-connector-java-5.1.26-bin.jar,
該驅動jar可以自行百度搜索最新包下載放在項目的lib目錄下即可。
2、連接代碼如下
package?baidu.test.jsp;import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?javax.naming.spi.DirStateFactory.Result;
public?class?DbConnection?{
private?static?Connection?conn;
public?DbConnection()?{
String?drivername="com.mysql.jdbc.Driver"; String?username="root"; String?url="jdbc:mysql://localhost/jsptest?useUnicode=true&characterEncoding=UTF-8"; String?password=""; //加載驅動 try?{Class.forName(drivername);
}?catch?(ClassNotFoundException?e)?{
System.out.println("驅動加載失敗!");
e.printStackTrace();
}
//建立連接 try?{conn=DriverManager.getConnection(url,username,password);
}?catch?(SQLException?e)?{
System.out.println("數據庫連接失敗!");
e.printStackTrace();
}
}
//getResultSet
public?ResultSet?GetResultSet(String?sql)
{
ResultSet?rs=null;
//statemanage
try?{
Statement?st=conn.createStatement();
rs=st.executeQuery(sql);
}?catch?(SQLException?e)?{
System.out.println("狀態管理器創建失敗");
e.printStackTrace();
}
return?rs;
}
//DML
public?int?DML(String?sql)
{
int?count=-1;
try?{
Statement?statement=conn.createStatement();
count=statement.executeUpdate(sql);
}?catch?(SQLException?e)?{
System.out.println("狀態管理器創建失敗");
e.printStackTrace();
}
return?count;
}
}
3、可以新建service類來調用連接類裏面的getResultSet方法和DML,實現自己所需用的功能。