è¿éä»ç»ä¸¤ç§æ¹å¼ï¼
ä¸ï¼jdbcé¾æ¥MySQLæ°æ®åºï¼
1ï¼å¦æä½ ç¨jdbcæ¹å¼ï¼åæç
§ä¸åæ¹å¼è¿è¡è¿æ¥ï¼
Aï¼æ³¨å驱å¨
Bï¼é¾æ¥æ°æ®åº
Cï¼æ§è¡sql
Dï¼è¿åç»æé
å¦ä¸ä¸ºä¸ä¸ªåºæ¬å®æ´æµç¨ï¼
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();
}
}
}
2ï¼å°æ³¨åï¼é¾æ¥å°è£
好ï¼æ§è¡sqlè¯å¥ï¼è¿åç»æéï¼ä»£ç å¦ä¸ï¼
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();
}
}
}
3ï¼æ¥è¯¢ç»æå¦ä¸ï¼
äºï¼å©ç¨æ¡æ¶é¾æ¥MySQLï¼è¿éæ¯springMVC+Mybatisæ¹å¼é¾æ¥ï¼ä¸»è¦æ¯é
ç½®æ件ï¼
config.propertiesæ件
validationQuery=SELECT 1
#jdbc_url=jdbc\:mysql\://110.80.10.198\:3306/irrigation?useUnicode\=true&characterEncoding\=UTF-8&zeroDateTimeBehavior\=convertToNull
#jdbc_username=root
#jdbc_password=2025900
jdbc_url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehaviorsss=convertToNull
jdbc_username=root
jdbc_password=123456
spring-mabatis.xmlæ件ï¼è¿è¡ç¸å
³é
ç½®
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="
http://www.springframework.org/schema/beans" xmlns:xsi="
http://www.w3.org/2001/XMLSchema-instance" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:aop="
http://www.springframework.org/schema/aop" xsi:schemaLocation="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.1.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.1.xsdhttp://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.1.xsd"> <!-- é
ç½®æ°æ®æº -->
<bean name="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
init-method="init" destroy-method="close">
<property name="url" value="${jdbc_url}" />
<property name="username" value="${jdbc_username}" />
<property name="password" value="${jdbc_password}" />
<!-- åå§åè¿æ¥å¤§å° -->
<property name="initialSize" value="0" />
<!-- è¿æ¥æ± æ大使ç¨è¿æ¥æ°é -->
<property name="maxActive" value="20" />
<!-- è¿æ¥æ± æå°ç©ºé² -->
<property name="minIdle" value="0" />
<!-- è·åè¿æ¥æ大çå¾
æ¶é´ -->
<property name="maxWait" value="60000" />
<!-- <property name="poolPreparedStatements" value="true" /> <property
name="maxPoolPreparedStatementPerConnectionSize" value="33" /> -->
<property name="validationQuery" value="${validationQuery}" />
<property name="testOnBorrow" value="false" />
<property name="testOnReturn" value="false" />
<property name="testWhileIdle" value="true" />
<!-- é
ç½®é´éå¤ä¹
æè¿è¡ä¸æ¬¡æ£æµï¼æ£æµéè¦å
³éç空é²è¿æ¥ï¼åä½æ¯æ¯«ç§ -->
<property name="timeBetweenEvictionRunsMillis" value="60000" />
<!-- é
ç½®ä¸ä¸ªè¿æ¥å¨æ± ä¸æå°çåçæ¶é´ï¼åä½æ¯æ¯«ç§ -->
<property name="minEvictableIdleTimeMillis" value="25200000" />
<!-- æå¼removeAbandonedåè½ -->
<property name="removeAbandoned" value="true" />
<!-- 1800ç§ï¼ä¹å°±æ¯30åé -->
<property name="removeAbandonedTimeout" value="1800" />
<!-- å
³éabandedè¿æ¥æ¶è¾åºé误æ¥å¿ -->
<property name="logAbandoned" value="true" />
<!-- çæ§æ°æ®åº -->
<!-- <property name="filters" value="stat" /> -->
<property name="filters" value="mergeStat" />
</bean>
<!-- myBatisæ件 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<!-- èªå¨æ«æentityç®å½, çæConfiguration.xmléçæå·¥é
ç½® -->
<property name="mapperLocations" value="classpath:com/fourfaith/*/mapping/*.xml" />
</bean>
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.fourfaith.**.dao" />
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
</bean>
<!-- é
ç½®äºå¡ç®¡çå¨ -->
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>
<!-- æ¦æªå¨æ¹å¼é
ç½®äºç© -->
<tx:advice id="transactionAdvice" transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="add*" propagation="REQUIRED" />
<tx:method name="append*" propagation="REQUIRED" />
<tx:method name="insert*" propagation="REQUIRED" />
<tx:method name="save*" propagation="REQUIRED" />
<tx:method name="update*" propagation="REQUIRED" />
<tx:method name="modify*" propagation="REQUIRED" />
<tx:method name="edit*" propagation="REQUIRED" />
<tx:method name="delete*" propagation="REQUIRED" />
<tx:method name="remove*" propagation="REQUIRED" />
<tx:method name="repair" propagation="REQUIRED" />
<tx:method name="delAndRepair" propagation="REQUIRED" />
<tx:method name="import*" propagation="REQUIRED" read-only="false"
rollback-for="java.lang.Exception" />
<tx:method name="get*" propagation="SUPPORTS" />
<tx:method name="find*" propagation="SUPPORTS" />
<tx:method name="load*" propagation="SUPPORTS" />
<tx:method name="search*" propagation="SUPPORTS" />
<tx:method name="datagrid*" propagation="SUPPORTS" />
<tx:method name="*" propagation="SUPPORTS" />
</tx:attributes>
</tx:advice>
<aop:config>
<aop:pointcut id="transactionPointcut"
expression="execution(* com...*.service..*Impl.*(..))" />
<aop:advisor pointcut-ref="transactionPointcut"
advice-ref="transactionAdvice" />
</aop:config>
<!-- é
ç½®druidçæ§spring jdbc -->
<bean id="druid-stat-interceptor"
class="com.alibaba.druid.support.spring.stat.DruidStatInterceptor">
</bean>
<bean id="druid-stat-pointcut" class="org.springframework.aop.support.JdkRegexpMethodPointcut"
scope="prototype">
<property name="patterns">
<list>
<value>com...*.service.*</value>
</list>
</property>
</bean>
<aop:config>
<aop:advisor advice-ref="druid-stat-interceptor"
pointcut-ref="druid-stat-pointcut" />
</aop:config>
</beans>
è¿æå¾å¤æ¹å¼å¯ä»¥å®ç°ï¼è¿éå°±ç®ç¥çæè¿°ä¸çªã