一.将工程中pgsql转换成mysql
1,修改数据库方言名:
<property name="hibernateProperties">
<!-- 各数据库对应的方言(Dialect) -->
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.format_sql">true</prop>
</props>
</property>
2,修改数据库连接配置信息
#pgsql
connection.driverclass=com.mysql.jdbc.Driver
#aliyun
connection.url=jdbc\:mysql\://localhost:3306/hotel
3.获取mysql驱动包。
compile group: 'mysql', name: 'mysql-connector-java', version: '5.1.17'
二.访问pgsql数据库:
JdbcPool pool = new JdbcPool();
Connection conn=null;
try {
conn=pool.getConnection();
conn.setAutoCommit(true);
CallableStatement proc=conn.prepareCall("{call databack(?)}");
proc.registerOutParameter(1, Types.INTEGER);
proc.execute();
int key= proc.getInt(1);
//System.out.print("dadad:"+key);
proc.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
连接过程:
public static final String DBDRIVER = "oracle.jdbc.derver.oracleDricer" ///数据库驱动
public static final String DBURL =“jdbc:oracle:thin:@localhost:1521:mldn”
public static final String DBUSER ="scott'
public static final String PASSWORD ="tiger'
Class.forName(DBDRIVER);
Connection con=DriverManager.getConnection(DBURL,DBUSER,PASSWORD);
String aql ="select mid ,name form menber"
PreparedStatement pstmt=conn.prepareStatement(sql);
ResultSet rs =pstmt.executeQuery();
while (){
int mid =rs.getInt(1);
}
conn.close
三.ServerSQL数据库连接:
String url="jdbc:sqlserver://ip地址:端口号;DatabaseName=TramCar";
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn=DriverManager.getConnection(url,"huatu","dc_1234");
/* String sql1 = " ";
PreparedStatement pstmt=conn.prepareStatement(sql1);
ResultSet rs=pstmt.executeQuery();