数据库连接

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;


public class SqlConnect {
public static void main(String args[]){
//初始化
Connection cn=null;
PreparedStatement ps=null;
//加载驱动
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
//获得连接
cn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=xuesheng", "sa" , "wb124584");//此时的地址就是127.0.0.1
System.out.println("sqlserver数据库连接成功！");
ps = cn.prepareStatement("select * from xuesheng");
ResultSet rs = ps.executeQuery();
while(rs.next()){
System.out.println(rs.getString("xingming"));
}
rs.close();
ps.close();
cn.close();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}






Class.forName("org.gjt.mm.mysql.Driver");
            //指定url
            conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test", "root", "123");






<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="connection.url">jdbc:mysql:///hibernate_20120328</property>
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.username">root</property>
<property name="hibernate.connection.password">123</property>






    Connection conn = null;
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.53:1521:orcl", "wb", "wb");//此处的地址是建的数据库的那个属性上的地址;
        










            conn = ConnectUtil.getConn();  //oracle            
            String sql = "insert into Student(id,name,sex,age,jiguan,szyx) values(?,?,?,?,?,?)";
            st = conn.prepareStatement(sql);
            st.setInt(1,stu.getId());




     conn = ConnectUtil.getConn();
            st = conn.createStatement();
            String sql = "select id,name,sex,age,jiguan,szyx from student where name like '%"+name+"%'";           
            rs = st.executeQuery(sql);           
            if (rs.next()) {
                Student = new Student();
                Student.setId(rs.getInt("id"));
         


数据库连接池:


  <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
   <property name="driverClassName" value="org.gjt.mm.mysql.Driver"/>
   <property name="url" value="jdbc:mysql://localhost:3306/itcast?useUnicode\=true&amp;characterEncoding\=UTF-8"/>
   <property name="username" value="root"/>
   <property name="password" value="123"/>
  
<property name="initialSize" value="1"/>

<property name="maxActive" value="500"/>

<property name="maxIdle" value="2"/>

<property name="minIdle" value="1"/>
</bean>








<bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    <property name="dataSource" ref="dataSource"/>
    </bean>
    
<tx:annotation-driven transaction-manager="txManager"/>

<bean id="personService" class="cn.itcast.service.impl.PersonServiceBean">
<property name="dataSource" ref="dataSource"/>
</bean>








此处为Itcast的


<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
   <property name="driverClassName" value="org.gjt.mm.mysql.Driver"/>
   <property name="url" value="jdbc:mysql://localhost:3306/itcast?useUnicode\=true&amp;characterEncoding\=UTF-8"/>
   <property name="username" value="root"/>
   <property name="password" value="123"/>
  
<property name="initialSize" value="1"/>

<property name="maxActive" value="500"/>

<property name="maxIdle" value="2"/>

<property name="minIdle" value="1"/>
</bean>
 




此处为百思维的
<!-- 
<bean id="dataSource" class="org.logicalcobwebs.proxool.ProxoolDataSource">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="driverUrl" value="jdbc:mysql://localhost:3306/itcast?useUnicode=true&amp;characterEncoding=UTF-8&amp;zeroDateTimeBehavior=convertToNull"/>
<property name="user" value="root"/>
<property name="password" value="123"/>
    <property name="alias" value="dbpool"/>
    <property name="houseKeepingTestSql" value="select 1"/>
    <property name="maximumConnectionCount" value="5"/>
    <property name="minimumConnectionCount" value="1"/>
    <property name="delegateProperties" value="characterEncoding=utf-8"/>
</bean>
 -->




xml中的转义字符
&(逻辑与)  &amp;        
<(小于)    &lt;        
>(大于)    &gt;        
"(双引号)  &quot;      
'(单引号)  &apos; [/size]