81,092
社区成员
发帖
与我相关
我的任务
分享
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver">
</property>
<property name="url"
value="jdbc:sqlserver://localhost:1433; DatabaseName=xy">
</property>
<property name="username" value="sa"></property>
<property name="password" value="xyz"></property>
</bean>
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.SQLServerDialect
</prop>
<prop key="show_sql">true</prop>
</props>
</property>
<property name="mappingResources">
<list>
</list>
</property>
</bean>
<bean id="transactionManager"
class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver">
</property>
<property name="url"
value="jdbc:sqlserver://localhost:1433; DatabaseName=xy">
</property>
<property name="username" value="sa"></property>
<property name="password" value="xyz"></property>
</bean>
public class sqltest {
public static void main(String[] srg) {
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; // 加载JDBC驱动
String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=xy"; // 连接服务器和数据库xy
String userName = "sa"; // 默认用户名
String userPwd = "xyz"; // 安装sql server 2005时的密码
Connection dbConn;
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("Connection Successful!"); // 如果连接成功 控制台输出Connection
// Successful!
} catch (Exception e) {
e.printStackTrace();
}
}
}
这个可以连接成功,import org.junit.Test;
import com.highsun.model.Employee;
import com.highsun.service.EmployeeService;
import factory.TestFactory;
public class EmployeeServiceTest {
@Test
public void serviceTest(){
EmployeeService employeeService = TestFactory.getEmployeeService();
Employee employee = new Employee();
employee.setEmployeename("1");
employee.setPhone("111");
employee.setEmail("x1@gmail.com");
employee.setLoginname("system");
employee.setPwd("system");
employee.setEmployeetype(new Integer(1));
employee.setSex(new Integer(0));
employeeService.addEmployee(employee);
//update
}
}
junit测试也正常,可以在数据库里找到插入的信息